System.Data Namespaces

 
System_CAPS_noteNote

The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

The System.Data namespaces contain classes for accessing and managing data from diverse sources. The top-level namespace and a number of the child namespaces together form the ADO.NET architecture and ADO.NET data providers. For example, providers are available for SQL Server, Oracle, ODBC, and OleDB. Other child namespaces contain classes used by the ADO.NET Entity Data Model (EDM) and by WCF Data Services.

NamespaceDescription
System.Data

The System.Data namespace provides access to classes that represent the ADO.NET architecture. ADO.NET lets you build components that efficiently manage data from multiple data sources.

System.Data.Common

The System.Data.Common namespace contains classes shared by the .NET Framework data providers.

System.Data.Common.CommandTrees

The System.Data.Common.CommandTrees namespace provides classes to build expressions that make up a command tree.

System.Data.Common.CommandTrees.ExpressionBuilder

The System.Data.Common.CommandTrees.ExpressionBuilder namespace provides a command tree API.

System.Data.Common.CommandTrees.ExpressionBuilder.Spatial

The System.Data.Common.CommandTrees.ExpressionBuilder.Spatial namespace contains a class that represent the Entity Data Model (EDM) functions of a spatial.

System.Data.Common.EntitySql

The System.Data.Common.EntitySql namespace includes the EntitySqlParser class and other support classes. These classes enable you to parse an Entity SQL query string and create a command tree query.

System.Data.Design

The System.Data.Design namespace contains classes that can be used to generate a custom typed-dataset.

System.Data.Entity.Design

The System.Data.Entity.Design namespace contains classes to generate Entity Data Model (EDM) files and object source code.

System.Data.Entity.Design.AspNet

The System.Data.Entity.Design.AspNet namespace contains the Entity Data Model (EDM) build providers for the ASP.NET build environment.

System.Data.Entity.Design.PluralizationServices

The T:System.Data.Entity.Design.PluralizationServices namespace provides classes for changing words from singular to plural form, and vice versa.

System.Data.EntityClient

The System.Data.EntityClient namespace is the .NET Framework Data Provider for the Entity Framework.

System.Data.Linq

The System.Data.Linq namespace contains classes that support interaction with relational databases in LINQ to SQL applications.

System.Data.Linq.Mapping

The System.Data.Linq.Mapping namespace contains classes that are used to generate a LINQ to SQL object model that represents the structure and content of a relational database.

System.Data.Linq.SqlClient

This API supports the product infrastructure and is not intended to be used directly from your code. The System.Data.Linq.SqlClient namespace contains provider classes for communicating with SQL Server and classes that contain query helper methods.

System.Data.Linq.SqlClient.Implementation

This API supports the product infrastructure and is not intended to be used directly from your code. The System.Data.Linq.SqlClient.Implementation namespace contains types that are used for the internal implementation details of a SQL Server provider.

System.Data.Mapping

The System.Data.Mapping namespace provides access to the MappingItemCollection and StorageMappingItemCollection classes.

System.Data.Metadata.Edm

The System.Data.Metadata.Edm namespace contains a set of types that represent concepts throughout the models used by the Entity Framework and a set of classes that help applications to work with metadata. 

System.Data.Objects

The System.Data.Objects namespace includes classes that provide access to the core functionality of Object Services. These classes enable you to query, insert, update, and delete data by working with strongly typed CLR objects that are instances of entity types. Object Services supports both Language-Integrated Query (LINQ) and Entity SQL queries against types that are defined in an Entity Data Model (EDM). Object Services materializes the returned data as objects and propagates object changes back to the data source. It also provides facilities for tracking changes, binding objects to controls, and handling concurrency. For more information, see Object Services Overview (Entity Framework).

System.Data.Objects.DataClasses

The System.Data.Objects.DataClasses namespace includes classes that are base classes for types that are defined in an Entity Data Model (EDM), base classes for the types that are returned by navigation properties, and classes that define attributes that map common language runtime (CLR) objects to types in the conceptual model.

System.Data.Objects.SqlClient

The System.Data.Objects.SqlClient namespace provides the SqlFunctions class, which contains common language runtime (CLR) methods that translate to database functions. Methods in the SqlFunctions class can only be used in LINQ to Entities queries.

System.Data.Odbc

The System.Data.Odbc namespace is the .NET Framework Data Provider for ODBC.

System.Data.OleDb

The System.Data.OleDb namespace is the.NET Framework Data Provider for OLE DB.

System.Data.OracleClient

The System.Data.OracleClient namespace is the .NET Framework Data Provider for Oracle.

System.Data.Services

Provides access to classes used to build WCF Data Services.

System.Data.Services.BuildProvider

Classes in this namespace generate C# or Visual Basic code for a WCF Data Services client application based on the metadata returned by the data service.

System.Data.Services.Client

Represents the .NET Framework client library that applications can use to interact with WCF Data Services.

System.Data.Services.Common

Implements functionality common to both WCF Data Services client and server runtimes.

System.Data.Services.Configuration

This namespace provides configuration settings for WCF data services features.

System.Data.Services.Design

Used by the code generation command line tools and tools in Visual Studio to generate strongly-typed client side objects for communicating with data services.

System.Data.Services.Internal

This class is not for public use and is used internally by the system to implement support for queries with eager loading of related entities.

System.Data.Services.Providers

Provides a series of interfaces that are implemented to define a custom data service provider for WCF Data Services. 

System.Data.Spatial

The System.Data.Spatial namespace that contains classes of spatial database functionality.

System.Data.Sql

The System.Data.Sql namespace contains classes that support SQL Server-specific functionality.

System.Data.SqlClient

The System.Data.SqlClient namespace is the.NET Framework Data Provider for SQL Server.

System.Data.SqlTypes

The System.Data.SqlTypes namespace provides classes for native data types in SQL Server. These classes provide a safer, faster alternative to the data types provided by the .NET Framework common language runtime (CLR). Using the classes in this namespace helps prevent type conversion errors caused by loss of precision. Because other data types are converted to and from SqlTypes behind the scenes, explicitly creating and using objects within this namespace also yields faster code.

Return to top
Show: