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
andreyt
(andreyt)
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