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

ADO.NET Framework how to carry out data analysis, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain for you in detail, people with this need can come to learn, I hope you can gain something.

If you insist on using ADO.NET Framework in the .NET world, be prepared for some other effects, such as the need for additional code to use recordset from data-bound controls. Query, insert, update and delete operations, the first two methods are also often used in WEB-oriented environments and brand-new ADO.NET Framework systems.

Select the corresponding stored procedure name where the insert / update / delete function is selected, and then set the mapping of the property. ADO.NET Framework general stored procedure parameters are automatically mapped, but the foreign key column needs to be set manually.

The groupid in the Delete stored procedure is a useless parameter.

The reason for adding this parameter is that two entity classes are involved in both insert and update operations. If the navigation attribute Group is not mapped in the delete function, a 2048 error will be reported. Now, CRUD's stored procedures have been mapped.

Call stored procedure

Insert / update / delete operations only need to update entity classes using ADO.NET Framework and SaveChanges/DeleteObject these methods as usual. The query needs to be called explicitly.

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.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

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.