protected override DesignTimeMetadata GetDesignTimeMetadata(bool isDraft)
{
DesignTimeMetadata metadata = new DesignTimeMetadata();
IModel dbModel = DB.Model;
IEntityType[] allEntities = dbModel.GetEntityTypes().ToArray();
IEntityType[] plainEntities = allEntities.Where(t => !t.IsOwned()).ToArray();
Dictionary <string, IEntityType> ownedTypesMap = allEntities.Where(t => t.IsOwned()).ToDictionary(t => t.Name);
foreach (IEntityType entityInfo in plainEntities)
{
IEnumerable <IProperty> edmProps = entityInfo.GetProperties().Where(p => !p.IsShadowProperty()).ToArray();
// IEnumerable<string> edmProps1 = entityInfo.GetNavigations().Select(n => n.ForeignKey.DeclaringEntityType.Name).ToArray();
IEnumerable <INavigation> ownedTypes = entityInfo.GetNavigations().Where(n => ownedTypesMap.ContainsKey(n.ForeignKey.DeclaringEntityType.Name)).ToArray();
DbSetInfo dbSetInfo = new DbSetInfo
{
dbSetName = entityInfo.ClrType.Name
};
dbSetInfo.SetEntityType(entityInfo.ClrType);
metadata.DbSets.Add(dbSetInfo);
GenerateFieldInfos(metadata, entityInfo, dbSetInfo, edmProps, ownedTypes, ownedTypesMap);
GenerateAssociations(metadata, entityInfo, dbSetInfo);
}
return(metadata);
}
private void GenerateFieldInfos(DesignTimeMetadata metadata, IEntityType entityInfo, DbSetInfo dbSetInfo, IEnumerable <IProperty> edmProps, IEnumerable <INavigation> ownedTypes, Dictionary <string, IEntityType> ownedMap)
{
short pkNum = 0;
// Console.WriteLine($"Generate fields: {entityInfo.Name} FieldsCount: {edmProps.Count()}");
foreach (INavigation ownedNavigation in ownedTypes)
{
Field fieldInfo = new Field {
fieldName = ownedNavigation.Name
};
string nm = ownedNavigation.ForeignKey.DeclaringEntityType.Name;
IEntityType ownedType = ownedMap[nm];
IEnumerable <INavigation> nestedOwnedTypes = ownedType.GetNavigations().Where(n => ownedMap.ContainsKey(n.ForeignKey.DeclaringEntityType.Name)).ToArray();
GenerateOwnedTypeFieldInfos(fieldInfo, ownedType, nestedOwnedTypes, ownedMap);
dbSetInfo.fieldInfos.Add(fieldInfo);
}
DataService.Utils.IValueConverter valueConverter = ServiceContainer.ValueConverter;
foreach (IProperty edmProp in edmProps)
{
bool isContinue = false;
Field fieldInfo = new Field {
fieldName = edmProp.Name
};
try
{
fieldInfo.dataType = edmProp.ClrType.IsArrayType() ? DataType.None : valueConverter.DataTypeFromType(edmProp.ClrType);
}
catch (UnsupportedTypeException)
{
// Console.WriteLine($"{edmProp.Name} unsupported type {edmProp.ClrType.FullName}");
isContinue = true;
}
if (isContinue)
{
continue;
}
if (fieldInfo.fieldType != FieldType.Object)
{
UpdateFieldInfo(fieldInfo, edmProp);
if (edmProp.IsPrimaryKey())
{
++pkNum;
fieldInfo.isPrimaryKey = pkNum;
fieldInfo.isReadOnly = true;
}
}
dbSetInfo.fieldInfos.Add(fieldInfo);
}
}
private void GenerateAssociations(DesignTimeMetadata metadata, IEntityType entityInfo, DbSetInfo dbSetInfo)
{
IEnumerable <INavigation> childToParentNavs = entityInfo.GetNavigations().Where(n => n.IsOnDependent /*IsDependentToPrincipal() */);
foreach (INavigation childToParentNav in childToParentNavs)
{
GenerateAssociation(metadata, entityInfo, dbSetInfo, childToParentNav);
}
}
/*
* protected override AdventureWorksLT2012Context CreateDataContext()
* {
* var connection = _connectionFactory.GetRIAppDemoConnectionString();
* DbContextOptionsBuilder<AdventureWorksLT2012Context> optionsBuilder = new DbContextOptionsBuilder<AdventureWorksLT2012Context>();
* optionsBuilder.UseSqlServer(connection, (options)=> {
* // to support SQL SERVER 2008
* // options.UseRowNumberForPaging();
* });
* return new AdventureWorksLT2012Context(optionsBuilder.Options);
* }
*/
protected override DesignTimeMetadata GetDesignTimeMetadata(bool isDraft)
{
if (isDraft)
{
return(base.GetDesignTimeMetadata(true));
}
// first the uncorrected metadata was saved into xml file and then edited
return(DesignTimeMetadata.FromXML(ResourceHelper.GetResourceString("RIAppDemo.BLL.Metadata.MainDemo.xml")));
}
protected override DesignTimeMetadata GetDesignTimeMetadata(bool isDraft)
{
if (isDraft)
{
return(base.GetDesignTimeMetadata(true));
}
else
{
return(DesignTimeMetadata.FromXML(ResourceHelper.GetResourceString("RIAppDemo.BLL.Metadata.MainDemo2.xml")));
}
}
private void GenerateAssociation(DesignTimeMetadata metadata, IEntityType entityInfo, DbSetInfo dbSetInfo, INavigation childToParentNav)
{
INavigation inverseNavigation = childToParentNav.Inverse; //.FindInverse();
string assoc_name = string.Format("{0}_{1}", inverseNavigation.Name, childToParentNav.Name);
// Console.WriteLine($"Generate association: {assoc_name}");
Association assoc = metadata.Associations.Where(a => a.name == assoc_name).FirstOrDefault();
if (assoc == null)
{
IProperty[] principalProps = inverseNavigation.ForeignKey.PrincipalKey.Properties.ToArray();
IProperty[] childProps = childToParentNav.ForeignKey.Properties.ToArray();
assoc = new Association
{
name = assoc_name
};
IEntityType parentEntity = inverseNavigation.DeclaringEntityType;
IEntityType childEntity = childToParentNav.DeclaringEntityType;
assoc.parentDbSetName = parentEntity.ClrType.Name;
assoc.childDbSetName = childEntity.ClrType.Name;
assoc.childToParentName = childToParentNav.Name;
if (inverseNavigation != null)
{
assoc.parentToChildrenName = inverseNavigation.Name;
}
int i = 0;
foreach (IProperty pkProp in principalProps)
{
FieldRel frel = new FieldRel
{
childField = childProps?[i]?.Name,
parentField = pkProp.Name
};
assoc.fieldRels.Add(frel);
++i;
}
metadata.Associations.Add(assoc);
}
}
protected override DesignTimeMetadata GetDesignTimeMetadata(bool isDraft)
{
return(DesignTimeMetadata.FromXML(ResourceHelper.GetResourceString("RIAppDemo.BLL.Metadata.FolderBrowser.xml")));
}
protected override DesignTimeMetadata GetDesignTimeMetadata(bool isDraft)
{
DesignTimeMetadata metadata = new DesignTimeMetadata();
EntityContainer container = ObjectContext.MetadataWorkspace.GetEntityContainer(ObjectContext.DefaultContainerName, DataSpace.CSpace);
var entitySetsDic = (from meta in container.BaseEntitySets
where meta.BuiltInTypeKind == BuiltInTypeKind.EntitySet
select new { EntitySetName = meta.Name, EntityTypeName = meta.ElementType.Name }).ToDictionary(es => es.EntityTypeName);
ItemCollection CSpace = ObjectContext.MetadataWorkspace.GetItemCollection(DataSpace.CSpace);
ItemCollection SSpace = ObjectContext.MetadataWorkspace.GetItemCollection(DataSpace.SSpace);
EntityType[] entityEdmTypes = CSpace.GetItems <EntityType>().OrderBy(e => e.Name).ToArray();
ComplexType[] complexEdmTypes = CSpace.GetItems <ComplexType>().OrderBy(e => e.Name).ToArray();
Array.ForEach(complexEdmTypes, (entityEdmType) =>
{
string entityTypeName = entityEdmType.Name;
string name = entityTypeName;
string[] keys = entityEdmType.Members.Select(m => m.Name).Take(1).ToArray();
Type entityType = GetEntityType2(entityTypeName);
DbSetInfo dbSetInfo = new DbSetInfo()
{
dbSetName = entityTypeName
};
dbSetInfo.SetEntityType(entityType);
metadata.DbSets.Add(dbSetInfo);
EdmProperty[] edmProps = entityEdmType.Properties.ToArray();
GenerateFieldInfos(dbSetInfo, keys, edmProps);
});
Array.ForEach(entityEdmTypes, (entityEdmType) =>
{
if (entityEdmType.Abstract)
{
return;
}
string entityTypeName = entityEdmType.Name;
string name = entityTypeName;
if (entityEdmType.BaseType != null)
{
name = entityEdmType.BaseType.Name;
}
string[] keys = entityEdmType.KeyMembers.Select(k => k.Name).ToArray();
//var dbEntityEdm = dbEntityEdmTypes[dbTableName];
//Type entityType = this.GetEntityType(entitySetName);
//string entitySetName = entitySetsDic[name].EntitySetName;
Type entityType = GetEntityType2(entityTypeName);
DbSetInfo dbSetInfo = new DbSetInfo()
{
dbSetName = entityTypeName
};
dbSetInfo.SetEntityType(entityType);
metadata.DbSets.Add(dbSetInfo);
EdmProperty[] edmProps = entityEdmType.Properties.ToArray();
GenerateFieldInfos(dbSetInfo, keys, edmProps);
});
IOrderedEnumerable <AssociationType> associations = CSpace.GetItems <AssociationType>().Where(a => a.IsForeignKey).OrderBy(e => e.Name);
Func <EdmType, string> fn_name = (EdmType n) =>
{
if (n.FullName.Contains('['))
{
Regex regex = new Regex(".*?\\[(.*?)\\].*?");
Match match = regex.Match(n.FullName);
string table = match.Groups[1].Value;
return(table);
}
else
{
return(n.FullName);
}
};
foreach (AssociationType asstype in associations)
{
ReadOnlyMetadataCollection <RelationshipEndMember> endMembers = asstype.RelationshipEndMembers;
foreach (ReferentialConstraint constraint in asstype.ReferentialConstraints)
{
try
{
Association ass = metadata.Associations.Where(a => a.name == constraint.ToString()).FirstOrDefault();
if (ass == null)
{
RelationshipEndMember parentEnd = (constraint.FromRole.RelationshipMultiplicity == RelationshipMultiplicity.One || constraint.FromRole.RelationshipMultiplicity == RelationshipMultiplicity.ZeroOrOne) ? constraint.FromRole : constraint.ToRole;
RelationshipEndMember childEnd = constraint.FromRole == parentEnd ? constraint.ToRole : constraint.FromRole;
EdmType parent = parentEnd.TypeUsage.EdmType;
EdmType child = childEnd.TypeUsage.EdmType;
string parentName = fn_name(parent);
string childName = fn_name(child);
EntityType parentEntity = entityEdmTypes.Where(en => parentName == en.FullName).First();
EntityType childEntity = entityEdmTypes.Where(en => childName == en.FullName).First();
NavigationProperty parentToChildren = parentEntity.NavigationProperties.Where(np => np.FromEndMember.Name == parentEnd.Name && np.ToEndMember.Name == childEnd.Name).FirstOrDefault();
NavigationProperty childToParent = childEntity.NavigationProperties.Where(np => np.FromEndMember.Name == childEnd.Name && np.ToEndMember.Name == parentEnd.Name).FirstOrDefault();
ass = new Association
{
name = constraint.ToString()
};
metadata.Associations.Add(ass);
ass.parentDbSetName = parentEntity.Name;
ass.childDbSetName = childEntity.Name;
ass.parentToChildrenName = parentToChildren == null ? "" : parentToChildren.Name;
ass.childToParentName = childToParent == null ? "" : childToParent.Name;
EdmProperty[] parentArr = constraint.FromRole == parentEnd?constraint.FromProperties.ToArray() : constraint.ToProperties.ToArray();
EdmProperty[] childArr = constraint.FromRole == parentEnd?constraint.ToProperties.ToArray() : constraint.FromProperties.ToArray();
for (int i = 0; i < parentArr.Length; ++i)
{
FieldRel frel = null;
frel = ass.fieldRels.Where(fr => fr.parentField == parentArr[i].Name && fr.childField == childArr[i].Name).FirstOrDefault();
if (frel == null)
{
frel = new FieldRel();
ass.fieldRels.Add(frel);
frel.parentField = parentArr[i].Name;
frel.childField = childArr[i].Name;
}
}
}
}
catch (Exception)
{
throw;
}
}
}
return(metadata);
}
protected override DesignTimeMetadata GetDesignTimeMetadata(bool isDraft)
{
var metadata = new DesignTimeMetadata();
var container = this.DB.MetadataWorkspace.GetEntityContainer(this.DB.DefaultContainerName, DataSpace.CSpace);
var entitySetsDic = (from meta in container.BaseEntitySets
where meta.BuiltInTypeKind == BuiltInTypeKind.EntitySet
select new { EntitySetName = meta.Name, EntityTypeName = meta.ElementType.Name }).ToDictionary(es => es.EntityTypeName);
var CSpace = this.DB.MetadataWorkspace.GetItemCollection(System.Data.Metadata.Edm.DataSpace.CSpace);
var SSpace = this.DB.MetadataWorkspace.GetItemCollection(System.Data.Metadata.Edm.DataSpace.SSpace);
var entityEdmTypes = CSpace.GetItems <EntityType>().OrderBy(e => e.Name).ToArray();
//var dbEntityEdmTypes = SSpace.GetItems<EntityType>().ToDictionary(r => r.Name);
Array.ForEach(entityEdmTypes, (entityEdmType) =>
{
if (entityEdmType.Abstract)
{
return;
}
string entityTypeName = entityEdmType.Name;
string name = entityTypeName;
if (entityEdmType.BaseType != null)
{
name = entityEdmType.BaseType.Name;
}
string entitySetName = entitySetsDic[name].EntitySetName;
var keys = entityEdmType.KeyMembers.Select(k => k.Name).ToArray();
//string dbTableName = this.GetMappedEntitySetName(entitySetName);
//var dbEntityEdm = dbEntityEdmTypes[dbTableName];
//Type entityType = this.GetEntityType(entitySetName);
Type entityType = this.GetEntityType2(entityTypeName);
DbSetInfo dbSetInfo = new DbSetInfo()
{
dbSetName = entityTypeName
};
dbSetInfo.SetEntityType(entityType);
metadata.DbSets.Add(dbSetInfo);
var edmProps = entityEdmType.Properties.ToArray();
short pkNum = 0;
Array.ForEach(edmProps, (edmProp) =>
{
Field fieldInfo = new Field()
{
fieldName = edmProp.Name
};
if (keys.Contains(fieldInfo.fieldName))
{
++pkNum;
fieldInfo.isPrimaryKey = pkNum;
fieldInfo.isReadOnly = true;
}
bool isComputed = this.isComputed(edmProp);
fieldInfo.isAutoGenerated = this.isAutoGenerated(edmProp);
fieldInfo.isNullable = edmProp.Nullable;
fieldInfo.isReadOnly = fieldInfo.isAutoGenerated;
bool isArray = false;
string propType = edmProp.TypeUsage.EdmType.Name;
fieldInfo.dataType = this.DataTypeFromType(propType, out isArray);
var facets = edmProp.TypeUsage.Facets;
var maxLenFacet = facets.Where(f => f.Name == "MaxLength").FirstOrDefault();
if (maxLenFacet != null)
{
try
{
fieldInfo.maxLength = (short)Convert.ChangeType(maxLenFacet.Value, typeof(short));
}
catch
{
}
}
//gess that the property is rowversion
fieldInfo.fieldType = (isComputed && fieldInfo.dataType == DataType.Binary) ? FieldType.RowTimeStamp : FieldType.None;
dbSetInfo.fieldInfos.Add(fieldInfo);
});
});
var associations = CSpace.GetItems <AssociationType>().Where(a => a.IsForeignKey).OrderBy(e => e.Name);
Func <EdmType, string> fn_name = (EdmType n) =>
{
if (n.FullName.Contains('['))
{
Regex regex = new Regex(".*?\\[(.*?)\\].*?");
Match match = regex.Match(n.FullName);
string table = match.Groups[1].Value;
return(table);
}
else
{
return(n.FullName);
}
};
foreach (AssociationType asstype in associations)
{
var endMembers = asstype.RelationshipEndMembers;
foreach (ReferentialConstraint constraint in asstype.ReferentialConstraints)
{
try
{
Association ass = metadata.Associations.Where(a => a.name == constraint.ToString()).FirstOrDefault();
if (ass == null)
{
var parentEnd = (constraint.FromRole.RelationshipMultiplicity == RelationshipMultiplicity.One || constraint.FromRole.RelationshipMultiplicity == RelationshipMultiplicity.ZeroOrOne) ? constraint.FromRole : constraint.ToRole;
var childEnd = constraint.FromRole == parentEnd ? constraint.ToRole : constraint.FromRole;
var parent = parentEnd.TypeUsage.EdmType;
var child = childEnd.TypeUsage.EdmType;
string parentName = fn_name(parent);
string childName = fn_name(child);
var parentEntity = entityEdmTypes.Where(en => parentName == en.FullName).First();
var childEntity = entityEdmTypes.Where(en => childName == en.FullName).First();
var parentToChildren = parentEntity.NavigationProperties.Where(np => np.FromEndMember.Name == parentEnd.Name && np.ToEndMember.Name == childEnd.Name).FirstOrDefault();
var childToParent = childEntity.NavigationProperties.Where(np => np.FromEndMember.Name == childEnd.Name && np.ToEndMember.Name == parentEnd.Name).FirstOrDefault();
ass = new Association();
ass.name = constraint.ToString();
metadata.Associations.Add(ass);
ass.parentDbSetName = parentEntity.Name;
ass.childDbSetName = childEntity.Name;
ass.parentToChildrenName = parentToChildren == null ? "" : parentToChildren.Name;
ass.childToParentName = childToParent == null ? "" : childToParent.Name;
var parentArr = constraint.FromRole == parentEnd?constraint.FromProperties.ToArray() : constraint.ToProperties.ToArray();
var childArr = constraint.FromRole == parentEnd?constraint.ToProperties.ToArray() : constraint.FromProperties.ToArray();
for (int i = 0; i < parentArr.Length; ++i)
{
FieldRel frel = null;
frel = ass.fieldRels.Where(fr => fr.parentField == parentArr[i].Name && fr.childField == childArr[i].Name).FirstOrDefault();
if (frel == null)
{
frel = new FieldRel();
ass.fieldRels.Add(frel);
frel.parentField = parentArr[i].Name;
frel.childField = childArr[i].Name;
}
}
}
}
catch (Exception)
{
throw;
}
}
}
return(metadata);
}
public virtual string GenerateScript(string comment = null, bool isDraft = false)
{
DesignTimeMetadata metadata = Owner.GetDesignTimeMetadata(isDraft);
return(metadata.ToXML());
}
protected override DesignTimeMetadata GetDesignTimeMetadata(bool isDraft)
{
var metadata = new DesignTimeMetadata();
PropertyInfo[] dbsetPropList = this.DB.GetType().GetProperties().Where(p => p.PropertyType.IsGenericType && p.PropertyType.GetGenericTypeDefinition() == typeof(System.Data.Linq.Table <>)).ToArray();
Array.ForEach(dbsetPropList, (propInfo) =>
{
Type entityType = propInfo.PropertyType.GetGenericArguments().First();
DbSetInfo dbSetInfo = new DbSetInfo()
{
dbSetName = entityType.Name
};
dbSetInfo.SetEntityType(entityType);
metadata.DbSets.Add(dbSetInfo);
PropertyInfo[] fieldPropList = entityType.GetProperties().Where(p => p.IsDefined(typeof(System.Data.Linq.Mapping.ColumnAttribute), false)).ToArray();
short pkNum = 0;
Array.ForEach(fieldPropList, (propInfo2) =>
{
Field fieldInfo = new Field();
fieldInfo.fieldName = propInfo2.Name;
var colAttr = (System.Data.Linq.Mapping.ColumnAttribute)propInfo2.GetCustomAttributes(typeof(System.Data.Linq.Mapping.ColumnAttribute), false).First();
fieldInfo.isAutoGenerated = colAttr.IsDbGenerated;
if (colAttr.IsPrimaryKey)
{
fieldInfo.isPrimaryKey = ++pkNum;
}
if (!string.IsNullOrWhiteSpace(colAttr.DbType) && colAttr.DbType.IndexOf("Char(", StringComparison.OrdinalIgnoreCase) >= 0)
{
string len = System.Text.RegularExpressions.Regex.Match(colAttr.DbType, @"\(([^)]*)\)").Groups[1].Value;
int maxLength = -1;
if (int.TryParse(len, out maxLength))
{
fieldInfo.maxLength = (short)maxLength;
}
}
fieldInfo.dataType = propInfo2.PropertyType.IsArrayType() ? DataType.None : this.ServiceContainer.ValueConverter.DataTypeFromType(propInfo2.PropertyType);
if (colAttr.DbType.IndexOf("NOT NULL", StringComparison.OrdinalIgnoreCase) > 0)
{
fieldInfo.isNullable = false;
}
fieldInfo.fieldType = colAttr.IsVersion ? FieldType.RowTimeStamp : FieldType.None;
fieldInfo.isReadOnly = !propInfo2.CanWrite;
dbSetInfo.fieldInfos.Add(fieldInfo);
});
PropertyInfo[] navPropList = entityType.GetProperties().Where(p => p.IsDefined(typeof(System.Data.Linq.Mapping.AssociationAttribute), false)).ToArray();
Array.ForEach(navPropList, (propInfo3) =>
{
var attr = (System.Data.Linq.Mapping.AssociationAttribute)propInfo3.GetCustomAttributes(typeof(System.Data.Linq.Mapping.AssociationAttribute), false).First();
Association ass = metadata.Associations.Where(a => a.name == attr.Name).FirstOrDefault();
if (ass == null)
{
ass = new Association();
ass.name = attr.Name;
metadata.Associations.Add(ass);
}
FieldRel frel;
if (propInfo3.PropertyType.IsGenericType && propInfo3.PropertyType.GetGenericTypeDefinition() == typeof(System.Data.Linq.EntitySet <>))
{
frel = ass.fieldRels.Where(f => f.childField == attr.OtherKey && f.parentField == attr.ThisKey).FirstOrDefault();
if (frel == null)
{
frel = new FieldRel();
ass.fieldRels.Add(frel);
}
Type entityType3 = propInfo3.PropertyType.GetGenericArguments().First();
ass.childDbSetName = entityType3.Name;
ass.parentToChildrenName = propInfo3.Name;
frel.childField = attr.OtherKey;
frel.parentField = attr.ThisKey;
}
else
{
frel = ass.fieldRels.Where(f => f.childField == attr.ThisKey && f.parentField == attr.OtherKey).FirstOrDefault();
if (frel == null)
{
frel = new FieldRel();
ass.fieldRels.Add(frel);
}
ass.parentDbSetName = propInfo3.PropertyType.Name;
ass.childToParentName = propInfo3.Name;
frel.childField = attr.ThisKey;
frel.parentField = attr.OtherKey;
}
});
});
return(metadata);
}
