O'Reilly logo

Beginning C# 5.0 Databases, Second Edition by Vidya Vrat Agarwal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

C H A P T E R  6

Using Stored Procedures

A stored procedure is a collection of SQL statements that allows you to perform a task repeatedly. You can create the procedure once and reuse it any number of times in your program. This can improve the maintainability of your application and allow applications to access the database in a uniform and optimized manner. The goals of this chapter are to get you acquainted with stored procedures by creating and modifying them in SQL Server 2012 and to explain how C# programs can interact with them. This chapter covers the following:

  • Creating stored procedures
  • Modifying stored procedures
  • Displaying the definitions of stored procedures
  • Renaming stored procedures
  • Working with stored procedures in C#
  • Deleting ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required