protected virtual List<string> GetSqlDbTypeParts(DiffColumn col, Type type) { List<string> parts = new List<string>(); var pair = CurrentSchema.Settings.GetSqlDbTypePair(type); if (pair.SqlDbType != col.SqlDbType) parts.Add("SqlDbType = SqlDbType." + col.SqlDbType); var defaultSize = CurrentSchema.Settings.GetSqlSize(null, pair.SqlDbType); if (defaultSize != null) { if (!(defaultSize == col.Precission || defaultSize == col.Length / DiffColumn.BytesPerChar(col.SqlDbType) || defaultSize == int.MaxValue && col.Length == -1)) parts.Add("Size = " + (col.Length == -1 ? "int.MaxValue" : col.Length != 0 ? (col.Length / DiffColumn.BytesPerChar(col.SqlDbType)).ToString() : col.Precission != 0 ? col.Precission.ToString() : "0")); } var defaultScale = CurrentSchema.Settings.GetSqlScale(null, col.SqlDbType); if (defaultScale != null) { if (!(col.Scale == defaultScale)) parts.Add("Scale = " + col.Scale); } if (col.Default != null) parts.Add("Default = \"" + CleanDefault(col.Default) + "\""); return parts; }
protected virtual string GetRelatedEntity(DiffTable table, DiffColumn col) { if (col.ForeignKey == null) return null; return GetEntityName(col.ForeignKey.TargetTable); }
protected virtual IEnumerable <string> GetFieldAttributes(DiffTable table, DiffColumn col, string relatedEntity, bool isMList) { List <string> attributes = new List <string>(); if (RequiresNotNullableAttribute(col, relatedEntity) && NotNullAttributeNecessary(table, col, isMList)) { attributes.Add("NotNullable"); } if (col.ForeignKey == null) { string sqlDbType = GetSqlTypeAttribute(table, col); if (sqlDbType != null) { attributes.Add(sqlDbType); } } if (RequiresColumnName(table, col)) { attributes.Add("ColumnName(\"" + col.Name + "\")"); } if (HasUniqueIndex(table, col)) { attributes.Add("UniqueIndex"); } return(attributes); }
protected virtual string GetBackColumnNameAttribute(DiffColumn backReference) { if (backReference.Name == "ParentID") return null; return "BackReferenceColumnName(\"{0}\")".FormatWith(backReference.Name); }
protected virtual string GetStringLengthValidator(DiffTable table, DiffColumn col, string relatedEntity) { if (GetValueType(col) != typeof(string)) { return(null); } var parts = new List <string>(); parts.Add("AllowNulls = " + col.Nullable.ToString().ToLower()); var min = GetMinStringLength(col); if (min != null) { parts.Add("Min = " + min); } if (col.Length != -1) { parts.Add("Max = " + col.Length / DiffColumn.BytesPerChar(col.SqlDbType)); } return("StringLengthValidator(" + parts.ToString(", ") + ")"); }
protected virtual string GetPrimaryKeyAttribute(DiffTable table) { DiffColumn primaryKey = GetPrimaryKeyColumn(table); if (primaryKey == null) return null; var def = CurrentSchema.Settings.DefaultPrimaryKeyAttribute; Type type = GetValueType(primaryKey); List<string> parts = new List<string>(); if (primaryKey.Name != def.Name) parts.Add("Name = \"" + primaryKey.Name + "\""); if (primaryKey.Identity != def.Identity) { parts.Add("Identity = " + primaryKey.Identity.ToString().ToLower()); parts.Add("IdentityBehaviour = " + primaryKey.Identity.ToString().ToLower()); } parts.AddRange(GetSqlDbTypeParts(primaryKey, type)); if (type != def.Type || parts.Any()) parts.Insert(0, "typeof(" + type.TypeName() + ")"); if(parts.Any()) return "PrimaryKey(" + parts.ToString(", ") + ")"; return null; }
protected virtual bool HasUniqueIndex(DiffTable table, DiffColumn col) { return(table.Indices.Values.Any(ix => ix.FilterDefinition == null && ix.Columns.Only()?.Let(ic => ic.ColumnName == col.Name && ic.IsIncluded == false) == true && ix.IsUnique && ix.Type == DiffIndexType.NonClustered)); }
protected virtual string DefaultColumnName(DiffTable table, DiffColumn col) { string fieldName = GetFieldName(table, col).FirstUpper(); if (col.ForeignKey == null) return fieldName; return fieldName + "ID"; }
protected virtual string GetRelatedEntity(DiffTable table, DiffColumn col) { if (col.ForeignKey == null) { return(null); } return(GetEntityName(Tables.GetOrThrow(col.ForeignKey.TargetTable))); }
protected virtual string GetSqlTypeAttribute(DiffTable table, DiffColumn col) { Type type = GetValueType(col); List<string> parts = GetSqlDbTypeParts(col, type); if (parts.Any()) return "SqlDbType(" + parts.ToString(", ") + ")"; return null; }
protected virtual string GetSqlTypeAttribute(DiffTable table, DiffColumn col) { Type type = GetValueType(col); List <string> parts = GetSqlDbTypeParts(col, type); if (parts.Any() && SqlTypeAttributeNecessary(parts, table, col)) { return("SqlDbType(" + parts.ToString(", ") + ")"); } return(null); }
protected virtual IEnumerable<string> GetPropertyAttributes(DiffTable table, DiffColumn col, string relatedEntity) { List<string> attributes = new List<string>(); if (HasNotNullableAttribute(col, relatedEntity) && GetValueType(col) != typeof(string)) attributes.Add("NotNullValidator"); string stringLengthValidator = GetStringLengthValidator(table, col, relatedEntity); if(stringLengthValidator != null) attributes.Add(stringLengthValidator); return attributes; }
protected virtual IEnumerable <string> GetPropertyAttributes(DiffTable table, DiffColumn col, string?relatedEntity) { List <string> attributes = new List <string>(); string?stringLengthValidator = GetStringLengthValidator(table, col, relatedEntity); if (stringLengthValidator != null) { attributes.Add(stringLengthValidator); } return(attributes); }
protected virtual List <string> GetSqlDbTypeParts(DiffColumn col, Type type) { List <string> parts = new List <string>(); var pair = CurrentSchema.Settings.GetSqlDbTypePair(type); if (pair.DbType.SqlServer != col.DbType.SqlServer) { parts.Add("SqlDbType = SqlDbType." + col.DbType.SqlServer); } var defaultSize = CurrentSchema.Settings.GetSqlSize(null, null, pair.DbType); if (defaultSize != null) { if (!(defaultSize == col.Length || defaultSize == int.MaxValue && col.Length == -1)) { parts.Add("Size = " + (col.Length == -1 ? "int.MaxValue" : col.Length != 0 ? col.Length.ToString() : col.Precision != 0 ? col.Precision.ToString() : "0")); } } var defaultPrecision = CurrentSchema.Settings.GetSqlPrecision(null, null, pair.DbType); if (defaultPrecision != null) { if (defaultPrecision != col.Precision) { parts.Add("Precision = " + (col.Precision != 0 ? col.Precision.ToString() : "0")); } } var defaultScale = CurrentSchema.Settings.GetSqlScale(null, null, col.DbType); if (defaultScale != null) { if (!(col.Scale == defaultScale)) { parts.Add("Scale = " + col.Scale); } } if (col.DefaultConstraint != null) { parts.Add("Default = \"" + CleanDefault(col.DefaultConstraint.Definition) + "\""); } return(parts); }
protected virtual string GetFieldName(DiffTable table, DiffColumn col) { string name = col.Name.Contains(' ') ? col.Name.ToPascal(false) : col.Name; if (this.GetRelatedEntity(table, col) != null) { if (name.Length > 2 && name.EndsWith("Id", StringComparison.InvariantCultureIgnoreCase)) name = name.RemoveEnd("Id".Length); if (name.Length > 2 && name.StartsWith("Id", StringComparison.InvariantCultureIgnoreCase)) name = name.RemoveStart("Id".Length); } return name.FirstLower(); }
protected virtual string GetFieldType(DiffTable table, DiffColumn col, string?relatedEntity) { var nullable = (col.Nullable ? "?" : ""); if (relatedEntity != null) { if (IsEnum(Tables.GetOrThrow(col.ForeignKey !.TargetTable))) { return(relatedEntity + nullable); } return((IsLite(table, col) ? "Lite<" + relatedEntity + ">" : relatedEntity) + nullable); } return(GetValueType(col).TypeName() + nullable); }
protected virtual string WriteField(string fileName, DiffTable table, DiffColumn col) { string relatedEntity = GetRelatedEntity(table, col); string type = GetFieldType(table, col, relatedEntity); string fieldName = GetFieldName(table, col); StringBuilder sb = new StringBuilder(); WriteAttributeTag(sb, GetFieldAttributes(table, col, relatedEntity, false)); WriteAttributeTag(sb, GetPropertyAttributes(table, col, relatedEntity)); sb.AppendLine("public {0} {1} {{ get; {2}set; }}".FormatWith(type, fieldName.FirstUpper(), IsReadonly(table, col) ? "private" : null)); return(sb.ToString()); }
protected virtual string GetFieldType(DiffTable table, DiffColumn col, string relatedEntity) { if (relatedEntity != null) { if (IsEnum(col.ForeignKey.TargetTable)) return col.Nullable ? relatedEntity + "?" : relatedEntity; return IsLite(table, col) ? "Lite<" + relatedEntity + ">" : relatedEntity; } var valueType = GetValueType(col); if (col.Nullable) return valueType.Nullify().TypeName(); return valueType.TypeName(); }
protected virtual string GetFieldName(DiffTable table, DiffColumn col) { string name = !IdentifierValidatorAttribute.PascalAscii.IsMatch(col.Name) || col.Name.Contains("_") ? col.Name.ToPascal(false, false) : col.Name; if (this.GetRelatedEntity(table, col) != null) { if (name.Length > 2 && name.EndsWith("Id", StringComparison.InvariantCultureIgnoreCase)) { name = name.RemoveEnd("Id".Length); } if (name.Length > 2 && name.StartsWith("Id", StringComparison.InvariantCultureIgnoreCase)) { name = name.RemoveStart("Id".Length); } } return(name.FirstLower()); }
protected virtual string GetFieldType(DiffTable table, DiffColumn col, string?relatedEntity) { if (relatedEntity != null) { if (IsEnum(Tables.GetOrThrow(col.ForeignKey !.TargetTable))) { return(col.Nullable ? relatedEntity + "?" : relatedEntity); } return(IsLite(table, col) ? "Lite<" + relatedEntity + ">" : relatedEntity); } var valueType = GetValueType(col); if (col.Nullable) { return(valueType.Nullify().TypeName()); } return(valueType.TypeName()); }
protected virtual Type GetValueType(DiffColumn col) { switch (col.SqlDbType) { case SqlDbType.BigInt: return typeof(long); case SqlDbType.Binary: return typeof(byte[]); case SqlDbType.Bit: return typeof(bool); case SqlDbType.Char: return typeof(char); case SqlDbType.Date: return typeof(DateTime); case SqlDbType.DateTime: return typeof(DateTime); case SqlDbType.DateTime2: return typeof(DateTime); case SqlDbType.DateTimeOffset: return typeof(DateTimeOffset); case SqlDbType.Decimal: return typeof(Decimal); case SqlDbType.Float: return typeof(double); case SqlDbType.Image: return typeof(byte[]); case SqlDbType.Int: return typeof(int); case SqlDbType.Money: return typeof(decimal); case SqlDbType.NChar: return typeof(string); case SqlDbType.NText: return typeof(string); case SqlDbType.NVarChar: return typeof(string); case SqlDbType.Real: return typeof(float); case SqlDbType.SmallDateTime: return typeof(DateTime); case SqlDbType.SmallInt: return typeof(short); case SqlDbType.SmallMoney: return typeof(decimal); case SqlDbType.Text: return typeof(string); case SqlDbType.Time: return typeof(TimeSpan); case SqlDbType.Timestamp: return typeof(TimeSpan); case SqlDbType.TinyInt: return typeof(byte); case SqlDbType.UniqueIdentifier: return typeof(Guid); case SqlDbType.VarBinary: return typeof(byte[]); case SqlDbType.VarChar: return typeof(string); case SqlDbType.Xml: return typeof(string); case SqlDbType.Udt: return Schema.Current.Settings.UdtSqlName .SingleOrDefaultEx(kvp => StringComparer.InvariantCultureIgnoreCase.Equals(kvp.Value, col.UserTypeName)) .Key; default: throw new NotImplementedException("Unknown translation for " + col.SqlDbType); } }
protected virtual IEnumerable<string> GetFieldAttributes(DiffTable table, DiffColumn col, string relatedEntity) { List<string> attributes = new List<string>(); if (HasNotNullableAttribute(col, relatedEntity)) attributes.Add("NotNullable"); if (col.ForeignKey == null) { string sqlDbType = GetSqlTypeAttribute(table, col); if (sqlDbType != null) attributes.Add(sqlDbType); } if (GetEmbeddedField(table, col) != null || col.Name != DefaultColumnName(table, col)) attributes.Add("ColumnName(\"" + col.Name + "\")"); if (HasUniqueIndex(table, col)) attributes.Add("UniqueIndex"); return attributes; }
protected virtual string?GetStringLengthValidator(DiffTable table, DiffColumn col, string?relatedEntity) { if (GetValueType(col) != typeof(string)) { return(null); } var parts = new List <string>(); var min = GetMinStringLength(col); if (min != null) { parts.Add("Min = " + min); } if (col.Length != -1) { parts.Add("Max = " + col.Length); } return("StringLengthValidator(" + parts.ToString(", ") + ")"); }
protected virtual string GetRelatedEntity(DiffTable table, DiffColumn col) { if (col.ForeignKey == null) return null; return GetEntityName(col.ForeignKey.TargetTable); }
protected virtual bool IsReadonly(DiffTable table, DiffColumn col) { return false; }
protected virtual string GetFieldType(DiffTable table, DiffColumn col, string relatedEntity) { if (relatedEntity != null) { if (IsEnum(col.ForeignKey.TargetTable)) return col.Nullable ? relatedEntity + "?" : relatedEntity; return IsLite(table, col) ? "Lite<" + relatedEntity + ">" : relatedEntity; } var valueType = GetValueType(col); if (col.Nullable) return valueType.Nullify().TypeName(); return valueType.TypeName(); }
protected virtual bool SqlTypeAttributeNecessary(List <string> parts, DiffTable table, DiffColumn col) { var part = parts.Only(); if (part != null && part.StartsWith("Size = ") && GetValueType(col) == typeof(string)) { return(false); } return(true); }
protected virtual bool IsLite(DiffTable table, DiffColumn col) { return true; }
protected virtual int?GetMinStringLength(DiffColumn col) { return(1); }
protected virtual List<string> GetSqlDbTypeParts(DiffColumn col, Type type) { List<string> parts = new List<string>(); var pair = CurrentSchema.Settings.GetSqlDbTypePair(type); if (pair.SqlDbType != col.SqlDbType) parts.Add("SqlDbType = SqlDbType." + col.SqlDbType); var defaultSize = CurrentSchema.Settings.GetSqlSize(null, pair.SqlDbType); if (defaultSize != null) { if (!(defaultSize == col.Precission || defaultSize == col.Length / DiffColumn.BytesPerChar(col.SqlDbType) || defaultSize == int.MaxValue && col.Length == -1)) parts.Add("Size = " + (col.Length == -1 ? "int.MaxValue" : col.Length != 0 ? (col.Length / DiffColumn.BytesPerChar(col.SqlDbType)).ToString() : col.Precission != 0 ? col.Precission.ToString() : "0")); } var defaultScale = CurrentSchema.Settings.GetSqlScale(null, col.SqlDbType); if (defaultScale != null) { if (!(col.Scale == defaultScale)) parts.Add("Scale = " + col.Scale); } if (col.Default != null) parts.Add("Default = \"" + CleanDefault(col.Default) + "\""); return parts; }
protected virtual bool NotNullAttributeNecessary(DiffTable table, DiffColumn col, bool isMList) { return(false); //NotNullValidator is enought }
protected virtual string GetBackColumnNameAttribute(DiffColumn backReference) { if (backReference.Name == "ParentID") return null; return "BackReferenceColumnName(\"{0}\")".FormatWith(backReference.Name); }
protected virtual string GetFieldName(DiffTable table, DiffColumn col) { string name = col.Name.Contains(' ') ? col.Name.ToPascal(false) : col.Name; if (this.GetRelatedEntity(table, col) != null) { if (name.Length > 2 && name.EndsWith("Id", StringComparison.InvariantCultureIgnoreCase)) name = name.RemoveEnd("Id".Length); if (name.Length > 2 && name.StartsWith("Id", StringComparison.InvariantCultureIgnoreCase)) name = name.RemoveStart("Id".Length); } return name.FirstLower(); }
protected virtual bool HasNotNullableAttribute(DiffColumn col, string relatedEntity) { return !col.Nullable && (relatedEntity != null || GetValueType(col).IsClass); }
protected virtual IEnumerable<string> GetFieldAttributes(DiffTable table, DiffColumn col, string relatedEntity) { List<string> attributes = new List<string>(); if (HasNotNullableAttribute(col, relatedEntity)) attributes.Add("NotNullable"); if (col.ForeignKey == null) { string sqlDbType = GetSqlTypeAttribute(table, col); if (sqlDbType != null) attributes.Add(sqlDbType); } if (GetEmbeddedField(table, col) != null || col.Name != DefaultColumnName(table, col)) attributes.Add("ColumnName(\"" + col.Name + "\")"); if (HasUniqueIndex(table, col)) attributes.Add("UniqueIndex"); return attributes; }
protected virtual bool HasUniqueIndex(DiffTable table, DiffColumn col) { return table.Indices.Values.Any(a => a.FilterDefinition == null && a.Columns.Only() == col.Name && a.IsUnique && a.Type == DiffIndexType.NonClustered); }
protected virtual bool RequiresColumnName(DiffTable table, DiffColumn col) { return GetEmbeddedField(table, col) != null || col.Name != DefaultColumnName(table, col); }
protected virtual bool IsReadonly(DiffTable table, DiffColumn col) { return(false); }
protected virtual string GetSqlTypeAttribute(DiffTable table, DiffColumn col) { Type type = GetValueType(col); List<string> parts = GetSqlDbTypeParts(col, type); if (parts.Any()) return "SqlDbType(" + parts.ToString(", ") + ")"; return null; }
protected virtual string WriteField(string fileName, DiffTable table, DiffColumn col) { string relatedEntity = GetRelatedEntity(table, col); string type = GetFieldType(table, col, relatedEntity); string fieldName = GetFieldName(table, col); StringBuilder sb = new StringBuilder(); WriteAttributeTag(sb, GetFieldAttributes(table, col, relatedEntity)); WriteAttributeTag(sb, GetPropertyAttributes(table, col, relatedEntity)); sb.AppendLine("public {0} {1} { get; {2}set; }".FormatWith(type, fieldName.FirstUpper(), IsReadonly(table, col) ? "private" : null)); return sb.ToString(); }
protected virtual IEnumerable<string> GetPropertyAttributes(DiffTable table, DiffColumn col, string relatedEntity) { List<string> attributes = new List<string>(); if (HasNotNullableAttribute(col, relatedEntity) && GetValueType(col) != typeof(string)) attributes.Add("NotNullValidator"); string stringLengthValidator = GetStringLengthValidator(table, col, relatedEntity); if(stringLengthValidator != null) attributes.Add(stringLengthValidator); return attributes; }
protected virtual bool RequiresNotNullableAttribute(DiffColumn col, string relatedEntity) { return(!col.Nullable && (relatedEntity != null || GetValueType(col).IsClass)); }
protected virtual Type GetValueType(DiffColumn col) { switch (col.SqlDbType) { case SqlDbType.BigInt: return typeof(long); case SqlDbType.Binary: return typeof(byte[]); case SqlDbType.Bit: return typeof(bool); case SqlDbType.Char: return typeof(char); case SqlDbType.Date: return typeof(DateTime); case SqlDbType.DateTime: return typeof(DateTime); case SqlDbType.DateTime2: return typeof(DateTime); case SqlDbType.DateTimeOffset: return typeof(DateTimeOffset); case SqlDbType.Decimal: return typeof(Decimal); case SqlDbType.Float: return typeof(double); case SqlDbType.Image: return typeof(byte[]); case SqlDbType.Int: return typeof(int); case SqlDbType.Money: return typeof(decimal); case SqlDbType.NChar: return typeof(string); case SqlDbType.NText: return typeof(string); case SqlDbType.NVarChar: return typeof(string); case SqlDbType.Real: return typeof(float); case SqlDbType.SmallDateTime: return typeof(DateTime); case SqlDbType.SmallInt: return typeof(short); case SqlDbType.SmallMoney: return typeof(decimal); case SqlDbType.Text: return typeof(string); case SqlDbType.Time: return typeof(TimeSpan); case SqlDbType.Timestamp: return typeof(TimeSpan); case SqlDbType.TinyInt: return typeof(byte); case SqlDbType.UniqueIdentifier: return typeof(Guid); case SqlDbType.VarBinary: return typeof(byte[]); case SqlDbType.VarChar: return typeof(string); case SqlDbType.Xml: return typeof(string); case SqlDbType.Udt: return Schema.Current.Settings.UdtSqlName .SingleOrDefaultEx(kvp => StringComparer.InvariantCultureIgnoreCase.Equals(kvp.Value, col.UserTypeName)) .Key; default: throw new NotImplementedException("Unknown translation for " + col.SqlDbType); } }
protected virtual string GetEmbeddedField(DiffTable table, DiffColumn col) { return null; }
public MListInfo(DiffColumn backReferenceColumn) { this.BackReferenceColumn = backReferenceColumn; }
protected virtual bool RequiresColumnName(DiffTable table, DiffColumn col) { return(GetEmbeddedField(table, col) != null || col.Name != DefaultColumnName(table, col)); }
protected virtual int? GetMinStringLength(DiffColumn col) { return 1; }
protected virtual string GetStringLengthValidator(DiffTable table, DiffColumn col, string relatedEntity) { if (GetValueType(col) != typeof(string)) return null; var parts = new List<string>(); parts.Add("AllowNulls = " + col.Nullable.ToString().ToLower()); var min = GetMinStringLength(col); if (min != null) parts.Add("Min = " + min); if (col.Length != -1) parts.Add("Max = " + col.Length / DiffColumn.BytesPerChar(col.SqlDbType)); return "StringLengthValidator(" + parts.ToString(", ") + ")"; }
protected virtual string DefaultColumnName(DiffTable table, DiffColumn col) { string fieldName = GetFieldName(table, col).FirstUpper(); if (col.ForeignKey == null) return fieldName; return fieldName + "ID"; }
protected virtual bool IsLite(DiffTable table, DiffColumn col) { return(true); }
protected virtual DiffColumn GetMListTrivialElementColumn(DiffTable table, DiffColumn parentColumn, DiffColumn orderColumn) { return table.Columns.Values.Where(c => c != parentColumn && c != orderColumn && !c.PrimaryKey).Only(); }