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