PUBLIC MARKS from ERSWeb with tag ado.net

Performance comparison between Linq, NHibernate and ADO.NET / Stored Procedures

In .NET, there are several ways to extract data from a data source. The two most common techniques using ADO.NET involve the use of the DataReader or the filling of a DataSet or DataTable with a DataAdapter. In this article, a very easy-to-reproduce set of tests is analyzed to determine which techniques performs the fastest. Further, additional variables such as N-Tier architecture and the effects of caching on the results are considered. Finally, I recommend some best practices based on the results

good stuff for perfmon