public void TestInsertClassMutiData()
{
TestCreateTable();
var sqliteDbc = new NLORMSQLiteDb(connectionString);
for (int i = 0; i < 600; i++)
{
var c1 = new TestClass();
c1.ID = "id"+i.ToString();
sqliteDbc.Insert<TestClass>(c1);
}
var result = sqliteDbc.Query<TestClass>("SELECT * FROM TestClass");
Assert.AreEqual(result.Count(), 600);
}
public void TestSelectClass1()
{
TestCreateTable();
var c1 = new TestClass();
c1.ID = "5555";
var sqliteDbc = new NLORMSQLiteDb(connectionString);
sqliteDbc.Insert<TestClass>(c1);
var result = sqliteDbc.Query<TestClass>();
Assert.AreEqual(result.Count(), 1);
}
public void TestInsertClass2()
{
TestCreateTableWithoutDef();
var c1 = new TestClass2();
c1.ID = "5555";
var sqliteDbc = new NLORMSQLiteDb(connectionString);
sqliteDbc.Insert<TestClass2>(c1);
var d1 = new { a1 = 1 };
var result = sqliteDbc.Query<TestClass2>("SELECT * FROM TestClass2");
Assert.AreEqual(result.Count(), 1);
}
