What is the best c# method you've seen for encapsulating an ADO.Net query

Question

We're building a simple ADO.Net infrastructure, and looking for the best practice for creating one or more objects/methods to handle queries to SQL Server.

Such a method could for example, take a connection string and a query (or stored proc), and return a datatable, dataset, etc., with the query results.

How has this worked best for you in the past? If you could mention what your method signature(s) looked like or include some code, that would be helpful.

Answer 1

Look at my post here, simple enough? :)

Answer 2

You might want to look at NHibernate, LINQ to SQL, ADO.NET Entity Framework or another ORM. They are mostly mature technologies to interact with ADO. Happy coding