public void Test_Batch_Queries()
{
using (var db = new TrackerDataContext {
Log = Console.Out
})
{
var q1 = from u in db.User select u;
var q2 = from ur in db.UserRole select ur;
IMultipleResults results = db.ExecuteQuery(q1, q2);
List <User> users = results.GetResult <User>().ToList();
List <UserRole> roles = results.GetResult <UserRole>().ToList();
}
}
public void ExecuteBatch()
{
var db = new TrackerDataContext {
Log = Console.Out
};
// build up queries
var q1 = db.Task.Take(10).ToList();
var q2 = db.Task.Take(10);
var dbCommand = db.GetCommand(q2, true);
var result = db.ExecuteQuery <Task>(dbCommand.CommandText);
var list = result.ToList();
}
public void ExecuteQueryLoadWith()
{
var db = new TrackerDataContext {
Log = Console.Out
};
db.DeferredLoadingEnabled = false;
db.ObjectTrackingEnabled = false;
DataLoadOptions options = new DataLoadOptions();
options.LoadWith <Task>(t => t.CreatedUser);
db.LoadOptions = options;
var q1 = db.User
.ByEmailAddress("*****@*****.**");
var q2 = db.Task
.Where(t => t.LastModifiedBy == "*****@*****.**");
var result = db.ExecuteQuery(q1, q2);
Assert.IsNotNull(result);
var userResult = result.GetResult <User>();
Assert.IsNotNull(userResult);
var users = userResult.ToList();
Assert.IsNotNull(users);
var taskResult = result.GetResult <Task>();
Assert.IsNotNull(taskResult);
var tasks = taskResult.ToList();
Assert.IsNotNull(tasks);
}
