Create DataContext methods mapped to stored procedures and functions (O/R Designer)

You can add stored procedures and functions to the O/R Designer as DataContext methods. Calling the method and passing in the required parameters runs the stored procedure or function on the database and returns the data in the return type of the DataContext method. For detailed information about DataContext methods, see DataContext methods (O/R Designer).

Note

You can also use stored procedures to override the default LINQ to SQL run-time behavior that performs Inserts, Updates, and Deletes when changes are saved from entity classes to a database. For more information, see How to: Assign stored procedures to perform updates, inserts, and deletes (O/R Designer).

Create DataContext methods

You can create DataContext methods by dragging stored procedures or functions from Server Explorer or **Database Explorer onto the O/R Designer.

Note

The return type of the generated DataContext method differs depending on where you drop the stored procedure or function on the O/R Designer. Dropping items directly onto an existing entity class creates a DataContext method with the return type of the entity class. Dropping items onto an empty area of the O/R Designer creates a DataContext method that returns an automatically generated type. You can change the return type of a DataContext method after adding it to the Methods pane. To inspect or change the return type of a DataContext method, select it and inspect the Return Type property in the Properties window. For more information, see How to: Change the return type of a DataContext method (O/R Designer).

Note

Your computer might show different names or locations for some of the Visual Studio user interface elements in this article. You might be using a different edition of Visual Studio or different environment settings. For more information, see Personalize the IDE.

To create DataContext methods that return automatically generated types

  1. In Server Explorer or Database Explorer, expand the Stored Procedures node of the database with which you are working.

  2. Locate the desired stored procedure and drag it onto an empty area of the O/R Designer.

    The DataContext method is created with an automatically generated return type and appears in the Methods pane.

To create DataContext methods that have the return type of an entity class

  1. In Server Explorer or Database Explorer, expand the Stored Procedures node of the database with which you are working.

  2. Locate the desired stored procedure and drag it onto an existing entity class in the O/R Designer.

    The DataContext method is created with the return type of the selected entity class and appears in the Methods pane.

Note

For information about changing the return type of existing DataContext methods, see How to: Change the return type of a DataContext method (O/R Designer).