/// <summary> /// Initializes a new instance of the <see cref="Table"/> class. /// </summary> /// <param name="owner">The owner.</param> /// <param name="name">The name.</param> public Table(string owner, string name) { Owner = owner; Name = name; Columns = new Columns(); Constraints = new List<Constraint>(); }
public void Remove_Column() { var test = new Columns(); var column = new Column("testing", ColumnTypes.Bigint, true, null); test.Add(column); test.Remove(column); Assert.False(test.Items.Any(item => item.Name == "testing")); }
/// <summary> /// Translates this constraint into a SQL script /// </summary> /// <returns></returns> public string Script() { return(Type != ConstraintType.Index ? $"CONSTRAINT [{Name}] {ConvertToString(Type)} {ClusteredText} ([{string.Join("], [", Columns.ToArray())}])" : $"CREATE {UniqueText} {ClusteredText} INDEX [{Name}] ON [{Table.Owner}].[{Table.Name}] ([{string.Join("], [", Columns.ToArray())}])"); }
public void Script() { var test = new Columns(); test.Add(new Column("testing", ColumnTypes.Bigint, true, null)); Assert.Contains("testing", test.Script()); }
public void Add_Column() { var test = new Columns(); test.Add(new Column("testing", ColumnTypes.Bigint, true, null)); Assert.True(test.Items.Any(item => item.Name == "testing")); }