Data Access BlogTips for implementing a Data Access Layer with .NET

Category: ADO.NET

Bulk insert in SQL Server 2005 using ADO.NET and XML

Written on November 7, 2008 by Luis Ramirez

Creating a bulk insert using a Stored Procedure and XML. One common task is to insert multiple records to a database. This article shows how to use XML to perform batch insertions efficiently.

ObjectDataSource Tips: Get output parameter after inserting

Written on October 29, 2008 by Luis Ramirez

Learn how to retrieve output parameters from stored procedures when using the ObjectDataSource control for insert operations.

Download Data Access samples

Written on October 29, 2008 by Luis Ramirez

Download sample projects demonstrating various data access techniques and best practices.