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);
}
}
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 Test_Stored_Procedure_with_Multiple_Results()
{
using (var db = new TrackerDataContext {
Log = Console.Out
})
{
// Create Procedure [dbo].[GetUsersWithRoles]
// As
// Select * From [User]
// Select * From UserRole
// GO
var results = db.GetUsersWithRoles();
List <User> users = results.GetResult <User>().ToList();
List <UserRole> roles = results.GetResult <UserRole>().ToList();
}
}
