Hi,

We're using several data models in the different projects we have. Each has it's own website and we go to each of them via a portal. Now we're creating a new web application that will be the main entrance for all reporting in all the projects.

Each of these domains uses a defaultschema: Projecten, Reporting, Controlit, etc.

I now use the following configuration in the web.config but I can only initialize the SessionManager once.

<Xtensive.Orm>
<domains>
  <!-- The PerformSafely attribute below can be overwritten in the DataContext.OpenSession() -->
  <domain name="Reporting" 
          provider="sqlserver"
          connectionString="Data Source=localhost;Initial Catalog=Controlit_Facturatie;Persist Security Info=True;Integrated Security=True;MultipleActiveResultSets=True"
          upgradeMode="PerformSafely">
    <types>
      <add assembly="Fortrus.Reporting.Model" />
    </types>
    <sessions>
      <session name="default" options="ServerProfile,AllowSwitching" />
    </sessions>
  </domain>
  <domain name="Projecten"
          provider="sqlserver"
          connectionString="Data Source=localhost;Initial Catalog=Controlit_Facturatie;Persist Security Info=True;Integrated Security=True;MultipleActiveResultSets=True"
          upgradeMode="PerformSafely">
    <types>
      <add assembly="Projecten.Model" />
    </types>
    <sessions>
      <session name="default" options="ServerProfile,AllowSwitching" />
    </sessions>
  </domain>
</domains>

</xtensive.orm>

We need to combine the different data models into one configuration that the SessionManager can handle. How do we do that?

Regards Paul