Rocket® Enterprise Developer (formerly a product of Micro Focus or formerly a product of Open Text) documentation, created before Rocket Software acquired certain products from OpenText, may include outdated references to "Micro Focus" or "OpenText", both of which are trademarks of OpenText or its affiliates. Rocket Software is not affiliated with Micro Focus or OpenText and has since rebranded these products as Rocket® products. You may also encounter outdated links in this documentation. If you do, please contact Rocket Support (support@rocketsoftware.com) for assistance.
ADO.NET
Information specific to developing and maintaining managed SQL applications that access ADO.NET data sources.
Use OpenESQL with the ADO option to compile your managed applications. This option:
- Is invoked using the SQL(DBMAN=ADO) compiler directive
- Uses ADO.NET data providers
- Connects to one ADO.NET data source
- Compiles applications to communicate with the OpenESQL .NET Managed Runtime
- Enables EXEC SQL statements to communicate with the ADO.NET data provider and data source name specified
- Supports the use of EXEC ADO statements to create and manipulate ADO.NET objects
- Maximizes scalability of data handling components in distributed systems
- Is strongly biased in favour of optimistic (non-locking) concurrency control
- Fully supports disconnected and offline DataSets
- Supports dynamic SQL using PREPARE, EXECUTE and EXECUTE IMMEDIATE statements and cursors that use prepared statements, but only with host variable lists in the EXECUTE and OPEN statements