public void TestDeleteOneRecord() { var db = new NLORMSQLiteDb( connectionString); int i = db.FilterBy(FilterType.EQUAL_AND, new { Id = "sssss"}).Delete<TestClassOne>(); var items = db.FilterBy( FilterType.EQUAL_AND, new { Id = "sssss"}).Query<TestClassOne>(); Assert.AreEqual( 0, items.Count() ); }
public void TestDeleteOneRecord() { var db = new NLORMSQLiteDb(connectionString); int i = db.FilterBy(FilterType.EQUAL_AND, new { Id = "sssss" }).Delete <TestClassOne>(); var items = db.FilterBy(FilterType.EQUAL_AND, new { Id = "sssss" }).Query <TestClassOne>(); Assert.AreEqual(0, items.Count()); }
public void TestUpdateOneRow() { var db = new NLORMSQLiteDb(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 TestUpdateOneRowUesExpando() { var db = new NLORMSQLiteDb(connectionString); var newobj = new TestClassOne { Id = "sssss", income = 100 }; dynamic filterObj = new ExpandoObject(); filterObj.Id = "sssss"; int i = db.FilterBy(FilterType.EQUAL_AND, filterObj).Update <TestClassOne>(newobj); var items = db.FilterBy(FilterType.EQUAL_AND, filterObj).Query <TestClassOne>()[0]; Assert.AreEqual(100, items.income); }
public void TestUpdateWithOrUseExpandoToUpdate() { var db = new NLORMSQLiteDb(connectionString); dynamic newobjc = new ExpandoObject(); newobjc.income = 100; int i = db.FilterBy(FilterType.EQUAL_AND, new { Id = "sssss" }) .Or().FilterBy(FilterType.EQUAL_AND, new { Id = "rrrrr" }) .Update <TestClassOne>(newobjc); var items = db.FilterBy(FilterType.EQUAL_AND, new { Id = "sssss" }).Query <TestClassOne>().First(); var itemsr = db.FilterBy(FilterType.EQUAL_AND, new { Id = "rrrrr" }).Query <TestClassOne>().First(); Assert.AreEqual(100, items.income); Assert.AreEqual(100, itemsr.income); }
public void TestDeleteTwoRecord() { var db = new NLORMSQLiteDb( connectionString); db.FilterBy(FilterType.EQUAL_AND, new { income = 901234}).Delete<TestClassOne>(); var items = db.Query<TestClassOne>(); Assert.AreEqual( 3, items.Count() ); }
public void TestSelectClass4SelectByAge() { GenTestClass4TestData(); var sqliteDbc = new NLORMSQLiteDb(connectionString); var result = sqliteDbc.FilterBy(FilterType.LESS_AND, new { Age = 14 }) .Query <TestClass4>(); Assert.AreEqual(result.Count(), 2); }
public void TestSelectClass3SelectByName() { GenTestClass3TestData(); var sqliteDbc = new NLORMSQLiteDb(connectionString); var result = sqliteDbc.FilterBy(FilterType.EQUAL_AND, new { NAME = "N5555" }) .Query <TestClass3>(); Assert.AreEqual(result.Count(), 2); }
public void TestDeleteTwoRecord() { var db = new NLORMSQLiteDb(connectionString); db.FilterBy(FilterType.EQUAL_AND, new { income = 901234 }).Delete <TestClassOne>(); var items = db.Query <TestClassOne>(); Assert.AreEqual(3, items.Count()); }
public void TestUpdateWithOrUesExpando() { var db = new NLORMSQLiteDb(connectionString); var newobj = new TestClassOne { income = 100 }; dynamic filterObjA = new ExpandoObject(); dynamic filterObjB = new ExpandoObject(); filterObjA.Id = "sssss"; filterObjB.Id = "rrrrr"; int i = db.FilterBy(FilterType.EQUAL_AND, filterObjA) .Or().FilterBy(FilterType.EQUAL_AND, filterObjB) .Update <TestClassOne>(new { income = 100 }); var items = db.FilterBy(FilterType.EQUAL_AND, filterObjA).Query <TestClassOne>()[0]; var itemsr = db.FilterBy(FilterType.EQUAL_AND, filterObjB).Query <TestClassOne>()[0]; Assert.AreEqual(100, items.income); Assert.AreEqual(100, itemsr.income); }
public void TestSelectClass1WithCons() { TestCreateTable(); var c1 = new TestClass(); c1.ID = "5555"; var c2 = new TestClass(); c2.ID = "5566"; var sqliteDbc = new NLORMSQLiteDb(connectionString); sqliteDbc.Insert <TestClass>(c1); sqliteDbc.Insert <TestClass>(c2); var result = sqliteDbc.FilterBy(FilterType.EQUAL_AND, new { ID = "5555" }) .Query <TestClass>(); Assert.AreEqual(result.Count(), 1); }