ADO.net best Practices

Question

Can any one guide me,the best practices for ado.Net both for webappliaction and windows application. If possible suggest me a best book to learn

Answer 1

Pragmatic ADO.NET is a pretty good place to start

Answer 2

Open connections in a "using" block so you don't forget to close the connections.

Answer 3

After learning main concepts, use Enterprise Library Data Access Application Block.