StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
8325907
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2011-11-30T12:24:49.347
FavoriteCount
0
LastActivityDate
2011-11-30T13:05:49.093
LastEditDate
2011-11-30T13:05:49.093
LastEditorUserId
106951
OwnerUserId
106951
ParentId
8283568
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
Here is my solution Entities: <pre><code>public class TaskTest : Entity<TaskTest> { public virtual string Name { get; set; } public virtual IList<TagTest> Tags { get; set; } public TaskTest() { Tags = new List<TagTest>(); } } public class TagTest : Entity<TagTest> { public virtual string Name { get; set; } } </code></pre> Do not take in the consideration Entity<>. Is is generic as we've implemented a IEquatable interface Next Mappings: <pre><code>public class TaskTestMap : EntityMap<TaskTest> { public TaskTestMap() { Map(x => x.Name).Not.Nullable().Length(512); HasManyToMany(x => x.Tags).Table("TaskTag").Cascade.All(); } } public class TagTastMap : EntityMap<TagTest> { public TagTastMap() { Map(x => x.Name).Not.Nullable(); } } </code></pre> I set cascade just to save tasgs on saving tasks. The repository with my criteria: <pre><code>public IList<TaskTest> GetTaskByTagIds(IList<long> tagIds) { DetachedCriteria exists = DetachedCriteria.For<TaskTest>("t") .CreateAlias("t.Tags", "tags") .Add(Restrictions.EqProperty("t.Id", "task.Id")) .Add(Restrictions.In("tags.Id", tagIds.ToArray())) .SetProjection(Projections.GroupProperty("t.Id")) .Add(Restrictions.Eq(Projections.Count("t.Id"), tagIds.Count)); ICriteria criteria = GetSession().CreateCriteria<TaskTest>("task") .Add(Subqueries.Exists(exists)); return criteria.List<TaskTest>(); } </code></pre> And the unit test which pass on my side: <pre><code> [Test] public void TestTaskTest() { //Insert data; var task1 = new TaskTest {Name = "task1"}; var task2 = new TaskTest {Name = "task2"}; var task3 = new TaskTest {Name = "task3"}; var tag1 = new TagTest {Name = "tag1"}; var tag2 = new TagTest {Name = "tag1"}; var tag3 = new TagTest {Name = "tag1"}; task1.Tags.Add(tag1); task1.Tags.Add(tag2); task2.Tags.Add(tag1); task2.Tags.Add(tag3); task3.Tags.Add(tag3); _repository.AddToSession(task1); _repository.AddToSession(task2); _repository.AddToSession(task3); FlushAndClearSession(); //We will try to get all task which a taged with tag1 and tag2. The result should be task1 var tagsId = new List<long> {tag1.Id, tag2.Id}; var result = _repository.GetTaskByTagIds(tagsId); Assert.That(result, Is.Not.Null); Assert.That(result, Is.Not.Empty); Assert.That(result.Count, Is.EqualTo(1)); Assert.That(result[0].Name, Is.EqualTo("task1")); } </code></pre> and the sql statement is: <pre><code> exec sp_executesql N'SELECT this_.Id as Id50_0_, this_.Version as Version50_0_, this_.Name as Name50_0_ FROM [TaskTests] this_ WHERE exists ( SELECT this_0_.Id as y0_ FROM [TaskTests] this_0_ inner join TaskTag tags3_ on this_0_.Id=tags3_.TaskTestId inner join [TagTests] tags1_ on tags3_.TagTestId=tags1_.Id WHERE this_0_.Id = this_.Id and tags1_.Id in (@p0, @p1) GROUP BY this_0_.Id HAVING count(this_0_.Id) = @p2)', N'@p0 bigint,@p1 bigint,@p2 int', @p0=9000,@p1=9001,@p2=2 </code></pre> Regards, /Ion
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. PONHibernate Many to Many Criteria Task Tag Example
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USisuruceanu
UserOwnerUserId
1. USisuruceanu
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. PONHibernate Many to Many Criteria Task Tag Example
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTBountyClose
CommentsPostId
1. COThanks! I just could not see the problem. Using CreateAlias was more clear to me than CreateCriteria.
 singulars
 PostPostId
 PO
 UserUserId
 USKevin

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.