Overview of ADO.NET Whidbey

1
Overview ofADO.NET Whidbey
Scalable Development, Inc. Building systems today
that perform tomorrow.

• Wallace B. McClure
• Scalable Development, Inc.

2
EVERYTHING IS BETA.

• Your mileage may vary.
• Anything may change between now and shipment.
• December CTP of Sql Server 2005.
• Many thing will change between now and Beta 3.

3
Background

• Microsoft MVP.
• AspInsider.
• Author.

4
.NET Experiences

• PDC 2000 Build (July, 2000).
• Book work.
• Visual Studio Betas.
• Sql Server Betas.
• Production applications.
• Professional Programming with ADO.NET Version 2
  using Sql Server, Oracle, and MySql.

5
ADO.NET Whidbey Overview

• Favorite Objects are still there.
• Connections.
• Commands
• Datasets, DataTables, DataColumns, etc.
• Evolutionary, not revolutionary.

6
What databases are supported?

• Sql Server - Client. System.Data.SqlClient.
• Sql Server - Server. System.Data.Sql
  System.Data.SqlServer.
• Oracle. System.Data.OracleClient.
• ODBC. System.Data.Odbc.
• OleDb. System.Data.OleDb.

7
FYI Announced Server support for CLR Objects

• IBM DB/2 8.2 Shipping with support for .NET
  1.1.
• Sql Server 2005 Ship in 2005 with support for
  .NET 2.0.
• Oracle 10g Release 2 Ship in 2005

8
New Features of ADO.NET

• Asynchronous operations.
• MARS (Sql Server 2005 only).
• DataType Improvements.
• Connection string manager.
• Inside the database with Sql Server 2005.

9
Asynchronous Operations

• BeginABC/EndABC style.
• Type of operations.
• ExecuteNonQuery.
• ExecuteReader.
• ExecuteXmlReader.
• Example.

10
Asynchronous Operations

• Less need for managed threads.
• Built into .NET 2.0.
• Not thread safe.
• Yukon supports multiple commands per connection.
• Specific issue with shared memory and Sql 7 2k.

11
Multiple Active Result Sets(MARS)

• Multiple open commands on a single connection.
• Sql Server 2005 only.
• Example.

12
DataType Improvements

• Hard to get the field information through ADO.NET
  1.x.
• FillSchema() method only returns basic
  information.
• GetProviderSpecificFieldType().
• GetDataTypeName().
• Example.

13
Connection strings

• Connection strings arent very object based.
• SqlConnectionStringBuilder().
• Key/Value style.

14
Inside the Sql Server 2005 database with the CLR

• CLR Objects.
• Triggers.
• Stored Procedures.
• Functions.
• Aggregates.
• User Defined Types.
• System.Data.Sql System.Data.SqlServer
• Example.

15
Other features

• System.Transactions.
• Server enumeration.
• Password management.
• Bulk Copy.
• Provider Statistics.
• Caching support.

16
If you want to know more about ADO.NET
Whidbey/Yukon.

• http//weblogs.asp.net/wallym.
• http//weblogs.asp.net/despos.
• http//weblogs.asp.net/angelsb.
• http//msdn.microsoft.com.
• http//www.microsoft.com/sql.
• Professional ADO.NET Version 2 due in the
  summer of 2005. It makes a great gift. Buy 3 or
  4 for the ones you love.

17
Questions?
Scalable Development, Inc. Building systems today
that perform tomorrow.

• Wallace B. McClure
• wallym_at_scalabledevelopment.com.
• http//www.scalabledevelopment.com/
• http//weblogs.asp.net/wallym
• 865-693-3004.

END