Transcript Overview of ADO.NET Whidbey

Scalable Development, Inc.
Building systems today that perform tomorrow.
Overview of
ADO.NET Whidbey
Wallace
B. McClure
Scalable
Development, Inc.
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.
Background
 Microsoft
MVP.
 AspInsider.
 Author.
.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.”
ADO.NET Whidbey Overview
 Favorite
Objects are still there.
 Connections.
 Commands
 Datasets,
DataTables, DataColumns, etc….
 Evolutionary,
not revolutionary.
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.
FYI – Announced Server
support for CLR Objects
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
 IBM
New Features of ADO.NET
 Asynchronous
operations.
 MARS (Sql Server 2005 only).
 DataType Improvements.
 Connection string manager.
 Inside the database with Sql Server
2005.
Asynchronous Operations
 BeginABC/EndABC
 Type
of operations.
 ExecuteNonQuery.
 ExecuteReader.
 ExecuteXmlReader.
 Example.
style.
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.
Multiple Active Result Sets
(MARS)
 Multiple
open commands on a single
connection.
 Sql Server 2005 only.
 Example.
DataType Improvements
 Hard
to get the field information through
ADO.NET 1.x.
 FillSchema() method only returns basic
information.
 GetProviderSpecificFieldType().
 GetDataTypeName().
 Example.
Connection strings
 Connection
strings aren’t very object
based.
 SqlConnectionStringBuilder().
 Key/Value style.
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.
Other features
 System.Transactions.
 Server
enumeration.
 Password management.
 Bulk Copy.
 Provider Statistics.
 Caching support.
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.
Scalable Development, Inc.
Building systems today that perform tomorrow.
Questions?
Wallace B. McClure
 [email protected].
 http://www.scalabledevelopment.com/
 http://weblogs.asp.net/wallym
 865-693-3004.

END