Shulou(Shulou.com)06/02 Report--

This article mainly introduces "what are the rules of attention in the use of the ADO.NET model". In the daily operation, I believe that many people have doubts about the rules of attention in the use of the ADO.NET model. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts about the rules of attention in the use of the ADO.NET model. Next, please follow the editor to study!

Set the entity data ADO.NET model to add an ADO.NET Entity Data Model file to the project, choose to generate the model from the database, and hook up the table and stored procedure when selecting database objects, so as to complete the generation of the entity data model.

But if you use the ADO.NET model to CRUD the data at this time and do not use the stored procedure, we need to map the stored procedure. Queries are mapped differently from the other three operations, which we discuss separately.

Let's start with the import of query stored procedures. Right-click function Import in the Model browser and select create function Import.

In the pop-up dialog box, the ADO.NET model sets the name of a stored procedure to be used for the query, sets the name of the function to be used later to call the method, and sets the return type of the method.

Click OK to complete the settings, and there will be one more function at the function import in the ADO.NET model browser. Later, you can call this stored procedure through this function for data query.

Next, let's talk about inserting, updating, and deleting the mapping of stored procedures.

These three stored procedures need to be mapped to the entity class at the same time, the ADO.NET model means that if you map the stored procedure for the insertion method of an entity class, then updates and deletes must also map the stored procedure.

All three of our stored procedures operate on the User table, so select the UserInfo entity class and set it in the Mapping details tab to map entities to functions.

At this point, the study of "what are the rules related to the use of the ADO.NET model" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.