private string BuildFkName(IExprTableFullName tableIn, IExprTableFullName foreignTableIn) { StringBuilder nameBuilder = new StringBuilder(); ExprTableFullName table = tableIn.AsExprTableFullName(); ExprTableFullName foreignTable = foreignTableIn.AsExprTableFullName(); var schemaName = table.DbSchema != null?this.Options.MapSchema(table.DbSchema.Schema.Name) + "_" : null; nameBuilder.Append("FK_"); if (schemaName != null) { nameBuilder.Append(schemaName); nameBuilder.Append('_'); } nameBuilder.Append(table.TableName.Name); nameBuilder.Append("_to_"); if (schemaName != null) { nameBuilder.Append(schemaName); nameBuilder.Append('_'); } nameBuilder.Append(foreignTable.TableName.Name); return(nameBuilder.ToString()); }
private string BuildPkName(IExprTableFullName tableIn) { var table = tableIn.AsExprTableFullName(); var schemaName = table.DbSchema != null?this.Options.MapSchema(table.DbSchema.Schema.Name) + "_" : null; return($"PK_{schemaName}{table.TableName.Name}"); }
protected string BuildIndexName(IExprTableFullName tableIn, IndexMeta index) { if (index.Name != null && !string.IsNullOrEmpty(index.Name)) { return(index.Name); } var table = tableIn.AsExprTableFullName(); var schemaName = table.DbSchema != null?this.Options.MapSchema(table.DbSchema.Schema.Name) + "_" : null; var columns = string.Join("_", index.Columns.Select(c => c.Column.ColumnName.Name + (c.Descending ? "_DESC" : null))); return($"IX_{schemaName}{table.TableName.Name}_{columns}"); }