public void TestInsertUserClassMuti()
{
var sqliteDbc = new NLORMSQLiteDb(connectionString);
sqliteDbc.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)
{
sqliteDbc.Insert <TestClassUser>(user);
}
var selLis = sqliteDbc.Query <TestClassUser>();
Assert.AreEqual(selLis.Count(), 30);
}
private INLORMDb createtable()
{
var db = new NLORMSQLiteDb(connectionString);
db.CreateTable <TestClassOne>();
return(db);
}
public void TestTransactionCommit()
{
var sqliteDbc = new NLORMSQLiteDb(connectionString);
sqliteDbc.CreateTable <TestClassUser>();
var trans = sqliteDbc.BeginTransaction();
var testObj = new TestClassUser();
testObj.ID = 1;
testObj.Name = "Name " + 1;
testObj.CreateTime = DateTime.Now;
sqliteDbc.Insert <TestClassUser>(testObj);
trans.Commit();
sqliteDbc.Close();
sqliteDbc = new NLORMSQLiteDb(connectionString);
var selLis = sqliteDbc.Query <TestClassUser>();
Assert.AreEqual(selLis.Count(), 1);
}
public void TestInsertUserClass()
{
var sqliteDbc = new NLORMSQLiteDb(connectionString);
sqliteDbc.CreateTable <TestClassUser>();
var testObj = new TestClassUser();
testObj.ID = 1;
testObj.Name = "Name " + 1;
testObj.CreateTime = DateTime.Now;
sqliteDbc.Insert <TestClassUser>(testObj);
var selLis = sqliteDbc.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 TestInsertUserClass()
{
var sqliteDbc = new NLORMSQLiteDb(connectionString);
sqliteDbc.CreateTable<TestClassUser>();
var testObj = new TestClassUser();
testObj.ID = 1;
testObj.Name = "Name " + 1;
testObj.CreateTime = DateTime.Now;
sqliteDbc.Insert<TestClassUser>(testObj);
var selLis = sqliteDbc.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 TestInsertUserClassMuti()
{
var sqliteDbc = new NLORMSQLiteDb(connectionString);
sqliteDbc.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)
{
sqliteDbc.Insert<TestClassUser>(user);
}
var selLis = sqliteDbc.Query<TestClassUser>();
Assert.AreEqual(selLis.Count(), 30);
}
public void TestCreateTableOnlyStringWithCfd()
{
var sqliteDbc = new NLORMSQLiteDb(connectionString);
sqliteDbc.CreateTable <TestClassOnlyStringWCfd>();
}
public void TestCreateTableOnlyTinyint()
{
var sqliteDbc = new NLORMSQLiteDb(connectionString);
sqliteDbc.CreateTable <TestClassOnlyTinyint>();
}
public void TestCreateTableOnlyInt64()
{
var sqliteDbc = new NLORMSQLiteDb(connectionString);
sqliteDbc.CreateTable <TestclassOnlyInt64>();
}
public void TestCreateTableOnlyFloatWcfd()
{
var sqliteDbc = new NLORMSQLiteDb( connectionString);
sqliteDbc.CreateTable<TestClassOnlyFloatWcfd>();
}
public void TestCreateTableOnlyDateTime()
{
var sqliteDbc = new NLORMSQLiteDb(connectionString);
sqliteDbc.CreateTable<TestClassOnlyDateTime>();
}
public void TestCreateTableOnlyInt64()
{
var sqliteDbc = new NLORMSQLiteDb( connectionString);
sqliteDbc.CreateTable<TestclassOnlyInt64>();
}
public void TestTransactionRollback()
{
var sqliteDbc = new NLORMSQLiteDb(connectionString);
sqliteDbc.CreateTable<TestClassUser>();
var trans = sqliteDbc.BeginTransaction();
var testObj = new TestClassUser();
testObj.ID = 1;
testObj.Name = "Name " + 1;
testObj.CreateTime = DateTime.Now;
sqliteDbc.Insert<TestClassUser>(testObj);
trans.Rollback();
sqliteDbc.Close();
sqliteDbc = new NLORMSQLiteDb(connectionString);
var selLis = sqliteDbc.Query<TestClassUser>();
Assert.AreEqual(selLis.Count(), 0);
}
public void TestCreateTableTestClass4()
{
var sqliteDbc = new NLORMSQLiteDb(connectionString);
sqliteDbc.CreateTable <TestClass4>();
}
public void TestCreateTableWithoutDef()
{
var sqliteDbc = new NLORMSQLiteDb(connectionString);
sqliteDbc.CreateTable <TestClass2>();
}
