Export (0) Print
Expand All

How to: Create DataContext Methods Mapped to Stored Procedures and Functions (O/R Designer)

Stored procedures and functions can be added 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).

noteNote:
Stored procedures can also be used to override the default LINQ to SQL runtime 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).

Creating DataContext Methods

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

noteNote:
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).

To create DataContext methods that return automatically generated types

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

  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/Database Explorer, expand the Stored Procedures node of the database you are working with.

  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.

noteNote:
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).

See Also




Build Date:

2012-08-02
Show:
© 2014 Microsoft