In-Process Data Access in SQL Server 2005
|Visual C# Tutorials|
In-Process Data Access
|© 2006 Pearson Education, Inc.|
|This tutorial—In-Process Data Access in SQL Server 2005—is from A Developer's Guide to SQL Server 2005, by Bob Beauchemin, Dan Sullivan. Copyright © 2006 Pearson Education, Inc. All rights reserved. This article is reproduced by permission. This tutorial has been edited especially for C# Online.NET. Read the book review!|
Whether you access data from the client, middle tier, or server, when you’re using SQL Server and the .NET Framework, you use the
SqlClient data provider. Your data access code is similar regardless of its location, but the .NET Framework 2.0 version of
SqlClient contains code to encapsulate differences when you’re programming inside SQL Server and optimize the in-server programming environment.