In-Process Data Access in SQL Server 2005

Visual C# Tutorials

Database Tutorials

In-Process Data Access Programming SqlClient SqlContext Class Connections Commands Obtaining Results Transactions Pipe New Rowsets WindowsIdentity Calling from SQLCLR Exception Handling SqlTriggerContext Classes You Can’t Use Where Are We?

© 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.