February 2009
Maximilian Beller's Blog
by brianwaustin
Performance comparison between Linq, NHibernate and ADO.NET / Stored Procedures
May 2008
.NET Data Access Performance Comparison: ASP Alliance
by brianwaustin (via)
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
February 2008
1
(3 marks)
