New functions in ADO. NET and ADO. NET

New functions in ADO. NET and ADO. NET
New features in ADO. NET:. NET Framework (current version) 

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

SqlClient Data Provider

The following are new features of. NET Framework data provider for SQL Server in. NET Framework 4.5:

• ConnectRetryCount and ConnectRetryInterval allow you to control the idle connection restoration function.

• The SQL Server-to-application stream supports unstructured data on the Server. For more information, see SqlClient stream support.

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

• Connection faults are now recorded in the extended Event Log. For more information, see data tracking in ADO. NET.

• SqlClient now supports SQL Server's high availability and disaster recovery functions AlwaysOn. For more information, see SqlClient's support for high availability and disaster recovery.

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

• IfTrustServerCertificateIs false andEncryptIf the value is true, 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 will fail. For more information, see ConnectionStringEncryptOption description.

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

  • Issue a certificate to specify a short name in the public name (CN) or topic backup name (SAN) field. This solution applies to database images.

  • Add an alias to map a short name to a fully qualified domain name.

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

• SqlClient supports extended protection. For more information about extended protection, see connect to the Database Engine with extended protection.

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

• Type System Version = SQL Server 2012; is passedType System VersionThe new value of the connection property. Type System Version = Latest; the value is out of date. It is equivalent to Type System Version = SQL Server 2008. For more information, see ConnectionString.

• SqlClient provides additional support for sparse columns (features added in SQL Server 2008. If the application has accessed the data in tables that use sparse columns, the performance should be improved. The IsColumnSet column of GetSchemaTable indicates whether a column is a sparse column of the column integrator. GetSchema indicates whether a column is a sparse column (for more information, see SQL Server architecture set ). For more information about sparse columns, see use sparse columns.

• The Microsoft. SqlServer. Types. dll Assembly 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 major changes to the Database Engine feature.

ADO. NET Entity Framework

When used with Entity Framework 5.0,. NET Framework 4.5 adds an API to enable the new scheme. For more information about the improvements and features added to Entity Framework 5.0, see the following topics: New features (may be an English webpage) and Entity Framework release and Version Management (may be an English webpage ).

See ADO. NET

ADO. NET Overview
SQL Server and ADO. NET
What's New in WCF Data Services
ADO. NET hosting provider and dataset Developer Center

One's self-learning ability is very important and I hope it will help you !!!