C# (CSharp) Utilities.SQL.DataClasses.Database.AddTable 예제들

예제 #1

파일: Table.cs 프로젝트: AngelMarquez/Craig-s-Utility-Library

 public void Create()
 {
     Utilities.SQL.DataClasses.Database Database = new Utilities.SQL.DataClasses.Database("TestDatabase");
     Utilities.SQL.DataClasses.Table Table = Database.AddTable("TestTable");
     Assert.Equal(Table, Database.Tables[0]);
     Assert.Equal("TestTable", Table.Name);
 }

예제 #2

파일: Table.cs 프로젝트: MarkWalls/Craig-s-Utility-Library

 public void Create()
 {
     Utilities.SQL.DataClasses.Database Database = new Utilities.SQL.DataClasses.Database("TestDatabase");
     Utilities.SQL.DataClasses.Table    Table    = Database.AddTable("TestTable");
     Assert.Equal(Table, Database.Tables[0]);
     Assert.Equal("TestTable", Table.Name);
 }

예제 #3

파일: Database.cs 프로젝트: yuanlianxi/Craig-s-Utility-Library

 public void AddTable()
 {
     Utilities.SQL.DataClasses.Database Database = new Utilities.SQL.DataClasses.Database("TestDatabase");
     Database.AddTable("TestTable");
     Assert.Equal(1, Database.Tables.Count);
     Assert.Equal("TestTable", Database.Tables.First().Name);
     Assert.Equal(Database, Database.Tables.First().ParentDatabase);
 }

예제 #4

파일: Database.cs 프로젝트: gwilkinson/Craig-s-Utility-Library

 public void AddTable()
 {
     Utilities.SQL.DataClasses.Database Database = new Utilities.SQL.DataClasses.Database("TestDatabase");
     Database.AddTable("TestTable");
     Assert.Equal(1, Database.Tables.Count);
     Assert.Equal("TestTable", Database.Tables[0].Name);
     Assert.Equal(Database, Database.Tables[0].ParentDatabase);
 }

예제 #5

파일: Table.cs 프로젝트: AngelMarquez/Craig-s-Utility-Library

 public void AddColumns()
 {
     Utilities.SQL.DataClasses.Database Database = new Utilities.SQL.DataClasses.Database("TestDatabase");
     Utilities.SQL.DataClasses.Table Table = Database.AddTable("TestTable");
     IColumn Column = Table.AddColumn<int>("Column1", DbType.Int32);
     Assert.Equal(Column, Table.Columns[0]);
     Assert.Equal("Column1", Column.Name);
     Assert.Equal(DbType.Int32, Column.DataType);
     Assert.Equal("", Column.Default);
 }

예제 #6

파일: Trigger.cs 프로젝트: AngelMarquez/Craig-s-Utility-Library

 public void Create()
 {
     Utilities.SQL.DataClasses.Database Database = new Utilities.SQL.DataClasses.Database("TestDatabase");
     Utilities.SQL.DataClasses.Table Table = Database.AddTable("TestTable");
     Utilities.SQL.DataClasses.Trigger TempTrigger = Table.AddTrigger("Trigger", "Definition", TriggerType.INSERT);
     Assert.Equal(TempTrigger, Table.Triggers[0]);
     Assert.Equal("Trigger", TempTrigger.Name);
     Assert.Equal("Definition", TempTrigger.Definition);
     Assert.Equal(TriggerType.INSERT, TempTrigger.Type);
     Assert.Equal(Table, TempTrigger.ParentTable);
 }

예제 #7

 public void Create()
 {
     Utilities.SQL.DataClasses.Database Database    = new Utilities.SQL.DataClasses.Database("TestDatabase");
     Utilities.SQL.DataClasses.Table    Table       = Database.AddTable("TestTable");
     Utilities.SQL.DataClasses.Trigger  TempTrigger = Table.AddTrigger("Trigger", "Definition", TriggerType.INSERT);
     Assert.Equal(TempTrigger, Table.Triggers[0]);
     Assert.Equal("Trigger", TempTrigger.Name);
     Assert.Equal("Definition", TempTrigger.Definition);
     Assert.Equal(TriggerType.INSERT, TempTrigger.Type);
     Assert.Equal(Table, TempTrigger.ParentTable);
 }

예제 #8

파일: Table.cs 프로젝트: MarkWalls/Craig-s-Utility-Library

        public void AddColumns()
        {
            Utilities.SQL.DataClasses.Database Database = new Utilities.SQL.DataClasses.Database("TestDatabase");
            Utilities.SQL.DataClasses.Table    Table    = Database.AddTable("TestTable");
            IColumn Column = Table.AddColumn <int>("Column1", DbType.Int32);

            Assert.Equal(Column, Table.Columns[0]);
            Assert.Equal("Column1", Column.Name);
            Assert.Equal(DbType.Int32, Column.DataType);
            Assert.Equal("", Column.Default);
        }