Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Jun 20th, 2012  |  syntax: None  |  size: 0.88 KB  |  hits: 9  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. EF4 how to switch schema (e.g. dbo -> custId) so that identical tables are stored under multiple schemas
  2. <!-- SSDL content -->
  3. <edmx:StorageModels>
  4.   <Schema Namespace="Model.Store" Alias="Self" Provider="System.Data.SqlClient"
  5.           ProviderManifestToken="2008"
  6.           xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator"
  7.           xmlns="http://schemas.microsoft.com/ado/2009/02/edm/ssdl">
  8.     <EntityContainer Name="ModelStoreContainer">
  9.       <EntitySet Name="TestEntitySet" EntityType="Model.Store.TestEntitySet"
  10.                  store:Type="Tables" Schema="dbo" />
  11.     </EntityContainer>
  12.     <EntityType Name="TestEntitySet">
  13.       <Key>
  14.         <PropertyRef Name="Id" />
  15.       </Key>
  16.       <Property Name="Id" Type="int" StoreGeneratedPattern="Identity"
  17.                 Nullable="false" />
  18.     </EntityType>
  19.   </Schema>
  20. </edmx:StorageModels>
create a new version of this paste RAW Paste Data