Retrieving distinct values in mapping

Question

I have an existing view which has too much data in it. Unfortunately I cannot get rid of it so I need to try to work around it using my NHibernate mapping. The idea is to have NH issue the following query:

SELECT DISTINCT User_Id, Module_Id, Application_Id, RightsMask FROM V_UserApplicationPermissions WHERE User_Id = ?

My current mapping for this list of AccessControlEntry types looks like this:

HasMany<AccessControlEntry>(x => x.Rights) .WithTableName("V_UserApplicationPermissions") .KeyColumnNames.Add("User_Id") .Component(c => { c.Map(x => x.Module, "Module_Id"); c.Map(x => x.Application, "App_Id"); c.Map(x => x.Rights, "RightsMask").CustomTypeIs<ApplicationRightsType>(); }) .Not.LazyLoad();

Any thoughts on how to have NHibernate put a DISTINCT keyword in there during the query?

UPDATE: Let me share the rest of the User map that might help as to why it isn't a straight forward criteria:

WithTable("Users"); Id(x => x.Id, "UserId"); Map(x => x.Name, "UserName"); HasMany<long>(x => x.Clients) .WithTableName("V_UserClients") .KeyColumnNames.Add("UserId") .AsElement("ClientId");

Colin Bowern · Accepted Answer · 2010-03-11 16:28:23Z

Olivier Coanet from the NHUsers mailing list suggested hacking it into the WithTableName which worked:

HasMany<AccessControlEntry>(x => x.Rights) .WithTableName("(SELECT DISTINCT User_Id, Module_Id, App_Id, RightsMask FROM V_UserApplicationPermissions)") .KeyColumnNames.Add("User_Id") .Component(c => { c.Map(x => x.Module, "Module_Id"); c.Map(x => x.Application, "App_Id"); c.Map(x => x.Rights, "RightsMask").CustomTypeIs<ApplicationRightsType>(); })

Collectives™ on Stack Overflow

Retrieving distinct values in mapping

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related