Use Enterprise Library to improve your application system 3-Data Access Application Block

There is nothing to say, just summarize some best practices:
1. advantages of using Windows security mechanism for database connection: high security; disadvantages: low performance.
Advantages of database security mechanism for database connection: high performance and low security.
2. We recommend that you use stored procedures for data access instead of using "embedded SQL" to access the database.
Advantage: improved performance
Individually secured
Easier maintenance
An extra level of each action
Reduce network Trafic
3. Best practices for using dataset to access data:
Require a disconnected memory-resident cache.
In-memory relational view.
From multiple data soruce.
Update or submit.
Webcontrol Data Binding require ilist
Best practices for using dataread to access data:
Binary Large Object (BLOB) data
Large volumes
Webcontrol Data Binding require ienumerable
Reduce the memory footprint

Advantages of data access block:
Optimize the performance by caching dbcommand.