Chapter 15. Using Stored Procedures with ADO.NET

OBJECTIVES

  • Learn to execute stored procedures that return data

  • Learn to pass parameters to a stored procedure

  • Learn to use OUTPUT para-meters

It's likely that any reasonably sized database application will need to execute stored procedures at some point. You might use stored procedures to return data or to execute action queries. There are many reasons why you might want to use stored procedures as part of an ASP.NET application. We can't list them all, and you may have your own reasons. However, here are some of the more common reasons:

  • You have no choice—you need to retrieve or manipulate data, and you don't control the database server. Your DBA told you that you must use stored procedures.

  • Stored ...

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.

Start your free trial