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

This article introduces the relevant knowledge of "how to realize the data generation of ADO.NET Framework model". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Through these DataAdapter, we can retrieve data from the database and populate the tables in DataSet. It will establish two data tables with foreign key relationships and four stored procedures, namely query, insert, update and delete.

Set up the entity data model to add an ADO.NET Framework file to the project, choose to generate the model from the database, and hook up the tables and stored procedures when selecting database objects, so as to complete the generation of the entity data model.

But if you use ADO.NET Framework to CRUD data at this time and do not use stored procedures, we need to map stored procedures. 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, set to select a stored procedure name for the query, ADO.NET Framework sets the name of the function that will be used to call the method later, and sets the return type of the method.

This is the end of the content of "how to realize the data generation of ADO.NET Framework model". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.