Book excerpt: ADO.NET and SQL Server 2005

ADO.NET and System.Xml v. 2.0 -- The Beta Version explains the changes made to these important data programming models in the .NET Framework 2.0. These changes include a Database Schema Discovery API in ADO.NET 2.0 and a plethora of classes for reading, editing, validating and the customizing the serialization of XML documents.

Chapter 5, ADO.NET and SQL Server 2005, describes three areas of functionality in which the two data models share core functionality. The first is MARS, or Multiple Active Results Sets, whish allows more than one results set to be open at one time. The second is SQL Server query notifications, in which the server sends notification of any changes made to source data. The third is SQL Server user-defined types, which allows for the execution...

Digg This!     StumbleUpon     Del.icio.us

VIEW ALL IN THIS CATEGORY

RELATED CONTENT ADO.NET development Using the Visual Studio 2005 DataSet Designer to build a data access layer The fallacy of the data layer -- or, a new architectural model for software designs ADO.NET Entity Framework Beta 3 ships; ups LINQ-to-SQL performance SearchVB.com's Podcast Page Podcast: An introduction to Microsoft Astoria Microsoft Project Astoria brings data services to Web API battle Book excerpt: Data sources and datasets in ADO.NET 2.0 Book excerpt: An introduction to ADO.NET 2.0 What's ahead for ADO.NET in Visual Studio Orcas VSLive: .NET data access presents opportunities, challenges SQL Server and .NET development Microsoft releases new CTP of Oslo SDK Perpetuum unveils database synchronizer for .NET 2.0 The CTE, the hierarchical query and SQL Server 2005 SQL Server 2005 recursive functions and the CTE SQL Examiner Suite synchronizes data schema, sets DataDirect database drivers now support MySQL Top .NET tips of 2007 (so far) Addressing common SQL Server questions Book Excerpt: The .NET Framework and SQL Server 2005 Turn SQL data into script with SQL Populator Chapter Downloads Advanced Windows Debugging Book Chapter and Podcast Book excerpt: Murach's VB 2008 Book excerpt: Building personalized solutions in SharePoint 2007 Book excerpt: Java EE and .NET security interoperability Book excerpt: Building document management solutions in SharePoint 2007 Book excerpt: .NET Framework Design Guidelines Book excerpt: Advanced Windows Debugging Book excerpt: Pragmatic unit testing in C# with NUnit Book Excerpt: Executing activities in Windows Workflow Foundation Book excerpt: Hands-on Windows Communication Foundation

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

of managed code on the Web or application server, the client, and within SQL Server itself.

[IMAGE] Read the excerpt in this PDF file.