ADO.NET表列映射

关键字:TableMapping

             DataTableMappingCollection

             DataColumnMappingCollection

其中DataTableMappingCollection和DataColumnMappingCollection属于System.Data.Common命名空间.

TableMapping 

             .......................

          OleDbDataAdapter da=new OleDbDataAdapter(strSql,strCon);
          da.TableMappings.Add("Table","Customers");

           ....................

DataTableMappingCollection

   
   DataTableMappingCollection mc=da.TableMappings;
   mc.Add("Table","Customers");
   mc.Add("Table1","Oders");
   ..............

DataColumnMappingCollection

   DataColumnMappingCollection mc=da.TableMappings[0].ColumnMappings;
   mc.Add("CustomerID","ID");
   mc.Add("Phone","tel");

DataTableMappingCollection和DataColumnMappingCollection的AddRange方法提供添加多个项目;

  DataColumnMappingCollection cm=da.TableMapping[0].ColumnMappings;

  cm.AddRange(

                           new DataColumnMapping[ ]

                            {

                             new DataColumnMapping(),

                             new DataColumnMapping(),

                             ........................

                            }

                          );