This guy added the tenantid with an interceptor, which is worth a try: http://www.agileatwork.com/bolt-on-multi-tenancy-in-asp-net-mvc-with-unity-and-nhibernate-part-ii-commingled-data/
On Fri, Dec 16, 2011 at 1:07 AM, [email protected] < [email protected]> wrote: > Thank you so very much. The filter hint solves my problem to a great > extent. One last question. Is there anyway I can force the facilityId > filter as part of the update/delete operation as well? > > For example, when I'm updating/delete the Admission record... the > where clause of the update/delete statement should also include the > facilityId filter as well, so that only one partition is scanned. > > Thanks a ton once again. > > > On Dec 15, 7:14 pm, Anne Epstein <[email protected]> wrote: > > It sounds like what you really have is a multitenancy structure with > > facility as your tenantid. Using the composite feature in nhibernate > isn't > > going to work for you - it really is intended for true composite key > > situations, not multitenancy, but there are some other avenues to > consider. > > One is to use the filter feature of nhibernate: > http://ayende.com/blog/3993/nhibernate-filtersand this is another > > interesting way with views: > http://blogs.imeta.co.uk/jyoung/archive/2010/03/22/845.aspxIt's too bad > > you can't change the structure, table per tenant is much cleaner than > > having a tenantid like this-tenantid ends up being more complex long term > > (gotta remember those filters and where conditions) with far more risk > of > > data leakage. > > > > Good luck! > > Anne > > > > On Thu, Dec 15, 2011 at 4:32 AM, [email protected] < > > > > > > > > > > > > > > > > [email protected]> wrote: > > > I have the following scenario > > > > > Table 1 -Admission > > > Fields > > > FacilityId - BigInt (Pk) > > > AdmissionId BigInt (Pk) > > > PersonName - varchar(60) > > > > > Table 2 - ResponsibleParty > > > Fields > > > FacilityId - BigInt (Pk) > > > ResponsiblePartyId (Pk) > > > AdmissionId (Fk) > > > > > As you can see that all the tables have facilityId as part of their > > > compound primary key and all the tables are partitioned on the basis > > > of the facilityId. Hence the keys must be compound keys. > > > > > Can someone tell me how to configure a compound key in NHibernate such > > > that one of the keys is an assigned key whereas the other one is > > > generated key using one of the generators. > > > > > Please keep the following in mind: > > > 1. The database design is fixed and cannot be changed. Call this a > > > design constraint. > > > > > I love NHibernate, but right now it's looking as if I might have to > > > forgo using it in this particular project. Help would be greatly > > > appreciated. > > > > > Thanks > > > > > -- > > > You received this message because you are subscribed to the Google > Groups > > > "nhusers" group. > > > To post to this group, send email to [email protected]. > > > To unsubscribe from this group, send email to > > > [email protected]. > > > For more options, visit this group at > > >http://groups.google.com/group/nhusers?hl=en. > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
