tags:

views:

26

answers:

0
Q: 

NHibernate - How to map users belonging to both accounts and stores?

Hi,

We have many accounts and an account can have many stores and now I have users. A user could potentially belong to either an account or a store. Like below

model

I just feel like this is insanity and was hoping for some guidance in the matter. These are my requirements.

A user belonging to an account should have access to all the stores but a user belonging to a store should have access only to that store.

I was thinking of solving this with some sort of roles but can't figure out how to yet. How are others doing it?

related questions

IQuery NHibernate - does it HAVE to be a list?
(N)Hibernate - is it possible to dynamically map multiple tables to the one class
How can I map a list of strings to my entity using NHibernate?
Best practices for querying with NHibernate
NHibernate ISession Flush: Where and when to use it, and why?
IList.Cast<typeof(T)>() returns error, syntax looks ok
NHibernate Generators
101 tutorial for setting up nhibernate?
NHibernate Session.Flush() Sending Update Queries When No Update Has Occurred
NHibernate SetTimeout on ICriteria
Best way to manage session in NHibernate?
Has anyone moved to NHibernate 2.0 in a production environment?
NHIbernate: Difference between Restriction.In and Restriction.InG
NHibernate and Oracle connect through Windows Authenication
Is it possible to use nHibernate with Paradox database?
NHibernate 1.2 to 2.0 migration
NHibernate vs LINQ to SQL
Windows Service Increasing CPU Consumption
(N)Hibernate Auto-Join
MSTest and NHibernate
SQL 2008 Dialect Support for NHibernate
ADO.NET Entity vs NHibernate
Data Auditing in NHibernate and SqlServer
Best way to model Many-To-One Relationships in NHibernate When Dealing With a Legacy DB?
Subsonic Vs NHibernate