StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POMultitenant NHibernate application with with separate SQL Server schema for each tenant
primarykey
Id
4569169
data
AcceptedAnswerId
4571788
AnswerCount
2
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2010-12-31T09:11:31.387
FavoriteCount
2
LastActivityDate
2010-12-31T18:47:16.813
LastEditDate
LastEditorUserId
0
OwnerUserId
5362
ParentId
0
PostTypeId
1
Score
4
ViewCount
708
LastEditorDisplayName
text
Body
I am writing a new multi-tenant WCF RIA application. I plan to have a shared database with separate SQL Server schema for each tenant. I would like to use NHibernate for object-ralational mapping. Configuration of SQL Server schema in mapping classes doesn't help because it is static and would need one set of mapping classes for each tenant. Is it possible to dynamically configure ISession which SQL Server schema should be used for mapping objects to tables?
Tags
<sql-server><nhibernate><multi-tenant>
Title
Multitenant NHibernate application with with separate SQL Server schema for each tenant
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USBranko
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POMultitenant NHibernate application with with separate SQL Server schema for each tenant
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 POMultitenant NHibernate application with with separate SQL Server schema for each tenant
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 POMultitenant NHibernate application with with separate SQL Server schema for each tenant
 UserUserId
 USMafuba
 VoteTypeVoteTypeId
 VTFavorite
CommentsPostId
1. COis there any link between each schema/client?
 singulars
 PostPostId
 POMultitenant NHibernate application with with separate SQL Server schema for each tenant
 UserUserId
 USgbn
2. COYes, each client (tenant) would have a separate schema.
 singulars
 PostPostId
 POMultitenant NHibernate application with with separate SQL Server schema for each tenant
 UserUserId
 USBranko

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.