public void SQLiteDB_BeginTransaction_RollBack_void_ret_void() { #region Prepara EntityDemo entity1 = new EntityDemo { Clave1 = "Key1Get01", Clave2 = "Key1Get02", Campo1 = "Field1Get01", Campo2 = "Field1Get02", Campo3 = "Field1Get03" }; EntityDemo entity2 = new EntityDemo { Clave1 = "Key2Get01", Clave2 = "Key2Get02", Campo1 = "Field2Get01", Campo2 = "Field2Get02", Campo3 = "Field2Get03" }; EntityDemo entity3 = new EntityDemo { Clave1 = "Key3Get01", Clave2 = "Key3Get02", Campo1 = "Field3Get01", Campo2 = "Field3Get02", Campo3 = "Field3Get03" }; IDataBase db = null; try { db = new SQLiteDB("TestDB"); db.Open(); SQLTable <EntityDemo> table = new SQLTable <EntityDemo> { DB = db }; table.DeleteAll(); } catch (Exception) { } finally { db.Close(); } #endregion // Ejecuta IDataBase dbTran = new SQLiteDB("TestDB"); dbTran.Open(); SQLTable <EntityDemo> tableTran = new SQLTable <EntityDemo> { DB = dbTran }; tableTran.Insert(entity1); tableTran.Insert(entity2); dbTran.BeginTransaction(); tableTran.Insert(entity3); dbTran.RollBack(); dbTran.Close(); // Comprueba dbTran.Open(); EntityDemo[] entityGets = tableTran.GetAll(); dbTran.Close(); Assert.IsNotNull(entityGets); Assert.AreEqual(2, entityGets.Length); Assert.AreEqual("Key1Get01", entityGets[0].Clave1); Assert.AreEqual("Key1Get02", entityGets[0].Clave2); Assert.AreEqual("Field1Get01", entityGets[0].Campo1); Assert.AreEqual("Field1Get02", entityGets[0].Campo2); Assert.AreEqual("Field1Get03", entityGets[0].Campo3); Assert.AreEqual("Key2Get01", entityGets[1].Clave1); Assert.AreEqual("Key2Get02", entityGets[1].Clave2); Assert.AreEqual("Field2Get01", entityGets[1].Campo1); Assert.AreEqual("Field2Get02", entityGets[1].Campo2); Assert.AreEqual("Field2Get03", entityGets[1].Campo3); }