Wouldn't you like to be able to call a stored procedure from .NET with one line of code?
The classes below show how to make this happen. Look at how easy it is to use!
Note:
Every experienced developer has code like this in their library. So, if this this is you, I challenge you to provide code that meets these criteria:
- Easier to use than mine
- Is designed for an entry level coder. In order to do this, I stripped out all the 'embellishments' that I have in my library code, with the aim of getting data access done QUICKLY. Quick is the word, and the code below is quick.
Public Class UsageExample
Sub Main()
'This is an example of calling a stored procedure with one line of code.
'in order to make this work, copy the following three classes into your code, then call them as you see below.
'this will execute a stored procedure
QuickDataAccess.dd_MyStoredProcedure("123", "GPSQL", "TWO").execute()
'this will call a stored procedure and return a dataset
Dim oDT As DataTable = QuickDataAccess.dd_MyStoredProcedure("123", "GPSQL", "TWO").getTable
End Sub
End Class