Previous Topic Next topic Print topic


ADO.NET

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 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
Previous Topic Next topic Print topic