Programming with Stored Procedures

No programming language or tool would be considered complete without support for stored procedures, and of course you will find excellent support for stored procedures in the .NET Framework. As you probably know, your database provider will need to support stored procedures, and you will need to know how to write them (or know someone who does). All we have to do is transfer the knowledge from the old way to the new way.

Since stored procedures are generally an advanced topic for many developers, I will review the basic idea here. A stored procedure is analogous to a function. The difference between .NET stored procedures and functions is that stored procedures are written in a version of SQL and stored in the ...

Get Visual Basic® .NET Power Coding now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.