public void Create() { var Database = new Utilities.ORM.Manager.Schema.Default.Database.Database("TestDatabase"); Utilities.ORM.Manager.Schema.Interfaces.ITable View = Database.AddView("TestView"); Assert.Equal(View, Database.Views.First()); Assert.Equal("TestView", View.Name); }
public void AddColumn() { var Database = new Utilities.ORM.Manager.Schema.Default.Database.Database("TestDatabase"); Utilities.ORM.Manager.Schema.Interfaces.ITable View = Database.AddView("TestView"); View.AddColumn <int>("Column1", DbType.Int32, 0, true); Assert.Equal(1, View.Columns.Count); }
public void Create() { var Database = new Utilities.ORM.Manager.Schema.Default.Database.Database("TestDatabase"); Utilities.ORM.Manager.Schema.Interfaces.ITable Table = Database.AddTable("TestTable"); Assert.Equal(Table, Database.Tables.First()); Assert.Equal("TestTable", Table.Name); }
public void AddColumn() { var Database = new Utilities.ORM.Manager.Schema.Default.Database.Database("TestDatabase"); Utilities.ORM.Manager.Schema.Interfaces.ITable Function = Database.AddStoredProcedure("TestStoredProcedure", "Definition"); Function.AddColumn <int>("Column1", DbType.Int32, 0); Assert.Equal(1, Function.Columns.Count); }
public void Create() { var Database = new Utilities.ORM.Manager.Schema.Default.Database.Database("TestDatabase"); Utilities.ORM.Manager.Schema.Interfaces.ITable Function = Database.AddStoredProcedure("TestStoredProcedure", "Definition"); Assert.Equal(Function, Database.StoredProcedures.First()); Assert.Equal("TestStoredProcedure", Function.Name); Assert.Equal("Definition", ((Utilities.ORM.Manager.Schema.Interfaces.IFunction)Function).Definition); Assert.Equal(Database, Function.Source); }
public void AddColumns() { var Database = new Utilities.ORM.Manager.Schema.Default.Database.Database("TestDatabase"); Utilities.ORM.Manager.Schema.Interfaces.ITable Table = Database.AddTable("TestTable"); Utilities.ORM.Manager.Schema.Interfaces.IColumn Column = Table.AddColumn <int>("Column1", DbType.Int32); Assert.Equal(Column, Table.Columns.First()); Assert.Equal("Column1", Column.Name); Assert.Equal(DbType.Int32, Column.DataType); Assert.Equal("", Column.Default); }
public void Create() { var Database = new Utilities.ORM.Manager.Schema.Default.Database.Database("TestDatabase"); Utilities.ORM.Manager.Schema.Interfaces.ITable Table = Database.AddTable("TestTable"); Utilities.ORM.Manager.Schema.Interfaces.ITrigger TempTrigger = Table.AddTrigger("Trigger", "Definition", TriggerType.Insert); Assert.Equal(TempTrigger, Table.Triggers.First()); Assert.Equal("Trigger", TempTrigger.Name); Assert.Equal("Definition", TempTrigger.Definition); Assert.Equal(TriggerType.Insert, TempTrigger.Type); Assert.Equal(Table, TempTrigger.ParentTable); }