.NET architecture
A .NET environment consists of multiple components.
The components are as follows:
- Application
- The application is responsible for interacting with the user and for invoking ADO.NET interface functions. These interface functions submit SQL statements for processing by a file system or a database management system.
- Microsoft .NET Framework
- The .NET Framework comprises the Framework Class Library (FCL) and Common Language Runtime (CLR).
- Framework Class Library (FCL)
- The FCL is a library of classes, interfaces, and value types.
- Common Language Runtime (CLR)
- Applications that you write for the .NET Framework run in the Common Language Runtime (CLR).
- .NET Framework data provider
- A .NET Framework data provider enables applications to directly access and manipulate data
sources. To access and manipulate data sources, a .NET Framework data provider includes the
following key objects:
- Connection
- Connects to a data source.
- Command
- Runs a command against a data source.
- DataReader
- Reads data from a data source.
- DataAdapter
- Populates a DataSet object with data from the data source and ensures that any changes to the data in the DataSet object are reflected in the data source.
The .NET Framework data provider for the Netezza product is called the Netezza .NET Provider. The Netezza Performance Server .NET Provider supports Microsoft .NET Framework 4.5 or later and all NPS® data types. The Netezza Performance Server .NET Provider is integrated with Visual Studio 2012 or later and is delivered in Microsoft Windows DLL format.
The Netezza Performance Server .NET Provider is based on the ADO.NET 3.0 data provider specification. For a list of unsupported methods and properties from that specification, see Unsupported ADO.NET methods and properties. If you try to use one of the unsupported methods or properties, an exception is thrown.
- DataSet object
- A DataSet object contains rows and columns of data in the form of DataTable objects, along with information about that data.