Abstract
Stored procedures are fixtures in the life of just about anyone who uses modern relational database systems such as Microsoft’s SQL Server. A stored procedure is a bit of code that lives on the database server and often acts as an abstraction layer isolating the code consuming the data from many of the details of the physical organization of the data. Stored procedures can increase performance by moving data-intensive computations closer to the data and can act as a data-side repository for business and security logic. The bottom line is that if you use data, you will at some point consume it through a stored procedure.
Keywords
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2010 Larry Tenny and Zeeshan Hirani
About this chapter
Cite this chapter
Tenny, L., Hirani, Z. (2010). Stored Procedures. In: Entity Framework 4.0 Recipes. Apress. https://doi.org/10.1007/978-1-4302-2704-5_10
Download citation
DOI: https://doi.org/10.1007/978-1-4302-2704-5_10
Publisher Name: Apress
Print ISBN: 978-1-4302-2703-8
Online ISBN: 978-1-4302-2704-5
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books