//
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);
}