/// <summary> /// Creates a column property mapping for the specified /// data table and entity /// </summary> /// <param name="sourceTable"></param> /// <param name="entityType"></param> /// <returns></returns> public static ColumnPropertyMap Create(DataTable sourceTable, Type entityType) { ColumnPropertyMap map = new ColumnPropertyMap(); List <EntityPropertyInfo> properties = EntityInfoCache.Get(entityType); foreach (DataColumn column in sourceTable.Columns) { foreach (EntityPropertyInfo property in properties) { if (property.IsEntity || property.IsEntityList) { continue; } if (property.EffectiveDataColumnName.ToUpper().Trim() == column.ColumnName.ToUpper().Trim()) { map.Add(column.ColumnName, property); } } } return(map); }