DataContext methods that map to stored procedures and functions are displayed in the methods pane of the O/R Designer. The methods pane is the pane along the side of the Entities pane (the main design surface). The methods pane lists all DataContext methods that you have created by using the O/R Designer. By default, the methods pane is empty; drag stored procedures or functions from Server Explorer/Database Explorer onto the O/R Designer to create DataContext methods and populate the methods pane. For more information, see How to: Create DataContext Methods Mapped to Stored Procedures and Functions (O/R Designer).

Note:
Open and close the methods pane by right-clicking the O/R Designer and then clicking Hide Methods Pane or Show Methods Pane, or use the keyboard shortcut CTRL+1.

DataContext methods are those methods that map to stored procedures and functions in the database. You can create and add DataContext methods on the methods pane of the O/R Designer. There are two distinct types of DataContext methods; those that return one or more result sets, and those that do not:

• DataContext methods that return one or more result sets:

  Create this kind of DataContext method when your application just needs to run stored procedures and functions in the database and return the results. For more information, see How to: Create DataContext Methods Mapped to Stored Procedures and Functions (O/R Designer), [T:System.Data.Linq.ISingleResult'1], and IMultipleResults.

• DataContext methods that do not return result sets: such as Inserts, Updates, and Deletes for a specific entity class.

  Create this kind of DataContext method when your application has to run stored procedures instead of using the default LINQ to SQL behavior for saving modified data between an entity class and the database. For more information, see How to: Assign Stored Procedures to Perform Updates, Inserts, and Deletes (O/R Designer).

When you drag stored procedures and functions from Server Explorer/Database Explorer onto the O/R Designer, the return type of the generated DataContext method differs depending on where you drop the item. Dropping the 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 (in either pane) creates a DataContext method that returns an automatically generated type. The automatically generated type that is created has a name that matches the stored procedure or function name and properties that map to the fields returned by the stored procedure or function.

Note:
You can change the return type of a DataContext method after you add 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).

Objects you drag from the database onto the O/R Designer surface will be named automatically, based on the name of the objects in the database. If you drag the same object more than once, a number is appended to the end of the new name that differentiates the names. When database object names contain spaces, or characters not-supported in Visual Basic or C#, the space or invalid character is replaced with an underscore.

Tasks

Other Resources