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.
Accessing data from outside SQL Server entails connecting to SQL Server through a network library and a client library. When you use the .NET Framework with SQL Server, you use System.Data.dll as the client library and the ADO.NET programming model. ADO.NET is a provider-based model, similar in concept ...