private EntityType CreateEntityType(Microsoft.EntityFrameworkCore.ModelBuilder modelBuilder, String tableName)
{
if (!_entityTypes.TryGetValue(tableName, out EntityType entityType))
{
var dynamicTypeDefinition = TypeDefinitionManager.GetDynamicTypeDefinition(tableName);
EntityTypeBuilder entityTypeBuilder = modelBuilder.Entity(dynamicTypeDefinition.DynamicTypeType).ToTable(tableName);
entityType = (EntityType)entityTypeBuilder.Metadata;
foreach (DynamicPropertyInfo property in MetadataProvider.GetStructuralProperties(tableName))
{
String fieldName = dynamicTypeDefinition.AddShadowPropertyFieldInfo(property.Name, property.Type).Name;
PropertyBuilder propertyBuilder = entityTypeBuilder.Property(property.Type, property.Name).HasField(fieldName);
if (property.DatabaseGeneratedOption == DatabaseGeneratedOption.Identity)
{
propertyBuilder.ValueGeneratedOnAdd();
}
else if (property.DatabaseGeneratedOption == DatabaseGeneratedOption.Computed)
{
propertyBuilder.ValueGeneratedOnAddOrUpdate();
}
else
{
propertyBuilder.ValueGeneratedNever();
}
}
entityTypeBuilder.HasKey(MetadataProvider.GetPrimaryKey(tableName).ToArray());
_entityTypes.Add(tableName, entityType);
}
return(entityType);
}
private void CreateNavigationProperties(Microsoft.EntityFrameworkCore.ModelBuilder modelBuilder, String tableName)
{
foreach (String propertyName in MetadataProvider.GetNavigationProperties(tableName))
{
DynamicDependentPropertyInfo dependentInfo = MetadataProvider.GetDependentProperties(tableName, propertyName);
EntityType dependentEntityType = CreateEntityType(modelBuilder, MetadataProvider.GetTableName(dependentInfo.DependentEntityName));
EntityType principalEntityType = CreateEntityType(modelBuilder, MetadataProvider.GetTableName(dependentInfo.PrincipalEntityName));
var dependentProperties = new List <Property>();
foreach (String dependentPropertyName in dependentInfo.DependentPropertyNames)
{
dependentProperties.Add((Property)dependentEntityType.GetProperty(dependentPropertyName));
}
ForeignKey fkey = dependentEntityType.FindForeignKey(dependentProperties, principalEntityType.FindPrimaryKey(), principalEntityType);
if (fkey == null)
{
var principalProperties = new List <Property>();
foreach (String principalPropertyName in dependentInfo.PrincipalPropertyNames)
{
principalProperties.Add((Property)principalEntityType.GetProperty(principalPropertyName));
}
Key pkey = principalEntityType.FindKey(principalProperties);
if (pkey == null)
{
pkey = principalEntityType.AddKey(principalProperties);
}
fkey = dependentEntityType.AddForeignKey(dependentProperties, pkey, principalEntityType);
}
DynamicTypeDefinition dynamicTypeDefinition = TypeDefinitionManager.GetDynamicTypeDefinition(tableName);
if (dependentInfo.IsCollection)
{
Navigation navigation = fkey.HasPrincipalToDependent(propertyName);
navigation.SetField(dynamicTypeDefinition.GetCollectionFiledName(propertyName));
}
else
{
Navigation navigation = fkey.HasDependentToPrincipal(propertyName);
navigation.SetField(dynamicTypeDefinition.GetSingleFiledName(propertyName));
}
}
}