Exemplos de NLORMSQLiteDb.Close em C# (CSharp)

Exemplo n.º 1

        public void TestInsertUserClassMutiRollback()
        {
            var sqliteDbc = new NLORMSQLiteDb(connectionString);

            sqliteDbc.CreateTable <TestClassUser>();
            var trans      = sqliteDbc.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)
            {
                sqliteDbc.Insert <TestClassUser>(user);
            }
            trans.Rollback();
            sqliteDbc.Close();
            sqliteDbc = new NLORMSQLiteDb(connectionString);
            var selLis = sqliteDbc.Query <TestClassUser>();

            Assert.AreEqual(selLis.Count(), 0);
        }

Exemplo n.º 2

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

Exemplo n.º 3

Arquivo: TestTransaction.cs Projeto: kkchuchu/NLORM

        public void TestInsertUserClassMutiCommit()
        {
            var sqliteDbc = new NLORMSQLiteDb(connectionString);
            sqliteDbc.CreateTable<TestClassUser>();
            var trans = sqliteDbc.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)
            {
                sqliteDbc.Insert<TestClassUser>(user);
            }
            trans.Commit();
            sqliteDbc.Close();
            sqliteDbc = new NLORMSQLiteDb(connectionString);
            var selLis = sqliteDbc.Query<TestClassUser>();
            Assert.AreEqual(selLis.Count(), 30);
        }

Exemplo n.º 4

Arquivo: TestTransaction.cs Projeto: kkchuchu/NLORM

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