C# (CSharp) Utilities.ORM.Manager.Schema.Interfaces.ITable Examples

Example #1

        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);
        }

Example #2

        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);
        }

Example #3

File: Table.cs Project: terrydash/Craig-s-Utility-Library

        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);
        }

Example #4

File: StoredProcedure.cs Project: terrydash/Craig-s-Utility-Library

        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);
        }

Example #5

File: StoredProcedure.cs Project: terrydash/Craig-s-Utility-Library

        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);
        }

Example #6

File: Table.cs Project: terrydash/Craig-s-Utility-Library

        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);
        }

Example #7

        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);
        }