Dynamic Column Mapping

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Hi,
I need to take out records from one table and insert it
into another identical table via a C# application.Is there
a way to dynamically determine the corresponding columns
of the two tables ?

If I use an XML file to map the corresponding columns of
the two tables, how do I check the mapping file
dynamically before data insertion ?

Any help is appreciated.

Thank You
 
By dynamic mapping, I meant that before the records are
transferred from one table to the other(source to target),
the xml file which will have the field names of the two
tables mapped, is to be checked so that while formulating
the "insert into" statement, the column names of the
target table should match that of the source table.
 
Back
Top