Create IDASqlCommand, IDAConnectionm IDADataset for .NET

Data Abstract
1

With DA for Delphi I routinely use  IDASqlCommand, IDAConnectionm IDADataset with calls such as

lCxn : IDAConnection;
  lcmd : IDASQLCommand;
  lds : IDADataset;
begin
  lCxn := daCxnMgr.NewConnection(gCxnByName);
  lcmd := daSchema.NewCommand( lCxn, ‘myStoredProcedrue’ );
  lds := daSchema.NewDataset( lCxn, ‘mySchemaQuery’ );

How do I do each of these calls in RO/DA for .NET

Thanks in advance.
Monte

2

HelloMonte.

You can do the same using RemObjects DataAbstract as follows:

        IAbstractConnection con = Engine.connectionManager.AcquireNewConnection("SQLite.NET?Data Source=\\Bin\\PCTrade.sqlite.dbServer=localhost;",true);
        con.NewCommand("sp_test", System.Data.CommandType.StoredProcedure);
        con.NewDataTable("select * from Orders", parameters);

Also, see more about IAbstractConnection methods at http://wiki.remobjects.com/wiki/IAbstractConnection_Interface

Thanks