Ado. Net Data Access Policy

I. Ado. Net Data Access Model

2. Two access policies

Policy 1: After the connection is enabled, create a dataset instance and use the data adapter to fill the instance. You can then use the data in the dataset. For example, bind a widget to a dataset member.

Policy 2: Open the connection and use SQL statements or stored procedures to directly perform operations on the database. Disconnect.

Iii. application scenarios of the two policies

Obviously, Policy 1 is suitable for fat windows app customersProgram; Policy 2 is suitable for Web Applications

Iv. Key Points

Compared with traditional ado, most programs that use ADO. NET areEach data operationAll adopt the "connection-operation-disconnection" model.