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