private void CreateStorageEntityTypeProperties(ISchemaEntity entity, EntityTypeStore entityType)
{
//<Property Name="CategoryId" Type="varchar" Nullable="false" MaxLength="10" />
foreach (ISchemaProperty property in entity.Properties) {
var entityProperty = entityType.Properties.Where(p => property.KeyName.Equals(p.Name, StringComparison.OrdinalIgnoreCase) || property.KeyName.Equals(p.Name, StringComparison.OrdinalIgnoreCase)).FirstOrDefault();
if (entityProperty == null) {
if (ExcludeProperty(property))
continue;
entityProperty = new EntityProperty() {
Name = property.KeyName
};
entityType.Properties.Add(entityProperty);
_newStorageEntityProperties.Add(String.Format("{0}-{1}", entity.Name, property.Name));
} else if (ExcludeProperty(property)) {
entityType.Properties.Remove(entityProperty);
continue;
}
entityProperty.Name = property.KeyName;
entityProperty.Type = GetNativeType(property);
if (!property.IsNullable)
entityProperty.Nullable = property.IsNullable;
if (String.IsNullOrEmpty(entityProperty.DefaultValue) && !String.IsNullOrEmpty(property.DefaultValue)) {
if (property.DefaultValue.ToLowerInvariant().Contains("autoincrement")) // Needed for sql anywhere
entityProperty.DefaultValue = null;
else if (String.Equals(property.BaseSystemType, "System.Boolean", StringComparison.OrdinalIgnoreCase))
entityProperty.DefaultValue = property.DefaultValue.ToLower();
else if (String.Equals(property.BaseSystemType, "System.Single", StringComparison.OrdinalIgnoreCase)
|| String.Equals(property.BaseSystemType, "System.Int16", StringComparison.OrdinalIgnoreCase)
|| String.Equals(property.BaseSystemType, "System.Int32", StringComparison.OrdinalIgnoreCase)
|| String.Equals(property.BaseSystemType, "System.Int64", StringComparison.OrdinalIgnoreCase)
|| String.Equals(property.BaseSystemType, "System.Byte", StringComparison.OrdinalIgnoreCase)
|| String.Equals(property.BaseSystemType, "System.Decimal", StringComparison.OrdinalIgnoreCase)
|| String.Equals(property.BaseSystemType, "System.Double", StringComparison.OrdinalIgnoreCase)
|| String.Equals(property.BaseSystemType, "System.String", StringComparison.OrdinalIgnoreCase))
entityProperty.DefaultValue = property.DefaultValue;
else
entityProperty.DefaultValue = null;
} else {
entityProperty.DefaultValue = null;
}
entityProperty.MaxLength = !String.IsNullOrEmpty(GetMaxLength(property)) && !GetMaxLength(property).Equals("Max", StringComparison.OrdinalIgnoreCase) && !GetNativeType(property).Equals("timestamp", StringComparison.OrdinalIgnoreCase) ? GetMaxLength(property) : null;
entityProperty.StoreGeneratedPattern = property.IsIdentity ? EdmxConstants.StoreGeneratedPatternIdentity : property.IsComputed ? EdmxConstants.StoreGeneratedPatternComputed : null;
}
}
private static void RemoveDuplicateStorageEntityTypeKeysAndProperties(EntityTypeStore entity)
{
var processed = new List<string>();
var propertiesToRemove = new List<EntityProperty>();
foreach (var property in entity.Properties) {
if (processed.Contains(property.Name))
propertiesToRemove.Add(property);
else
processed.Add(property.Name);
}
foreach (var e in propertiesToRemove) {
entity.Properties.Remove(e);
}
entity.Properties = (from p in entity.Properties select p).ToList();
if (entity.Key != null) {
var keysProcessed = new List<string>();
var keysToRemove = new List<PropertyRef>();
foreach (var property in entity.Key.PropertyRefs) {
if (!processed.Contains(property.Name) || keysProcessed.Contains(property.Name))
keysToRemove.Add(property);
else
keysProcessed.Add(property.Name);
}
foreach (var e in keysToRemove) {
entity.Key.PropertyRefs.Remove(e);
}
}
}
private EntityTypeStore CreateStorageEntityType(ISchemaEntity entity, string name, ref bool isNewView)
{
EntityTypeStore entityType = StorageSchema.EntityTypeStores.Where(e => ResolveStorageEntityName(entity.EntityKeyName).Equals(e.Name, StringComparison.OrdinalIgnoreCase) || name.Equals(e.Name, StringComparison.OrdinalIgnoreCase)).FirstOrDefault();
if (entityType == null) {
entityType = new EntityTypeStore() {
Name = name,
Key = new EntityKeyElement()
};
StorageSchema.EntityTypeStores.Add(entityType);
isNewView = entity is ViewEntity;
}
// Sync the name.
entityType.Name = name;
return entityType;
}
private static void CreateStorageEntityTypeKeys(ISchemaEntity entity, bool isNewView, EntityTypeStore entityType)
{
//<Key>
// <PropertyRef Name="CategoryId" />
//</Key>
if (entity.HasKey || isNewView) {
#region Remove extra key values.
var items = from property in entityType.Key.PropertyRefs
where !(from prop in entity.Key.Properties select prop.KeyName).Contains(property.Name)
select property;
// Remove all of the key properties that don't exist in the table entity.
foreach (var property in items) {
entityType.Key.PropertyRefs.Remove(property);
}
#endregion
foreach (var property in entity.Key.Properties.Where(p => entityType.Key.PropertyRefs.Count(pr => pr.Name == p.Name) == 0)) {
entityType.Key.PropertyRefs.Add(new PropertyRef() {
Name = property.KeyName
});
}
} else if (entity is TableEntity) {
entityType.Key.PropertyRefs.Clear();
}
}
