What's new in ADO

What 's new in ADO: The . NET Framework (current version)

The following are the new features of ADO. NET Framework 4.5.

SqlClient Data Provider

The following are new features of the. NET Framework Data Provider for SQL Server in the. NET Framework 4.5:

• The Connectretrycount and Connectretryinterval connection string keywords (ConnectionString) allow you to control the idle connection resiliency feature.

• SQL Server-to-application streaming support enables data on the server to be unstructured.  For more information, see SqlClient streaming support.

• Asynchronous programming support has been added.  For more information, see Asynchronous Programming.

• The connection failure is now logged in the extended event log.  For more information, see Data Tracking in ADO.

• sqlclient now supports high availability, disaster recovery features for SQL Server AlwaysOn.   sqlclient support for high availability, disaster recovery. " > For more information, see SqlClient Support for high availability, disaster recovery.   

• When using SQL Server authentication, the password can be passed as SecureString.  For more information, see sqlcredential.

• IfTrustServerCertificateis false andEncryptTrue, the server name (or IP address) in the SQL Server SSL certificate must exactly match the server name (or IP address) specified in the connection string.Otherwise, the connection attempt fails.  For more information, see the description of the Encrypt option in ConnectionString .

  If this change causes an existing application to no longer connect, you can repair the application in one of the following ways:

  • issue a certificate to specify a short name in the common name (CN) or Subject Alternative name (SAN) field.    This solution will work for database mirroring.   

  • add an alias to map the short name to the fully qualified domain name.

  • Use the fully qualified domain name in the connection string.

• SqlClient supports extended protection.  For more information about extended protection, see Connect to the database engine using extended protection.

• SqlClient supports connecting to the LocalDB database.  For more information, see SqlClient Support for LocalDB.

• type System Version=sql Server 2012; Is the new value passed to the type system Version Connection property.   type system version=latest; The value is now obsolete, which is equivalent to type system Version=sql Server 2008;  For more information, see ConnectionString.

• SqlClient provides additional support for sparse columns (new features in SQL Server 2008).If your application has access to data in tables that use sparse columns, you should see improved performance.the Iscolumnset column of getschematable Indicates whether a column is a sparse column that belongs to a column set member.  GetSchema Indicates whether a column is a sparse column (for more information, see SQL Server schema Collection).  For more information about sparse columns, see Working with sparse columns.

• Assembly Microsoft.SqlServer.Types.dll that contains the spatial data type has been upgraded from version 10.0 to version 11.0.  applications that reference this assembly may fail.  For more information, see Breaking changes to the database engine features.

The ado Entity Framework

When used with Entity Framework 5.0, the. NET Framework 4.5 Adds an API that enables new scenarios.  For more information about the improvements and features added to Entity Framework 5.0, see the following topics: What's new (possibly English web pages) and Entity Framework release and Versioning (possibly English pages).

Please seeado

ADO Overview
SQL Server and ADO
What ' s New in WCF Data Services
ADO Managed Provider and dataset Developer Center

A person's self-study ability is very important, hope to help everyone!!!

What's new in ADO