.NET Data Access Architecture Guide for SQL Server

By Bill Graziano on 2 June 2002 | Tags: Application Design , .NET

This document provides guidelines for implementing an ADO.NET-based data access layer in a multi-tier .NET application. It focuses on a range of common data access tasks and scenarios and presents guidance to help you choose the most appropriate approaches and techniques. This is a good article from MSDN on how to get the most out of SQL Server using .NET. It also includes a section on dealing with images (BLOBs).

Link: .NET Data Access Architecture Guide for SQL Server

Related Articles

Application Locks (or Mutexes) in SQL Server 2005 (7 January 2008)

SQL Server Connection Strings (14 November 2007)

What I Wish Developers Knew About SQL Server (Presentation) (11 October 2007)

Debugging Stored Procedures in Visual Studio 2005 (25 June 2007)

Multiple Active Result Sets (MARS) – Transactions and Debugging (17 June 2007)

Use SqlBulkCopy to Quickly Load Data from your Client to SQL Server (4 May 2007)

Multiple Active Result Sets (MARS) (3 April 2007)

Using SQL Server 2005 fulltext search from ASP.NET 2.0 (5 February 2007)

Other Recent Forum Posts

How to delete records selected from another table in stored procedure (8h)

Database Creation (12h)

Trying to learn SQL and need help writing a super easy query (1d)

How to replace stuff with string agg on sql server 2017? (2d)

I need Help with this test (2d)

Insert /Update query help sqlserver 2014 (3d)

Please help join two SELECT queries into one table (3d)

Want to convert time field into hour format (3d)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site