The Case for Specifying Data Types and Query Performance

Performance penalties for omitting SQL data types when using ADO.Net or light weight ORMs.

ADO.NET Entity Framework - SQL Server 2008

Access Your Data On Premise Or In The Cloud With ADO.NET Data Services

Web Services has been a hot topic for a number of years now, but what, you may wonder, are these Data Services everyone's talking about lately? As the architecture of Web applications has changed and matured (with the popularity of Rich Internet Applications [RIAs], for example), there has been an increased awareness of the value of exposing raw data, minus any interface or formatting, to any service or application that wants to consume it.

Data Access Tracing

Learn how to apply the new tracing functionality in Microsoft data access technologies such as ADO.NET 2.0, MDAC 2.82, SQL Server Native Client, and the JDBC driver; and in the SQL Server network protocols and the Microsoft SQL Server 2005 database engine. You can also download associated sample code for this article.

Managed Data Access Inside SQL Server with ADO.NET and SQLCLR

Using the new SQLCLR feature, managed code can use ADO.NET when running inside SQL Server 2005. Learn about SQLCLR via basic scenarios of in-process data access, SQLCLR constructs, and their interactions.

Implementing a Generic Data Access Layer in ADO.NET Part 1

In Part 1 of a 3 Part Series Joydip Kanjilal discusses the implementation of a provider independent Data Access Layer in ADO.NET.

XML Workshop XV - Accessing FOR XML results with ADO.NET

The next installment of Jacob Sebastian's great series on XML looks at how a .NET application might consume XML data returned from SQL Server.

Implementing a Generic Data Access Layer in ADO.NET Part 3

The 3rd and final of the 3 Part Series discussing the implementation of a provider independent Data Access Layer in ADO.NET.

Implementing a Generic Data Access Layer in ADO.NET Part 2

In Part 2 of a 3 Part Series Joydip Kanjilal discusses the implementation of a provider independent Data Access Layer in ADO.NET.

Implementing a Generic Data Access Layer in ADO.NET Part 1

In Part 1 of a 3 Part Series Joydip Kanjilal discusses the implementation of a provider independent Data Access Layer in ADO.NET.