Stored Procedures
.NET Framework 4.5
LINQ to SQL uses methods in your object model to represent stored procedures in the database. You designate methods as stored procedures by applying the FunctionAttribute attribute and, where required, the ParameterAttribute attribute. For more information, see The LINQ to SQL Object Model.
Developers using Visual Studio would typically use the Object Relational Designer to map stored procedures. Object Relational Designer (O/R Designer)
Object Relational Designer (O/R Designer) The topics in this section show how to form and call these methods in your application if you write the code yourself.
In This Section
- How to: Return Rowsets
- Describes how to return rows of data and shows how to use an input parameter.
- How to: Use Stored Procedures that Take Parameters
- Describes how to use input and output parameters.
- How to: Use Stored Procedures Mapped for Multiple Result Shapes
- Describes how to provide for returns of multiple shapes in the same stored procedure.
- How to: Use Stored Procedures Mapped for Sequential Result Shapes
- Describes how to provide for multiple shapes where the return sequence is known.
- Customizing Operations By Using Stored Procedures
- Describes how to use stored procedures to implement insert, update, and delete operations.
- Customizing Operations by Using Stored Procedures Exclusively
- Describes how to use nothing but stored procedures to implement insert, update, and delete operations.
Related Sections
Copyright © 2012 by Microsoft Corporation. All rights reserved.
Build Date:
