.NET news » Database

This article look at how to use the SqlBulkCopy class to efficiently execute bulk operations against Microsoft SQL Server.

This short introduction to.NET shows Access and SQL Server developers how to use a development tool to create connections to data and a user interface to manipulate that data.

SQL Server's new FILESTREAM feature simplifies the process of keeping file-based data, such as images, in sync with relational data.

SQL Server 2008 introduces four new date data types: time, date, datetime2, and datetimeoffset.

This article explores the time and date data types and shows how they can be used and formatted from within an ASP.NET page. This article also includes a short discussion on the datetime2 and datetimeoffset and compares and constrasts SQL Server 2008's six different date data types.

Take a look at two new patterns to help with database concurrency: SIP and SUP.

I have been browsing the Web for a good and simple class to handle delimited file imports. My current assignment has an import option that needs to deal with that. However, the current implementation (using StreamReader) is not good enough. It doesn't handle all the exceptions you encounter with delimited files. I found a number of examples on the Internet, but none of them really suited my needs. What I really missed was a simple example that I could extend so that it would suit my needs. So, being the developer that I am, I created my own class to import delimited files. After this was completed, I though I'd share it with others as an example.

C# Utility to automatically do the conversion from SQL Server DB to SQLite DB

Command line tool to check validity of objects in SQL Server databases.

Various ways to do Multiple Inserts in SQL Server 2000/2005 or Oracle Database using ADO.NET in single database round trip.

A introduction to the flexibilities provided by the use of SQL extended properties in business layer code templates.