This question is locked. New answers and comments are not allowed.
Hello,
I am new to the ORM world, but so far have found it to my liking. Here is the problem I am trying to solve:
I have an old ASA Sybase database (8.03 - not supported by Open Access), I am getting data out of there by way of web service methods which return DataTables. I have generated the same table structure in SQL2005 and built Business objects. Those object fields are 1:1 with the columns in the DataTable.
Is there a way to load the information from the DataTable to the Business object that does not involve explicity doing all of assignments on a column by column basis?
Its not a big deal for 1 Table and 20 columns, but I am looking at 100+ tables and more than a thousand columns. I want to believe there is a generic way to set this up and execute it against any DataTable/Business Object whose columns/fields are identical in name and quantity.
My thanks in advance for any insight, thoughts, or suggestions that may be out there.
Kevin Westphal
I am new to the ORM world, but so far have found it to my liking. Here is the problem I am trying to solve:
I have an old ASA Sybase database (8.03 - not supported by Open Access), I am getting data out of there by way of web service methods which return DataTables. I have generated the same table structure in SQL2005 and built Business objects. Those object fields are 1:1 with the columns in the DataTable.
Is there a way to load the information from the DataTable to the Business object that does not involve explicity doing all of assignments on a column by column basis?
Its not a big deal for 1 Table and 20 columns, but I am looking at 100+ tables and more than a thousand columns. I want to believe there is a generic way to set this up and execute it against any DataTable/Business Object whose columns/fields are identical in name and quantity.
My thanks in advance for any insight, thoughts, or suggestions that may be out there.
Kevin Westphal