Microsoft® .NET Compact Framework (Core Reference)

Using SQL Server Stored Procedures

Many system architects choose to use SQL Server stored procedures as part of their application designs, especially when a SQL Server is already being considered for data storage, because stored procedures provide centralized management of the SQL code, encapsulate all access to the data for performance tuning, and allow detailed security control. Stored procedures can be used for data retrieval, selection (to a given criteria), and manipulation.

Here are a few of the many advantages of using SQL Server stored procedures:

• Central control of SQL code

• Optimal speed for data operations

• Transactional control

• Data security

• Data access control

• Data selection and manipulation procedures common to all client applications

Some ...