.NET news » Database 
Beginning ASP.NET 2.0 and Databases (Wrox Beginning Guides)
Authors: John Kauffman, Bradley Millington
Average rating:
(2 reviews)
More .NET Database books
 |
Concurrent model in ADO.NET, ways those allow to negotiate disconnected model restrictions
The most popular instrument to access database data for .NET applications is ADO.NET. This set of components contains three main classes those are used to manipulate and store data: DataReader, DataSet and DataAdapter. DataReader is only able to read data and can't work as data source for data-aware components like DataGridView; DataSet provides all interfaces to be a data source but disconnected model considers some restrictions that can become important for some kind of applications, especially for desktop programs that work under multiuser concurrent environment and change database data actively. Below we consider main restrictions and popular ways to solve them; non standard solutions are considered also.
Data Points: Column Expressions, DataRelations, and Computations
This month John Papa fields some of his favorite questions regarding data manipulation with ADO.NET.
Application to migrate data between different environments using the ADO.NET 2.0 SqlBulkCopy
This article explains how to migrate data between different SQL Server environments.
A Lap Around SQL Server 2005 Compact Edition
With a new name, new capabilities, and a new focus, the product formerly called SQL Server Mobile Edition expands its reach to small-footprint desktop applications—and it's free!
Take a Leap Forward with ADO.NET vNext (Part 1)
ADO.NET vNext is a leap forward in database programming, using mapping files to isolate your applications from relational database schema changes, and letting you choose whether to deal with data directly as objects or as tabular data.
Dynamic XML from SQL Server
"Efficiency in simplicity", that's what XML is all about. XML is great for information exchange because of its simple flat file structure and user defined tags. For any application to interact with another either an complex marshalling code would be required or a simple implementation of XML would suffice. MS SQL gives us the advantage of generating dynamic XML in our data queries itself. In this article we will see some of the common used SQL XML queries.
When Snapshot Isolation Helps and When It Hurts
The benefits of SQL Server 2005's new snapshot isolation feature are well known, but SQL Server developers also need to understand the downstream ramifications of snapshot isolation.
Application to migrate data between different environments using ADO.NET 2.0 and C# windows forms
This article explains how to migrate data between different environments
Optimizing Serialization in .NET - part 2
Provides code and techniques to enable developers to optimize serialization of DataSets/DataTables.
ADO.Net on SqlServer 2005 Performance Tips
Presents Tips on how to handle SqlServer 2005 on ADO.Net