Sideway
output.to from Sideway
Draft for Information Only

Content

ADO.NET Component
 In This Section
 Related Sections
 See also
What's New in ADO.NET
 SqlClient Data Provider
 ADO.NET Entity Framework
 See also
  
 Source/Reference

ADO.NET Component

ADO.NET is a set of classes that expose data access services for .NET Framework programmers. ADO.NET provides a rich set of components for creating distributed, data-sharing applications. It is an integral part of the .NET Framework, providing access to relational, XML, and application data. ADO.NET supports a variety of development needs, including the creation of front-end database clients and middle-tier business objects used by applications, tools, languages, or Internet browsers.

In This Section

What's New in ADO.NET
Introduces features that are new in ADO.NET.

ADO.NET Overview
Provides an introduction to the design and components of ADO.NET.

Entity Framework
Describes how to create applications using the Entity Framework.

Securing ADO.NET Applications
Describes secure coding practices when using ADO.NET.

Data Type Mappings in ADO.NET
Describes data type mappings between .NET Framework data types and the .NET Framework data providers.

DataSets, DataTables, and DataViews
Describes how to create and use DataSets, typed DataSets, DataTables, and DataViews.

LINQ to DataSet
Provides information about LINQ to DataSet, including programming examples.

Retrieving and Modifying Data in ADO.NET
Describes how to connect to a data source and how to retrieve and modify data using Commands, DataReaders and DataAdapters.

SQL Server and ADO.NET
Describes how to work with features and functionality that are specific to SQL Server.

Oracle and ADO.NET
Describes features and behaviors that are specific to the .NET Framework Data Provider for Oracle.

Related Sections

Language-Integrated Query (LINQ) - C#
Provides links to LINQ topics and samples using C#.

Language-Integrated Query (LINQ) - Visual Basic
Provides links to LINQ topics and samples using Visual Basic.

WCF Data Services 4.5
Describes how to use WCF Data Services to deploy data services on the Web or an intranet that implement the Open Data Protocol (OData).

.NET Framework Development Guide
Provides links to information about standard development tasks in the .NET Framework.

Samples and tutorials
Provides a list of .NET samples and tutorials.

See also

What's New in ADO.NET

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

SqlClient Data Provider

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

  • The ConnectRetryCount and ConnectRetryInterval connection string keywords (ConnectionString) let you control the idle connection resiliency feature.

  • Streaming support from SQL Server to an application supports scenarios where data on the server is unstructured. See SqlClient Streaming Support for more information.

  • Support has been added for asynchronous programming. See Asynchronous Programming for more information.

  • Connection failures will now be logged in the extended events log. For more information, see Data Tracing in ADO.NET.

  • SqlClient now has support for SQL Server's high availability, disaster recovery feature, AlwaysOn. For more information, see SqlClient Support for High Availability, Disaster Recovery.

  • A password can be passed as a SecureString when using SQL Server Authentication. See SqlCredential for more information.

  • When TrustServerCertificate is false and Encrypt is true, the server name (or IP address) in a 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 the description of the Encrypt connection option in ConnectionString.

    If this change causes an existing application to no longer connect, you can fix the application using one of the following:

    • Issue a certificate that specifies the short name in the Common Name (CN) or Subject Alternative Name (SAN) field. This solution will work for database mirroring.

    • Add an alias that maps 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 Connecting to the Database Engine Using Extended Protection.

  • SqlClient supports connections to LocalDB databases. For more information, see SqlClient Support for LocalDB.

  • Type System Version=SQL Server 2012; is new value to pass to the Type System Version connection property. The Type System Version=Latest; value is now obsolete and has been made equivalent to Type System Version=SQL Server 2008;. For more information, see ConnectionString.

  • SqlClient provides additional support for sparse columns, a feature that was added in SQL Server 2008. If your application already accesses data in a table that uses sparse columns, you should see an increase in performance. The IsColumnSet column of GetSchemaTable indicates if a column is a sparse column that is a member of a column set. GetSchema indicates if a column is a sparse column (see SQL Server Schema Collections for more information). For more information about sparse columns, see Using Sparse Columns.

  • The assembly Microsoft.SqlServer.Types.dll, which contains the spatial data types, 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 Database Engine Features.

ADO.NET Entity Framework

The .NET Framework 4.5 adds APIs that enable new scenarios when working with the Entity Framework 5.0. For more information about improvements and features that were added to the Entity Framework 5.0, see the following topics: What’s New and Entity Framework Releases and Versioning.

See also

 

Source/Reference


©sideway

ID: 201000013 Last Updated: 13/10/2020 Revision: 0 Ref:

close

References

  1. Active Server Pages,  , http://msdn.microsoft.com/en-us/library/aa286483.aspx
  2. ASP Overview,  , http://msdn.microsoft.com/en-us/library/ms524929%28v=vs.90%29.aspx
  3. ASP Best Practices,  , http://technet.microsoft.com/en-us/library/cc939157.aspx
  4. ASP Built-in Objects,  , http://msdn.microsoft.com/en-us/library/ie/ms524716(v=vs.90).aspx
  5. Response Object,  , http://msdn.microsoft.com/en-us/library/ms525405(v=vs.90).aspx
  6. Request Object,  , http://msdn.microsoft.com/en-us/library/ms524948(v=vs.90).aspx
  7. Server Object (IIS),  , http://msdn.microsoft.com/en-us/library/ms525541(v=vs.90).aspx
  8. Application Object (IIS),  , http://msdn.microsoft.com/en-us/library/ms525360(v=vs.90).aspx
  9. Session Object (IIS),  , http://msdn.microsoft.com/en-us/library/ms524319(8v=vs.90).aspx
  10. ASPError Object,  , http://msdn.microsoft.com/en-us/library/ms524942(v=vs.90).aspx
  11. ObjectContext Object (IIS),  , http://msdn.microsoft.com/en-us/library/ms525667(v=vs.90).aspx
  12. Debugging Global.asa Files,  , http://msdn.microsoft.com/en-us/library/aa291249(v=vs.71).aspx
  13. How to: Debug Global.asa files,  , http://msdn.microsoft.com/en-us/library/ms241868(v=vs.80).aspx
  14. Calling COM Components from ASP Pages,  , http://msdn.microsoft.com/en-us/library/ms524620(v=VS.90).aspx
  15. IIS ASP Scripting Reference,  , http://msdn.microsoft.com/en-us/library/ms524664(v=vs.90).aspx
  16. ASP Keywords,  , http://msdn.microsoft.com/en-us/library/ms524672(v=vs.90).aspx
  17. Creating Simple ASP Pages,  , http://msdn.microsoft.com/en-us/library/ms524741(v=vs.90).aspx
  18. Including Files in ASP Applications,  , http://msdn.microsoft.com/en-us/library/ms524876(v=vs.90).aspx
  19. ASP Overview,  , http://msdn.microsoft.com/en-us/library/ms524929(v=vs.90).aspx
  20. FileSystemObject Object,  , http://msdn.microsoft.com/en-us/library/z9ty6h50(v=vs.84).aspx
  21. http://msdn.microsoft.com/en-us/library/windows/desktop/ms675944(v=vs.85).aspx,  , ADO Object Model
  22. ADO Fundamentals,  , http://msdn.microsoft.com/en-us/library/windows/desktop/ms680928(v=vs.85).aspx
close

Latest Updated LinksValid XHTML 1.0 Transitional Valid CSS!Nu Html Checker Firefox53 Chromena IExplorerna
IMAGE

Home 5

Business

Management

HBR 3

Information

Recreation

Hobbies 8

Culture

Chinese 1097

English 337

Reference 67

Computer

Hardware 151

Software

Application 202

Digitization 25

Latex 9

Manim 123

Numeric 19

Programming

Web 285

Unicode 494

HTML 65

CSS 59

ASP.NET 194

OS 391

DeskTop 7

Python 23

Knowledge

Mathematics

Formulas 8

Algebra 29

Number Theory 206

Trigonometry 18

Geometry 21

Calculus 67

Complex Analysis 21

Engineering

Tables 8

Mechanical

Mechanics 1

Rigid Bodies

Statics 92

Dynamics 37

Fluid 5

Fluid Kinematics 5

Control

Process Control 1

Acoustics 19

FiniteElement 2

Physics

Electric 27

Biology 1

Geography 1


Copyright © 2000-2020 Sideway . All rights reserved Disclaimers last modified on 06 September 2019