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