title: multi tenant shared database with common data between tenants
body: <p>I have a multi tenant application with a single database with all records containing a TenantId.  There are, however, situations where we want to have common data for all tenants to benefit from.  We are actually rebuilding an old ASP( noir, not clasic ) app and in that app they have a TenantId =1 where all the common stuff goes.  This seems kind of hacky to me as you end up with queries that say where TenantId=342 || tenantId=1.<br>
  Is there a better way to do this?</p>
  
  <p>Thanks,</p>
  
  <p>Raif</p>