In all data access methods provided by .NET Framework, SQL Server-based data access is a recommended selection of high performance and scales web applications. Additional performance improvements can be obtained by using a compiled stored procedure instead of a special query.
