.NET news » Database

xPort Tools for .NET is a 100% managed .NET component, which allows develop applications capable to provide extremely fast export of the ADO.NET DataSet/DataTable/DataView into the native Microsoft Excel, Microsoft Excel XML, CSV or HTML formats without using Excel itself or any additional tools and providers. xPort Tools for .NET provides fast and simple way to transfer your data with the minimum efforts.

Query Notification in SQL Server 2005 solves the problem of having to maintain a polling database to get the updated data. The new notification service of SQL Server 2005 can perform this amazing task of notifying a .NET code when any DML operations are performed to a specified table.

Just 200 lines of VB.NET to document your SQL Server databases.

Here's a question: If you write your application's code in an OO language - such as C#, VB.NET, or managed C++ - why not write database query and update code in the same language? It would certainly make life simpler, wouldn't it? At the very least, you'd only have to hold one language in your head - not your programming language and SQL.

Online Article: The Baker's Dozen: 13 Productivity Tips for ADO.NET 2.0

This installment of "The Baker's Dozen" presents a variety of tips and techniques to become productive with data handling techniques using ADO.NET 2.0 in Visual Studio 2005. ADO.NET 2.0 is faster than the first version of ADO.NET; in some instances, significantly faster. While many view ADO.NET 2.0 as more evolutionary than revolutionary, it provides many functions to give developers greater control over data access and data manipulation. It also leverages the new database capabilities in SQL Server 2005. In addition, ADO.NET 2.0 simplifies the creation of multiple-database solutions.

When you use SqlDataAdapter for performing updates, the SqlDataAdapter propagates the updates one by one. That means if there are 100 rows to be updated the SqlDataAdapter will execute 100 separate operations against the database. As you might have guessed this is not efficient while dealing with large number of rows. Fortunately SqlDataAdapter allows you to execute updates in batches. You can specify the batch size i.e. number of rows to be treated as a single batch via UpdateBatchSize property.

Many times you need to import data from different databases into your SQL Server database. If you do not have SQL Server Enterprise manager or similar tools then it becomes very tedious to import such data. This is especially true when you are working with SQL Server Express Edition or MSDE. BinaryIntellect Bulk Copy Tool allows you to import data from SQL Server, Access, Oracle and ODBC databases into your SQL Server database. Developed using new ADO.NET 2.0 features the tool is very easy to use and FREE.

Lattice.DataMapper is a tool that maps .NET objects to and from an underlying relational database using external XML configuration and mapping files. Features included object pre-fetch (one-to-one, one-to-many, and many-to-many), objects cache, batch job, distributed transaction.

If you develop an application using SQL Server data provider and later on decide to use Oracle you must change your code. At first thought using OLEDB data provider or ODBC data provider might come into your mind. However, considering the performance penalty that is not always a good idea. Won't it be nice to have a generic data access layer which will allow you to write provider independent code? That's exactly what this article will talk about.

Access-to-MySQL, one of the oldest tools to migrate Microsoft Access databases to MySQL server, has been updated. New version of the software converts relationships between tables.