Exemple #1
0
        void specify_rename_column()
        {
            seed.PurgeDb();

            seed.CreateSchema("Logging").ExecuteNonQuery();

            seed.CreateTable("Logging", "Table1", new dynamic[]
            {
                seed.Id(),
                new { Name = "nvarchar(255)" }
            }).ExecuteNonQuery();

            seed.AddColumns("Logging",
                            "Table1",
                            new { NickName = "nvarchar(255)" }).ExecuteNonQuery();

            new { NickName = "nick name" }.InsertInto("Logging.[Table1]");

            seed.RenameColumn("Logging", "Table1", "NickName", "NickName2").ExecuteNonQuery();

            var repo = new Table1();

            var firstRecord = repo.All().First();

            ((bool)firstRecord.RespondsTo("NickName")).should_be(false);

            ((bool)firstRecord.RespondsTo("NickName2")).should_be(true);
        }
Exemple #2
0
        void specify_add_column()
        {
            seed.PurgeDb();

            seed.CreateSchema("Logging").ExecuteNonQuery();

            seed.CreateTable("Logging", "Table1", new dynamic[]
            {
                seed.Id(),
                new { Name = "nvarchar(255)" }
            }).ExecuteNonQuery();

            seed.AddColumns("Logging",
                            "Table1",
                            new { NickName = "nvarchar(255)" }).ExecuteNonQuery();

            new { Name = "name 1", NickName = "nick name" }.InsertInto("Logging.[Table1]");

            var repo = new Table1();

            var firstRecord = repo.All().First();

            repo.All().Count().should_be(1);

            (firstRecord.Name as string).should_be("name 1");

            (firstRecord.NickName as string).should_be("nick name");
        }
Exemple #3
0
        void specify_drop_column()
        {
            seed.PurgeDb();

            seed.CreateSchema("Logging").ExecuteNonQuery();

            seed.CreateTable("Logging", "Table1", new dynamic[] 
            { 
                seed.Id(),
                new { Name = "nvarchar(255)" }
            }).ExecuteNonQuery();

            seed.AddColumns("Logging",
                "Table1",
                new { NickName = "nvarchar(255)" }).ExecuteNonQuery();

            seed.DropColumn("Logging", "Table1", "Name").ExecuteNonQuery();

            new { NickName = "nick name" }.InsertInto("Logging.[Table1]");

            var repo = new Table1();

            var firstRecord = repo.All().First();

            ((bool)firstRecord.RespondsTo("Name")).should_be(false);
        }
Exemple #4
0
        void specify_add_column()
        {
            seed.PurgeDb();

            seed.CreateSchema("Logging").ExecuteNonQuery();

            seed.CreateTable("Logging", "Table1", new dynamic[] 
            { 
                seed.Id(),
                new { Name = "nvarchar(255)" }
            }).ExecuteNonQuery();

            seed.AddColumns("Logging", 
                "Table1", 
                new { NickName = "nvarchar(255)" }).ExecuteNonQuery();

            new { Name = "name 1", NickName = "nick name" }.InsertInto("Logging.[Table1]");

            var repo = new Table1();

            var firstRecord = repo.All().First();

            repo.All().Count().should_be(1);

            (firstRecord.Name as string).should_be("name 1");

            (firstRecord.NickName as string).should_be("nick name");
        }
Exemple #5
0
        void specify_create_table()
        {
            seed.PurgeDb();

            seed.CreateSchema("Logging").ExecuteNonQuery();

            seed.CreateTable("Logging", "Table1", new dynamic[]
            {
                seed.Id(),
                new { Name = "nvarchar(255)" }
            }).ExecuteNonQuery();

            new { Name = "name 1" }.InsertInto("Logging.[Table1]");

            var repo = new Table1();

            repo.All().Count().should_be(1);
        }
Exemple #6
0
        void specify_create_table()
        {
            seed.PurgeDb();

            seed.CreateSchema("Logging").ExecuteNonQuery();

            seed.CreateTable("Logging", "Table1", new dynamic[] 
            { 
                seed.Id(),
                new { Name = "nvarchar(255)" }
            }).ExecuteNonQuery();

            new { Name = "name 1" }.InsertInto("Logging.[Table1]");

            var repo = new Table1();

            repo.All().Count().should_be(1);
        }