public void TransactionScopeTest3() { using (var scope = new TransactionScope(TransactionScopeOption.Required, TimeSpan.FromMinutes(10))) { using (var db = new TrackerDataContext()) { db.BeginTransaction(); var users = db.GetUsersWithRoles(); db.CommitTransaction(); } scope.Complete(); } }
public void ThreadSafeGetNamedQueryTest() { for (int tries = 0; tries < 10; tries++) { using (var db = new TrackerDataContext()) { var t1 = System.Threading.Tasks.Task.Factory.StartNew(() => db.GetUsersWithRoles()); var t2 = System.Threading.Tasks.Task.Factory.StartNew(() => db.GetUsersWithRoles()); var t3 = System.Threading.Tasks.Task.Factory.StartNew(() => db.GetUsersWithRoles()); var users = db.GetUsersWithRoles(); System.Threading.Tasks.Task.WaitAll(t1, t2, t3); Assert.Greater(users.Count, 0); } } }
public void TransactionScopeTest2() { using (var scope = new TransactionScope(TransactionScopeOption.Required, TimeSpan.FromMinutes(10))) { using (var db = new TrackerDataContext()) { var users = db.GetUsersWithRoles(); } // no scope.Complete - rollback transaction } }
public void StoreProcs() { using (var db = new TrackerDataContext()) { var roles = db.RolesForUser(UserId); var users = db.GetUsersWithRoles(); Assert.AreEqual(1, roles.Count); Assert.Greater(users.Count, 0); } }