The System.Data namespace is the core namespace of ADO .NET. It consists of the base classes for the ADO.NET architecture. All data providers use these classes. It defines classes that represent table, columns, row, and datasets some common classes from this namespace DataView, DataViewManager DataSet, DataTable, DataRow, DataColumn, and DataRelation. To use these classes in your applications, you need to add a reference to the System.Data namespace.
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.
System.Data and its five major supporting namespaces define the ADO.NET functionality. These namespaces reside in the System.Data.dll assembly. The major ADO.NET namespaces are the System.Data, System.Data.Common, System.Data.Oledb, Microsoft.Data.Odbc, System.Data.SqlClient, and System.Data.SqlTypes.
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 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 :-
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 :-
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.
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.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.
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.
System.Data and its five major supporting namespaces define the ADO.NET functionality. These namespaces reside in the System.Data.dll assembly. The major ADO.NET namespaces are the System.Data, System.Data.Common, System.Data.Oledb, Microsoft.Data.Odbc, System.Data.SqlClient, and System.Data.SqlTypes.
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 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 :-
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 :-
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.
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.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.
No comments:
Post a Comment