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); }
public void TestCreatDecimalType() { INLORMDb db = new NLORMMSSQLDb( constr); db.CreateTable<TestClassDecimal>(); db.DropTable<TestClassDecimal>(); }
public void TestCreateTableWithoutDef() { INLORMDb mssqlDb = null; mssqlDb = new NLORMMSSQLDb(ConnectionString); mssqlDb.CreateTable <TestClass2>(); }
public void TestCreatbitType() { INLORMDb db = new NLORMMSSQLDb( constr); db.CreateTable<TestClassbit>(); db.DropTable<TestClassbit>(); }
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()); }
public void TestDropTable() { INLORMDb db = null; db = new NLORMMSSQLDb( constr); db.CreateTable<TestClass01>(); db.DropTable<TestClass01>(); }
public void TestCreatbitType() { INLORMDb db = new NLORMMSSQLDb(ConnectionString); db.CreateTable <TestClassbit>(); db.DropTable <TestClassbit>(); }
public void TestDropTable() { INLORMDb db = null; db = new NLORMMSSQLDb(ConnectionString); db.CreateTable <TestClass01>(); db.DropTable <TestClass01>(); }
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); }
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); }
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); }
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()); }
public void TestCleanup() { try { var db = new NLORMMSSQLDb(connectionString); db.DropTable<TestClassOne>(); } finally { } }
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); }
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()); }
public void TestCleanup() { INLORMDb mssqlDb = null; try { mssqlDb = new NLORMMSSQLDb( constr); mssqlDb.DropTable<TestClass01>(); mssqlDb.DropTable<TestClass2>(); mssqlDb.DropTable<TestClassDecimal>(); } catch ( Exception) { } }
public void TestInitialize() { try { var db = new NLORMMSSQLDb(connectionString); new NLORMMSSQLDb(connectionString); this.createtable( db); this.insertdata( db); } finally { } }
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 { } }
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); }
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()); }
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); }
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); }
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 { } }
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); }
public void TestInitialize() { INLORMDb msdb = null; try { msdb = new NLORMMSSQLDb( constr); msdb.DropTable<TestClass01>(); msdb.DropTable<TestClass2>(); msdb.DropTable<TestClassDecimal>(); } catch ( Exception) { } }
public void TestDeleteOneRecord() { var db = new NLORMMSSQLDb(connectionString); int deletedcount = db.FilterBy(FilterType.EQUAL_AND, new { Id = "sssss" }).Delete<TestClassOne>(); Assert.AreEqual(deletedcount, 1); }
public void TestCreateTableWithoutDef() { INLORMDb mssqlDb = null; mssqlDb = new NLORMMSSQLDb( constr); mssqlDb.CreateTable<TestClass2>(); }
private INLORMDb createtable() { var db = new NLORMMSSQLDb(connectionString); db.CreateTable<TestClassOne>(); return db; }
public void TestCreateTableOnlyStringWithCfd() { var db = new NLORMMSSQLDb(ConnectionString); db.CreateTable <TestClassOnlyStringWCfd>(); }
public void TestCreateTableOnlyInt() { var db = new NLORMMSSQLDb(ConnectionString); db.CreateTable <TestClassOnlyInt>(); }
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() ); }
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()); }
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); }