DevForce Community Forum : Multi-Tenant Support? http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Multi-Tenant Support? Sun, 12 Apr 2026 21:38:57 -700 Wed, 01 Jun 2011 15:34:35 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2736 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Multi-Tenant Support? : You can enforce tenant partitioning... http://www.ideablade.com/forum/forum_posts.asp?TID=2736&PID=10876#10876 Author: ting
Subject: 2736
Posted: 01-Jun-2011 at 3:34pm

You can enforce tenant partitioning on the server by overriding FilterQuery in the EntityServerQueryInterceptor:
http://drc.ideablade.com/xwiki/bin/view/Documentation/query-server-lifecycle-events#HFilteringthequery

You might also find this page helpful:
http://drc.ideablade.com/xwiki/bin/view/Documentation/filtering-queries-globally

So, if you have a TenantID column on your tables, you can examine the IPrincipal of the user in the interceptor and apply a .Where(TenantId == userPrincipal.TenantId) clause to the query. This ensures that users only get data related to their TenantId, even if the client-side application developer forgets to apply the restriction (or is hacked to remove the restriction).

]]> Wed, 01 Jun 2011 15:34:35 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2736&PID=10876#10876 Multi-Tenant Support? : Thank you! But I don't... http://www.ideablade.com/forum/forum_posts.asp?TID=2736&PID=10875#10875 Author: bap1
Subject: 2736
Posted: 01-Jun-2011 at 3:05pm

Thank you!  But I don't want to target multiple databases.  We have 1000s of customers and that's way too many db's to manage.  All data is in same db partitioned by key.  I didn't see anything in your docs related to best practices on this type of implementation.  Any suggestions would be much appreciated!]]> Wed, 01 Jun 2011 15:05:18 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2736&PID=10875#10875 Multi-Tenant Support? : Hi bap1,You will find resourceful... http://www.ideablade.com/forum/forum_posts.asp?TID=2736&PID=10872#10872 Author: sbelini
Subject: 2736
Posted: 01-Jun-2011 at 10:30am

Hi bap1,
 
You will find resourceful information in the DevForce Resource Center.
Look for the Multiple EntityServers and Target different databases dynamically topics.
You will also find the DataSourceExtensions sample usefull.
 
Silvio.
]]> Wed, 01 Jun 2011 10:30:03 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2736&PID=10872#10872 Multi-Tenant Support? : Would some please point me... http://www.ideablade.com/forum/forum_posts.asp?TID=2736&PID=10871#10871 Author: bap1
Subject: 2736
Posted: 01-Jun-2011 at 7:10am

Would some please point me to info on Devforce's mult-tenant features? You mention this in your marketing materials, but I don't see any reference to it in your docs.
We have a large multi-tennant app we are considering moving to Devforce.  We partition the database by customerID key and need to ensure all queries use customerID on the server...based on the user context of the currently logged in user.   I assume we would implement a server side query interceptor?  Can someone provide an example on how to do this?
 
Thanks in advance.
]]> Wed, 01 Jun 2011 07:10:34 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2736&PID=10871#10871