With the progress of the Times the development of science and technology ado.net Entity Data model version is also fast upgrade and upgrading, I will upgrade before and after the upgrade of Visual Studio, do their own interpretation. Hope to be helpful to everyone
These three stored procedures need to be mapped to the entity class at the same time, that is, if you map the stored procedure for an insert method for an entity class, the update and delete must also map the stored procedure, and our 3 stored procedures operate on the user table, so select the UserInfo entity class. Set the entity mapping to the Function tab in the mapping details.
Add a ado.net Entity data model to your project, choose to generate a model from the database, hook up the table and stored procedures when you select the database objects, and complete the production of the Entity data models.
But if you use the Ado.net framework to CRUD data and do not use stored procedures, I ado.net Entity the data model needs to map the stored procedures. The query and three other operations are mapped differently, and we discuss them separately.
First, query the import of stored procedures. Right-click the function import in the Model browser and select Create function Import.
In the dialog box that pops up, set the name of the stored procedure that you want to use for the query, Ado.net Entity Data set the function name that is used to invoke the method later, and set the return type of the method.