public void TestInsertUserClassMutiRollback()
{
var mySqlDbc = new NLORMMySqlDb(connectionString);
var trans = mySqlDbc.BeginTransaction();
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)
{
mySqlDbc.Insert <TestClassUser>(user);
}
trans.Rollback();
mySqlDbc.Close();
mySqlDbc = new NLORMMySqlDb(connectionString);
var selLis = mySqlDbc.Query <TestClassUser>();
Assert.AreEqual(selLis.Count(), 0);
}
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 TestInsertUserClassMutiCommit()
{
var db = new NLORMMSSQLDb(ConnectionString);
db.CreateTable <TestClassUser>();
var trans = db.BeginTransaction();
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)
{
db.Insert <TestClassUser>(user);
}
trans.Commit();
db.Close();
db = new NLORMMSSQLDb(ConnectionString);
var selLis = db.Query <TestClassUser>();
Assert.AreEqual(selLis.Count(), 30);
}
public void TestTransactionCommit()
{
var mySqlDbc = new NLORMMySqlDb(connectionString);
var trans = mySqlDbc.BeginTransaction();
var testObj = new TestClassUser();
testObj.ID = 1;
testObj.Name = "Name " + 1;
testObj.CreateTime = DateTime.Now;
mySqlDbc.Insert <TestClassUser>(testObj);
trans.Commit();
mySqlDbc.Close();
mySqlDbc = new NLORMMySqlDb(connectionString);
var selLis = mySqlDbc.Query <TestClassUser>();
Assert.AreEqual(selLis.Count(), 1);
}
public void TestTransactionCommit()
{
var db = new NLORMMSSQLDb(ConnectionString);
db.CreateTable <TestClassUser>();
var trans = db.BeginTransaction();
var testObj = new TestClassUser();
testObj.ID = 1;
testObj.Name = "Name " + 1;
testObj.CreateTime = DateTime.Now;
db.Insert <TestClassUser>(testObj);
trans.Commit();
db.Close();
db = new NLORMMSSQLDb(ConnectionString);
var selLis = db.Query <TestClassUser>();
Assert.AreEqual(selLis.Count(), 1);
}
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 TestInsertUserClass()
{
var MySqlDbc = new NLORMMySqlDb(connectionString);
var testObj = new TestClassUser();
testObj.ID = 1;
testObj.Name = "Name " + 1;
testObj.CreateTime = DateTime.Now;
MySqlDbc.Insert <TestClassUser>(testObj);
var selLis = MySqlDbc.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.ToString(), selUser.CreateTime.ToString());
}
public void TestInsertUserClass()
{
var db = new NLORMMSSQLDb(ConnectionString);
db.CreateTable <TestClassUser>();
var testObj = new TestClassUser();
testObj.ID = 1;
testObj.Name = "Name " + 1;
testObj.CreateTime = DateTime.Now;
db.Insert <TestClassUser>(testObj);
var selLis = db.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 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);
}
