Example #1
0
        public void TestInsertUserClassMuti()
        {
            var db = new NLORMMSSQLDb(ConnectionString);

            db.CreateTable <TestClassUser>();

            var insertList = new List <TestClassUser>();

            for (int i = 0; i < 30; i++)
            {
                var testObj = new TestClassUser {
                    ID         = i, Name = "Name " + i,
                    CreateTime = DateTime.Now.AddDays(i)
                };
                insertList.Add(testObj);
            }
            foreach (TestClassUser user in insertList)
            {
                db.Insert <TestClassUser>(user);
            }

            var selLis = db.Query <TestClassUser>();

            Assert.AreEqual(selLis.Count(), 30);
        }
Example #2
0
        public void TestCreatDecimalType()
        {
            INLORMDb db = new NLORMMSSQLDb( constr);
            db.CreateTable<TestClassDecimal>();

            db.DropTable<TestClassDecimal>();
        }
Example #3
0
        public void TestCreateTableWithoutDef()
        {
            INLORMDb mssqlDb = null;

            mssqlDb = new NLORMMSSQLDb(ConnectionString);
            mssqlDb.CreateTable <TestClass2>();
        }
Example #4
0
        public void TestCreatbitType()
        {
            INLORMDb db = new NLORMMSSQLDb( constr);
            db.CreateTable<TestClassbit>();

            db.DropTable<TestClassbit>();
        }
Example #5
0
 public void TestDeleteTwoRecord()
 {
     var db = new NLORMMSSQLDb(connectionString);
     db.FilterBy(FilterType.EQUAL_AND, new { income = 901234 }).Delete<TestClassOne>();
     var items = db.Query<TestClassOne>();
     Assert.AreEqual(3, items.Count());
 }
Example #6
0
 public void TestDropTable()
 {
     INLORMDb db = null;
     db = new NLORMMSSQLDb( constr);
     db.CreateTable<TestClass01>();
     db.DropTable<TestClass01>();
 }
Example #7
0
        public void TestCreatbitType()
        {
            INLORMDb db = new NLORMMSSQLDb(ConnectionString);

            db.CreateTable <TestClassbit>();

            db.DropTable <TestClassbit>();
        }
Example #8
0
        public void TestDropTable()
        {
            INLORMDb db = null;

            db = new NLORMMSSQLDb(ConnectionString);
            db.CreateTable <TestClass01>();
            db.DropTable <TestClass01>();
        }
Example #9
0
 public void TestUpdateOneRow()
 {
     var db = new NLORMMSSQLDb(connectionString);
     var newobj = new TestClassOne { Id = "sssss", income = 100 };
     int i = db.FilterBy(FilterType.EQUAL_AND, new { Id = "sssss" }).Update<TestClassOne>(newobj);
     var items = db.FilterBy(FilterType.EQUAL_AND, new { Id = "sssss" }).Query<TestClassOne>().First();
     Assert.AreEqual(100, items.income);
 }
Example #10
0
        public void TestDeleteOneRecord()
        {
            var db = new NLORMMSSQLDb(connectionString);

            insertdata(db);
            int deletedcount = db.FilterBy(FilterType.EQUAL_AND, new { Id = "sssss" }).Delete <TestClassOne>();

            Assert.AreEqual(deletedcount, 1);
        }
Example #11
0
        public void TestDeleteAllRecords()
        {
            var db = new NLORMMSSQLDb(connectionString);
            int totalcount = db.Query<TestClassOne>().Count();
            int dc = db.Delete<TestClassOne>();

            var items = db.Query<TestClassOne>();
            Assert.AreEqual(dc, totalcount);
        }
Example #12
0
        public void TestDeleteTwoRecord()
        {
            var db = new NLORMMSSQLDb(connectionString);

            insertdata(db);
            db.FilterBy(FilterType.EQUAL_AND, new { income = 901234 }).Delete <TestClassOne>();
            var items = db.Query <TestClassOne>();

            Assert.AreEqual(3, items.Count());
        }
Example #13
0
 public void TestCleanup()
 {
     try
     {
         var db = new NLORMMSSQLDb(connectionString);
         db.DropTable<TestClassOne>();
     }
     finally
     {
     }
 }
Example #14
0
        public void TestDeleteAllRecords()
        {
            var db = new NLORMMSSQLDb(connectionString);

            insertdata(db);
            int totalcount = db.Query <TestClassOne>().Count();
            int dc         = db.Delete <TestClassOne>();

            var items = db.Query <TestClassOne>();

            Assert.AreEqual(dc, totalcount);
        }
Example #15
0
        public void TestQueryMethod1()
        {
            INLORMDb db = null;

            db = new NLORMMSSQLDb(ConnectionString);
            this.TestInsertAlotItems();
            var result = db.Query <TestClass01>(@"SELECT * FROM TestClass01 where ID = @ID", new TestClass01()
            {
                ID = @"01"
            });

            Assert.AreEqual(1, result.Count());
        }
Example #16
0
 public void TestCleanup()
 {
     INLORMDb mssqlDb = null;
     try
     {
         mssqlDb = new NLORMMSSQLDb( constr);
         mssqlDb.DropTable<TestClass01>();
         mssqlDb.DropTable<TestClass2>();
         mssqlDb.DropTable<TestClassDecimal>();
     }
     catch ( Exception)
     {
     }
 }
Example #17
0
        public void TestInitialize()
        {
            try
            {
                var db = new NLORMMSSQLDb(connectionString);
                new NLORMMSSQLDb(connectionString);
                this.createtable( db);
                this.insertdata( db);
            }
            finally
            {

            }
        }
Example #18
0
        public void TestInitialize()
        {
            var        db  = new NLORMMSSQLDb(NLORMSSQLDbTest.masterdb);
            IDbCommand cmd = db.GetDbConnection().CreateCommand();

            cmd.CommandText = @"CREATE DATABASE TestORM";
            try
            {
                db.Open();
                cmd.ExecuteNonQuery();
                db.Close();
            }
            finally
            {
            }
        }
Example #19
0
        public void TestInsertAlotItems()
        {
            INLORMDb db = new NLORMMSSQLDb(ConnectionString);

            db.CreateTable <TestClass01>();
            for (int i = 0; i < 1000; i++)
            {
                db.Insert <TestClass01>(new TestClass01()
                {
                    ID = @"0" + i.ToString(), name = @"00" + i.ToString()
                });
            }

            var result = db.Query <TestClass01>(@"SELECT * FROM TestClass01");

            Assert.AreEqual(result.Count(), 1000);
        }
Example #20
0
        public void TestQueryMethod2()
        {
            INLORMDb db = new NLORMMSSQLDb(ConnectionString);

            db.CreateTable <TestClass01>();
            db.Insert <TestClass01>(new TestClass01()
            {
                ID = @"11", name = @"albert"
            });
            db.Insert <TestClass01>(new TestClass01()
            {
                ID = @"22", name = @"star"
            });
            var result = db.FilterBy(FilterType.EQUAL_AND, new { name = "albert" }).Query <TestClass01>();

            Assert.AreEqual(1, result.Count());
        }
Example #21
0
        public void TestUpdateOneRow()
        {
            var db     = new NLORMMSSQLDb(connectionString);
            var oldobj = new TestClassOne()
            {
                Id = "sssss", income = 20
            };
            var newobj = new TestClassOne {
                Id = "sssss", income = 100
            };

            db.CreateTable <TestClassOne>();
            db.Insert <TestClassOne>(oldobj);
            int i     = db.FilterBy(FilterType.EQUAL_AND, new { Id = "sssss" }).Update <TestClassOne>(newobj);
            var items = db.FilterBy(FilterType.EQUAL_AND, new { Id = "sssss" }).Query <TestClassOne>().First();

            Assert.AreEqual(100, items.income);
        }
Example #22
0
        public void TestTransactionCommit()
        {
            var db = new NLORMMSSQLDb(ConnectionString);

            db.CreateTable <TestClassUser>();
            var trans   = db.BeginTransaction();
            var testObj = new TestClassUser();

            testObj.ID         = 1;
            testObj.Name       = "Name " + 1;
            testObj.CreateTime = DateTime.Now;
            db.Insert <TestClassUser>(testObj);
            trans.Commit();
            db.Close();
            db = new NLORMMSSQLDb(ConnectionString);
            var selLis = db.Query <TestClassUser>();

            Assert.AreEqual(selLis.Count(), 1);
        }
Example #23
0
        public void TestCleanup()
        {
            var db = new NLORMMSSQLDb(NLORMSSQLDbTest.masterdb);

            System.Data.IDbCommand cmd = db.GetDbConnection().CreateCommand();
            cmd.CommandText = @"DROP DATABASE TestORM";
            System.Data.IDbCommand closecmd = db.GetDbConnection().CreateCommand();
            closecmd.CommandText = @"alter database TestORM set single_user with rollback immediate";

            try
            {
                db.Open();
                closecmd.ExecuteNonQuery();
                cmd.ExecuteNonQuery();
                db.Close();
            }
            finally
            {
            }
        }
Example #24
0
        public void TestInsertUserClass()
        {
            var db = new NLORMMSSQLDb(ConnectionString);

            db.CreateTable <TestClassUser>();

            var testObj = new TestClassUser();

            testObj.ID         = 1;
            testObj.Name       = "Name " + 1;
            testObj.CreateTime = DateTime.Now;

            db.Insert <TestClassUser>(testObj);
            var selLis = db.Query <TestClassUser>();

            Assert.AreEqual(selLis.Count(), 1);
            var selUser = selLis.ToArray()[0];

            Assert.AreEqual(testObj.ID, selUser.ID);
            Assert.AreEqual(testObj.Name, selUser.Name);
            //Assert.AreEqual(testObj.CreateTime,selUser.CreateTime);
        }
Example #25
0
 public void TestInitialize()
 {
     INLORMDb msdb = null;
     try
     {
         msdb = new NLORMMSSQLDb( constr);
         msdb.DropTable<TestClass01>();
         msdb.DropTable<TestClass2>();
         msdb.DropTable<TestClassDecimal>();
     }
     catch ( Exception)
     {
     }
 }
Example #26
0
 public void TestDeleteOneRecord()
 {
     var db = new NLORMMSSQLDb(connectionString);
     int deletedcount = db.FilterBy(FilterType.EQUAL_AND, new { Id = "sssss" }).Delete<TestClassOne>();
     Assert.AreEqual(deletedcount, 1);
 }
Example #27
0
 public void TestCreateTableWithoutDef()
 {
     INLORMDb mssqlDb = null;
     mssqlDb = new NLORMMSSQLDb( constr);
     mssqlDb.CreateTable<TestClass2>();
 }
Example #28
0
 private INLORMDb createtable()
 {
     var db = new NLORMMSSQLDb(connectionString);
     db.CreateTable<TestClassOne>();
     return db;
 }
Example #29
0
        public void TestCreateTableOnlyStringWithCfd()
        {
            var db = new NLORMMSSQLDb(ConnectionString);

            db.CreateTable <TestClassOnlyStringWCfd>();
        }
Example #30
0
        public void TestCreateTableOnlyInt()
        {
            var db = new NLORMMSSQLDb(ConnectionString);

            db.CreateTable <TestClassOnlyInt>();
        }
Example #31
0
        public void TestQueryMethod2()
        {
            INLORMDb db = new NLORMMSSQLDb( constr);
            db.CreateTable<TestClass01>();
            db.Insert<TestClass01>( new TestClass01(){ ID = @"11", name = @"albert"});
            db.Insert<TestClass01>( new TestClass01(){ ID = @"22", name = @"star"});
            var result = db.FilterBy( FilterType.EQUAL_AND, new { name = "albert"} ).Query<TestClass01>();

            Assert.AreEqual( 1, result.Count() );
        }
Example #32
0
 public void TestQueryMethod1()
 {
     INLORMDb db = null;
     db = new NLORMMSSQLDb( constr);
     this.TestInsertAlotItems();
     var result = db.Query<TestClass01>( @"SELECT * FROM TestClass01 where ID = @ID", new TestClass01(){ ID = @"01"});
     Assert.AreEqual( 1, result.Count());
 }
Example #33
0
        public void TestInsertAlotItems()
        {
            INLORMDb db = new NLORMMSSQLDb( constr);
            db.CreateTable<TestClass01>();
            for ( int i = 0; i < 1000; i++)
            {
                db.Insert<TestClass01>( new TestClass01(){ ID = @"0" + i.ToString(), name = @"00" + i.ToString() });
            }

            var result = db.Query<TestClass01>(@"SELECT * FROM TestClass01");
            Assert.AreEqual( result.Count(), 1000);
        }