Permalink
Fetching contributors…
Cannot retrieve contributors at this time
51 lines (40 sloc) 3.44 KB
title ms.custom ms.date ms.prod ms.reviewer ms.suite ms.technology ms.tgt_pltfrm ms.topic ms.assetid caps.latest.revision author ms.author manager
Stored Procedures
03/30/2017
.net-framework
dotnet-ado
article
4d23dd7a-a85f-44ff-a717-af7d0950c0fc
3
JennieHubbard
jhubbard
jhubbard

Stored Procedures

[!INCLUDEvbtecdlinq] uses methods in your object model to represent stored procedures in the database. You designate methods as stored procedures by applying the xref:System.Data.Linq.Mapping.FunctionAttribute attribute and, where required, the xref:System.Data.Linq.Mapping.ParameterAttribute attribute. For more information, see The LINQ to SQL Object Model.

Developers using [!INCLUDEvs_current_short] would typically use the [!INCLUDEvs_ordesigner_long] 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.

Related Sections

Programming Guide
Provides information about how to create and use your [!INCLUDEvbtecdlinq] 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#.