public TableSchema() { this.DatabaseOwner = string.Empty; this.Name = string.Empty; this.Columns = new ColumnList(); this.Indexes = new IndexList(); this.ForeignKeys = new ForeignKeyList(); }
public TableSchema(string databaseOwner, string schemaName, ColumnList columns) { this.DatabaseOwner = databaseOwner ?? @""; this.Name = schemaName ?? @""; this.Columns = new ColumnList(); if (columns != null) this.Columns.InsertRange(0, columns); this.Indexes = new IndexList(); this.ForeignKeys = new ForeignKeyList(); }
public TableSchema(string schemaName, ColumnList columns, IndexList indexes, ForeignKeyList foreignKeys) { this.DatabaseOwner = string.Empty; this.Name = schemaName ?? @""; this.Columns = new ColumnList(); if (columns != null) this.Columns.InsertRange(0, columns); this.Indexes = new IndexList(); if (indexes != null) this.Indexes.InsertRange(0, indexes); this.ForeignKeys = new ForeignKeyList(); this.ForeignKeys.InsertRange(0, foreignKeys); }
public ForeignKey AddForeignKey(string name, string referenceSchema = "", string referenceTable = "", string deleteAction = "", string updateAction = "") { var item = new ForeignKey(GenDataBase) { GenObject = ((GenObject)GenObject).CreateGenObject("ForeignKey"), Name = name, ReferenceSchema = referenceSchema, ReferenceTable = referenceTable, DeleteAction = deleteAction, UpdateAction = updateAction }; ForeignKeyList.Add(item); return(item); }
public void AddForeignKey(ForeignKey foreignKey) { if (ForeignKeys == null) ForeignKeys = new ForeignKeyList(); if (foreignKey.Name == null) { foreignKey.Name = @"FK_"; foreignKey.Name += Name + @"_"; foreignKey.Name += foreignKey.ForeignTable + @"_"; for (int idx = 0; idx < foreignKey.Columns.Length; idx++) { if (idx > 0) foreignKey.Name += @"_"; foreignKey.Name += foreignKey.Columns[idx]; } } ForeignKeys.Add(foreignKey); }