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