Stored Procedures

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. 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.

Programming Guide
Provides information about how to create and use your LINQ to SQL object model.

Walkthrough: Using Only Stored Procedures (Visual Basic)
Includes procedures that illustrate how to use stored procedures in Visual Basic.

Walkthrough: Using Only Stored Procedures (C#)
Includes procedures that illustrate how to use stored procedures in C#.