Stored Procedures (LINQ to SQL)

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: Use Stored Procedures to Return Rowsets (LINQ to SQL)
  Describes how to return rows of data and shows how to use an input parameter.

• How to: Use Stored Procedures that Take Parameters (LINQ to SQL)
  Describes how to use input and output parameters.

• How to: Use Stored Procedures Mapped for Multiple Result Shapes (LINQ to SQL)
  Describes how to provide for returns of multiple shapes in the same stored procedure.

• How to: Use Stored Procedures Mapped for Sequential Result Shapes (LINQ to SQL)
  Describes how to provide for multiple shapes where the return sequence is known.

• Customizing Operations By Using Stored Procedures (LINQ to SQL)
  Describes how to use stored procedures to implement insert, update, and delete operations.

• Customizing Operations by Using Stored Procedures Exclusively (LINQ to SQL)
  Describes how to use nothing but stored procedures to implement insert, update, and delete operations.

Related Sections

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

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

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