ADO.NET Changes from 1.0 to 1.1 of the Framework

The following are some of the differences between versions 1.0 and 1.1 of the framework that relate to ADO.NET:

• The following methods return a new exception when a transaction is deadlocked: Execute, ExecuteScalar, and Execute.NonQuery. The end result is that SQL Server will close a session involved in the deadlock and allow the other session to continue.

• OleDbConnection.OnStateChangeEvent is no longer fired when an invalid connection string is used.

• OleDbConnection.Open will no longer allow blank passwords.

• In version 1.0, DataSets with a value of "" (empty string) were treated as DBNULL. In version 1.1, they are treated as "" by default.

• OleDbCommand.ExecuteReader no longer throws an exception when CommandBehavior.SingleRow is used and no rows are returned.

• SqlClient in a partially trusted environment will work only with version 1.1.

• SqlClient.EnlistDistributedTransactions was added to allow a SqlClient to manually enlist in a distributed transaction.