Dynamic Mapping of Table Columns

[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 using an XML mapping file which
has the column names of the two tables mapped.
If yes, can anyone sugest how the mapping file can be
checked before data insertion.

Any help is appreciated.

Thank You

 

[Kathleen Dollard]

Bill,

I don't believe there's an automatic way to do this in ADO.NET. There may be
a third party solution, or you could roll your own fairly easily.