public void CreateSchema()
{
DBschema = new DBschema();
foreach (var tableMap in TableMappings)
{
if (!tableMap.MappedType.GetTypeInfo().IsSubclassOf(typeof(Base)))
{
continue;
}
SQLiteCommand cmd = CreateCommand("PRAGMA table_info('" + tableMap.TableName + "');");
List <column_info_from_sqlite> sql_columns = cmd.ExecuteDeferredQuery <column_info_from_sqlite>().ToList();
TableInfo table = new TableInfo {
SqlName = tableMap.TableName,
Type = tableMap.MappedType,
TypeInfo = tableMap.MappedType.GetTypeInfo(),
TableMapping = tableMap
};
DBschema.Tables.Add(tableMap.MappedType, table);
foreach (var columnMap in tableMap.Columns)
{
EntityExtensionForORM.ColumnInfo ci = new EntityExtensionForORM.ColumnInfo();
ci.ClrName = columnMap.PropertyName;
ci.Type = columnMap.ColumnType;
ci.TypeInfo = ci.Type.GetTypeInfo();
ci.Property = table.Type.GetRuntimeProperty(columnMap.PropertyName);
ci.Table = table;
ci.IsNullable = columnMap.IsNullable;
ci.SqlName = columnMap.Name;
ci.IsPrimaryKey = ci.ClrName == "id";
column_info_from_sqlite cifs = sql_columns.Find(x => x.name == ci.SqlName);
ci.Index = cifs.cid;
table.Columns.Add(ci.ClrName, ci);
}
// scans all property
foreach (var property in tableMap.MappedType.GetRuntimeProperties())
{
string propname = property.Name;
EntityExtensionForORM.ColumnInfo ci;
if (!table.Columns.TryGetValue(propname, out ci))
{
ci = new EntityExtensionForORM.ColumnInfo();
ci.ClrName = propname;
ci.Type = property.PropertyType;
ci.TypeInfo = property.PropertyType.GetTypeInfo();
ci.Property = property;
ci.NotMapped = true;
ci.Table = table;
table.Columns.Add(propname, ci);
}
foreach (var customattr in property.CustomAttributes)
{
if (customattr.AttributeType == typeof(IgnoreAttribute))
{
ci.IgnoreAttribute = true;
continue;
}
if (customattr.AttributeType == typeof(PrivateData))
{
ci.PrivateDataAttribute = true;
continue;
}
if (customattr.AttributeType == typeof(CascadeDeleteAttribute))
{
ci.CascadeDeleteAttribute = true;
continue;
}
if (customattr.AttributeType == typeof(InversePropertyAttribute))
{
ci.InversePropertyAttribute = true;
ci.InversePropertyName = (string)customattr.ConstructorArguments[0].Value;
continue;
}
if (customattr.AttributeType == typeof(ForeignKeyAttribute))
{
ci.ForeignKeyAttribute = true;
ci.ForeignKeyName = (string)customattr.ConstructorArguments[0].Value;
}
}
}
// post processing
foreach (EntityExtensionForORM.ColumnInfo ci in table.Columns.Values)
{
if (ci.InversePropertyAttribute)
{
ci.GenericType = ci.Type.GenericTypeArguments[0];
//ci.GenericTypeInfo = ci.GenericType.GetTypeInfo();
}
}
}
}
public DbContext(DbConnect DbConnect_)
{
DbConnect = DbConnect_;
DBschema = DbConnect.DBschema;
}
