// private string PrimaryKey(ColumnMap map) { if (map.IsPrimaryKey) { return("PRIMARY KEY"); } else { return(string.Empty); } }
// private string Nullable(ColumnMap map) { if (map.AllowNull) { return("NULL"); } else { return("NOT NULL"); } }
private ICollection <ColumnMap> MapColumns(IEnumerable <PropertyInfo> properties) { var maps = new List <ColumnMap>(); foreach (var p in properties) { if (p.CanRead && p.CanWrite) { var colMap = new ColumnMap(); colMap.ColumnName = p.Name; colMap.IsPrimaryKey = p.Name.ToUpper() == "ID"; colMap.ColumnType = AdoDataType(p.PropertyType); colMap.ColumnSize = AdoDataSize(p.PropertyType); colMap.PropertyName = p.Name; colMap.PropertyType = p.PropertyType; colMap.AllowNull = !p.PropertyType.IsValueType && !colMap.IsPrimaryKey; // || p.PropertyType.IsAssignableFrom(typeof(Nullable)); maps.Add(colMap); } } return(maps); }