In-Process Data Access in SQL Server 2005

Learn that the .NET Framework 2.0 version of SqlClient contains code to encapsulate differences when you’re programming inside SQL Server and how to optimize the in-server programming environment. Excerpt: 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.