Summary
Using stored procedures is an efficient way to submit SQL to a back-end database. However, one of the downsides is that the code is not as readable, because you must look in two places to really see all the code. In this chapter, you learned:
How to call a stored procedure to insert, delete, and retrieve data into/from a table in SQL Server from ADO.NET.
How to retrieve data from an output parameter provided by a stored procedure.
How to use both the SqlClient and OleDb namespaces when working with stored procedures.
TIP
This chapter, and the book in general, focuses on using Microsoft tools and technologies. If you're interested in working with other data sources, you'll be forced to use the OleDb namespace (at least, until a managed provider ...
Get ASP.NET Developer's JumpStart now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
