Is there any way to cast an ICE table, like UD07Table to a DataTable?
I cant do it explicitly, also unfortunately the Copy() method doesnt exist for the ICE tables.
//No
var UD07 = new Ice.Tablesets.UD07Table();
DataTable t = (DataTable)UD07;
//No
var UD07 = new Ice.Tablesets.UD07Table();
DataTable t = UD07.Copy();
Perhaps if i wasnt already 20,000 leagues under the sea with this current implementation (which is a rework of another consultant - that makes it 100x harder)
BufferCopy is a high speed copying API to copy between two objects without having to do a custom method to do a:
target.Field1 = source.Field1;
a few billion times for every possible combination of classes. It uses the same engine as two other similar APIs:
DataSetAdapter - Copies to and from a .NET System.Data.DataTable and an Ice.Tableset (Client side in an Impl)
TablesetAdpater - Copies from a SQL Reader into a Ice.Tableset (Server side in the ICE Data Layer from the Get Sprocs)
FYI - What makes these so bleeding fast is we are actually standing up those billion hard coded classes in memory and compiling them in memory on demand. We cache the resulting compiled copying code.
Hi @Bart_Elia how will be the syntax if I want to copy all the information from a Db.UD02 table into a DataTable? I tried with the example usage in Tip but I’m getting some compiling errors.