IMS Data Provider for Microsoft .NET overview
The IMS™ Data Provider for Microsoft .NET extends IMS support for the ADO.NET interface and delivers high-performing, secure access to IMS data.
IMS Data Provider for Microsoft .NET simplifies development of Microsoft .NET applications that are written in C#, Visual Basic, and other ADO.NET-compliant languages to access IMS data. This access eliminates the need for intermediate steps or tools, such as DB2® stored procedures, web services, InfoSphere® Classic Federated Server, and other third-party products, for access to IMS databases.
A .NET data provider features implementations of the following basic classes:
- Connection
- Establishes and manages a database connection.
- Command
- Executes an SQL statement against a database.
- DataReader
- Reads and returns result set data from a database.
- DataAdapter
- Links a DataSet instance to a database. Through a DataAdapter instance, the DataSet can read and write database table data.
This following diagram shows how the IMSConnection object in the data provider communication with the Distributed Relational Database Architecture™ (DRDA) server in IMS Connect and Open Database Manager (ODBM) on the host system. The DRDA server communicates with the SQL engine that enables the SQL support in the host native environment. The SQL engine takes advantage of the metadata in IMS catalog to access and manipulate IMS data.