public async Task include_to_dictionary_async()
{
var user1 = new User();
var user2 = new User();
var issue1 = new Issue {
AssigneeId = user1.Id, Title = "Garage Door is busted"
};
var issue2 = new Issue {
AssigneeId = user2.Id, Title = "Garage Door is busted"
};
var issue3 = new Issue {
AssigneeId = user2.Id, Title = "Garage Door is busted"
};
theSession.Store(user1, user2);
theSession.Store(issue1, issue2, issue3);
await theSession.SaveChangesAsync().ConfigureAwait(false);
using (var query = theStore.QuerySession())
{
var dict = new Dictionary <Guid, User>();
await query.Query <Issue>().Include(x => x.AssigneeId, dict).ToListAsync().ConfigureAwait(false);
dict.Count.ShouldBe(2);
dict.ContainsKey(user1.Id).ShouldBeTrue();
dict.ContainsKey(user2.Id).ShouldBeTrue();
}
}
public async Task include_to_list_with_orderby_ascending_async()
{
var user1 = new User();
var user2 = new User();
var issue1 = new Issue {
AssigneeId = user1.Id, Title = "Garage Door is busted"
};
var issue2 = new Issue {
AssigneeId = user2.Id, Title = "Garage Door is busted"
};
var issue3 = new Issue {
AssigneeId = user2.Id, Title = "Garage Door is busted"
};
theSession.Store(user1, user2);
theSession.Store(issue1, issue2, issue3);
await theSession.SaveChangesAsync().ConfigureAwait(false);
using (var query = theStore.QuerySession())
{
var list = new List <User>();
await query.Query <Issue>().Include(x => x.AssigneeId, list)
.OrderBy(x => x.Id)
.ToListAsync().ConfigureAwait(false);
list.Count.ShouldBe(2);
list.Any(x => x.Id == user1.Id);
list.Any(x => x.Id == user2.Id);
}
}
public void include_to_dictionary()
{
var user1 = new User();
var user2 = new User();
var issue1 = new Issue {
AssigneeId = user1.Id, Title = "Garage Door is busted"
};
var issue2 = new Issue {
AssigneeId = user2.Id, Title = "Garage Door is busted"
};
var issue3 = new Issue {
AssigneeId = user2.Id, Title = "Garage Door is busted"
};
theSession.Store(user1, user2);
theSession.Store(issue1, issue2, issue3);
theSession.SaveChanges();
using (var query = theStore.QuerySession())
{
var dict = new Dictionary <Guid, User>();
query.Query <Issue>().Include(x => x.AssigneeId, dict).ToArray();
dict.Count.ShouldBe(2);
dict.ContainsKey(user1.Id).ShouldBeTrue();
dict.ContainsKey(user2.Id).ShouldBeTrue();
}
}
public void include_is_running_through_identitymap()
{
var user1 = new User();
var user2 = new User();
var issue1 = new Issue {
AssigneeId = user1.Id, Title = "Garage Door is busted"
};
var issue2 = new Issue {
AssigneeId = user2.Id, Title = "Garage Door is busted"
};
var issue3 = new Issue {
AssigneeId = user2.Id, Title = "Garage Door is busted"
};
theSession.Store(user1, user2);
theSession.Store(issue1, issue2, issue3);
theSession.SaveChanges();
// This will only work with a non-NulloIdentityMap
using (var query = theStore.OpenSession())
{
var dict = new Dictionary <Guid, User>();
query.Query <Issue>().Include(x => x.AssigneeId, dict).ToArray();
query.Load <User>(user1.Id).ShouldBeSameAs(dict[user1.Id]);
query.Load <User>(user2.Id).ShouldBeSameAs(dict[user2.Id]);
}
}
public void include_to_list()
{
var user1 = new User();
var user2 = new User();
var issue1 = new Issue {
AssigneeId = user1.Id, Title = "Garage Door is busted"
};
var issue2 = new Issue {
AssigneeId = user2.Id, Title = "Garage Door is busted"
};
var issue3 = new Issue {
AssigneeId = user2.Id, Title = "Garage Door is busted"
};
theSession.Store(user1, user2);
theSession.Store(issue1, issue2, issue3);
theSession.SaveChanges();
using (var query = theStore.QuerySession())
{
var list = new List <User>();
query.Query <Issue>().Include <User>(x => x.AssigneeId, list).ToArray();
list.Count.ShouldBe(2);
list.Any(x => x.Id == user1.Id);
list.Any(x => x.Id == user2.Id);
}
}
public void simple_include_for_a_single_document_using_outer_join()
{
var issue = new Issue {
AssigneeId = null, Title = "Garage Door is busted"
};
theSession.Store(issue);
theSession.SaveChanges();
using (var query = theStore.QuerySession())
{
User included = null;
var issue2 = query.Query <Issue>()
.Include <User>(x => x.AssigneeId, x => included = x, JoinType.LeftOuter)
.Where(x => x.Title == issue.Title)
.Single();
included.ShouldBeNull();
issue2.ShouldNotBeNull();
}
}
public void simple_compiled_include_for_a_single_document()
{
var user = new User();
var issue = new Issue {
AssigneeId = user.Id, Title = "Garage Door is busted"
};
theSession.Store <object>(user, issue);
theSession.SaveChanges();
using (var query = theStore.QuerySession())
{
var issueQuery = new IssueByTitleWithAssignee {
Title = issue.Title
};
var issue2 = query.Query(issueQuery);
SpecificationExtensions.ShouldNotBeNull(issueQuery.Included);
issueQuery.Included.Single().Id.ShouldBe(user.Id);
SpecificationExtensions.ShouldNotBeNull(issue2);
}
}
public void include_to_list_using_outer_join()
{
var user1 = new User();
var user2 = new User();
var issue1 = new Issue {
AssigneeId = user1.Id, Title = "Garage Door is busted"
};
var issue2 = new Issue {
AssigneeId = user2.Id, Title = "Garage Door is busted"
};
var issue3 = new Issue {
AssigneeId = user2.Id, Title = "Garage Door is busted"
};
var issue4 = new Issue {
AssigneeId = null, Title = "Garage Door is busted"
};
theSession.Store(user1, user2);
theSession.Store(issue1, issue2, issue3, issue4);
theSession.SaveChanges();
using (var query = theStore.QuerySession())
{
var list = new List <User>();
var issues = query.Query <Issue>().Include <User>(x => x.AssigneeId, list, JoinType.LeftOuter).ToArray();
list.Count.ShouldBe(3);
list.Any(x => x.Id == user1.Id);
list.Any(x => x.Id == user2.Id);
list.Any(x => x == null);
issues.Length.ShouldBe(4);
}
}
public void simple_include_for_a_single_document()
{
var user = new User();
var issue = new Issue {
AssigneeId = user.Id, Title = "Garage Door is busted"
};
theSession.Store <object>(user, issue);
theSession.SaveChanges();
using (var query = theStore.QuerySession())
{
User included = null;
var issue2 = query.Query <Issue>()
.Include <User>(x => x.AssigneeId, x => included = x)
.Where(x => x.Title == issue.Title)
.Single();
included.ShouldNotBeNull();
included.Id.ShouldBe(user.Id);
issue2.ShouldNotBeNull();
}
}
public void include_with_any_containment_where_for_a_single_document()
{
var user = new User();
var issue = new Issue {
AssigneeId = user.Id, Tags = new [] { "DIY" }, Title = "Garage Door is busted"
};
theSession.Store <object>(user, issue);
theSession.SaveChanges();
using (var query = theStore.QuerySession())
{
User included = null;
var issue2 = query.Query <Issue>()
.Include <User>(x => x.AssigneeId, x => included = x)
.Where(x => x.Tags.Any(t => t == "DIY"))
.Single();
included.ShouldNotBeNull();
included.Id.ShouldBe(user.Id);
issue2.ShouldNotBeNull();
}
}
public async Task include_within_batch_query()
{
var user1 = new User();
var user2 = new User();
var issue1 = new Issue {
AssigneeId = user1.Id, Title = "Garage Door is busted #1"
};
var issue2 = new Issue {
AssigneeId = user2.Id, Title = "Garage Door is busted #2"
};
var issue3 = new Issue {
AssigneeId = user2.Id, Title = "Garage Door is busted #3"
};
theSession.Store(user1, user2);
theSession.Store(issue1, issue2, issue3);
theSession.SaveChanges();
using (var query = theStore.QuerySession())
{
User included = null;
var list = new List <User>();
var dict = new Dictionary <Guid, User>();
// SAMPLE: batch_include
var batch = query.CreateBatchQuery();
var found = batch.Query <Issue>()
.Include <User>(x => x.AssigneeId, x => included = x)
.Where(x => x.Title == issue1.Title)
.Single();
// ENDSAMPLE
var toList = batch.Query <Issue>()
.Include <User>(x => x.AssigneeId, list).ToList();
var toDict = batch.Query <Issue>()
.Include(x => x.AssigneeId, dict).ToList();
await batch.Execute();
(await found).Id.ShouldBe(issue1.Id);
included.ShouldNotBeNull();
included.Id.ShouldBe(user1.Id);
(await toList).Count.ShouldBe(3);
list.Count.ShouldBe(2); // Only 2 users
(await toDict).Count.ShouldBe(3);
dict.Count.ShouldBe(2);
dict.ContainsKey(user1.Id).ShouldBeTrue();
dict.ContainsKey(user2.Id).ShouldBeTrue();
}
}
