diff options
Diffstat (limited to 'projecttemplates/WebFormsRelyingParty/Model.edmx')
| -rw-r--r-- | projecttemplates/WebFormsRelyingParty/Model.edmx | 225 |
1 files changed, 225 insertions, 0 deletions
diff --git a/projecttemplates/WebFormsRelyingParty/Model.edmx b/projecttemplates/WebFormsRelyingParty/Model.edmx new file mode 100644 index 0000000..c23b3df --- /dev/null +++ b/projecttemplates/WebFormsRelyingParty/Model.edmx @@ -0,0 +1,225 @@ +<?xml version="1.0" encoding="utf-8"?> +<edmx:Edmx Version="1.0" xmlns:edmx="http://schemas.microsoft.com/ado/2007/06/edmx"> + <!-- EF Runtime content --> + <edmx:Runtime> + <!-- SSDL content --> + <edmx:StorageModels> + <Schema Namespace="DatabaseModel.Store" Alias="Self" Provider="System.Data.SqlClient" ProviderManifestToken="2005" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns="http://schemas.microsoft.com/ado/2006/04/edm/ssdl"> + <EntityContainer Name="DatabaseModelStoreContainer"> + <EntitySet Name="AuthenticationToken" EntityType="DatabaseModel.Store.AuthenticationToken" store:Type="Tables" Schema="dbo" /> + <EntitySet Name="Role" EntityType="DatabaseModel.Store.Role" store:Type="Tables" Schema="dbo" /> + <EntitySet Name="User" EntityType="DatabaseModel.Store.User" store:Type="Tables" Schema="dbo" /> + <EntitySet Name="UserRole" EntityType="DatabaseModel.Store.UserRole" store:Type="Tables" Schema="dbo" /> + <AssociationSet Name="FK_AuthenticationToken_User" Association="DatabaseModel.Store.FK_AuthenticationToken_User"> + <End Role="User" EntitySet="User" /> + <End Role="AuthenticationToken" EntitySet="AuthenticationToken" /> + </AssociationSet> + <AssociationSet Name="FK_UserRole_Role" Association="DatabaseModel.Store.FK_UserRole_Role"> + <End Role="Role" EntitySet="Role" /> + <End Role="UserRole" EntitySet="UserRole" /> + </AssociationSet> + <AssociationSet Name="FK_UserRole_User" Association="DatabaseModel.Store.FK_UserRole_User"> + <End Role="User" EntitySet="User" /> + <End Role="UserRole" EntitySet="UserRole" /> + </AssociationSet> + </EntityContainer> + <EntityType Name="AuthenticationToken"> + <Key> + <PropertyRef Name="Id" /> + </Key> + <Property Name="Id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" /> + <Property Name="UserId" Type="int" Nullable="false" /> + <Property Name="OpenIdClaimedIdentifier" Type="nvarchar" Nullable="false" MaxLength="250" /> + <Property Name="OpenIdFriendlyIdentifier" Type="nvarchar" MaxLength="250" /> + </EntityType> + <EntityType Name="Role"> + <Key> + <PropertyRef Name="Id" /> + </Key> + <Property Name="Id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" /> + <Property Name="Name" Type="nvarchar" Nullable="false" MaxLength="50" /> + </EntityType> + <EntityType Name="User"> + <Key> + <PropertyRef Name="Id" /> + </Key> + <Property Name="Id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" /> + <Property Name="FirstName" Type="nvarchar" MaxLength="50" /> + <Property Name="LastName" Type="nvarchar" MaxLength="50" /> + <Property Name="EmailAddress" Type="nvarchar" MaxLength="100" /> + </EntityType> + <EntityType Name="UserRole"> + <Key> + <PropertyRef Name="UserId" /> + <PropertyRef Name="RoleId" /> + </Key> + <Property Name="UserId" Type="int" Nullable="false" /> + <Property Name="RoleId" Type="int" Nullable="false" /> + </EntityType> + <Association Name="FK_AuthenticationToken_User"> + <End Role="User" Type="DatabaseModel.Store.User" Multiplicity="1"> + <OnDelete Action="Cascade" /> + </End> + <End Role="AuthenticationToken" Type="DatabaseModel.Store.AuthenticationToken" Multiplicity="*" /> + <ReferentialConstraint> + <Principal Role="User"> + <PropertyRef Name="Id" /> + </Principal> + <Dependent Role="AuthenticationToken"> + <PropertyRef Name="UserId" /> + </Dependent> + </ReferentialConstraint> + </Association> + <Association Name="FK_UserRole_Role"> + <End Role="Role" Type="DatabaseModel.Store.Role" Multiplicity="1"> + <OnDelete Action="Cascade" /> + </End> + <End Role="UserRole" Type="DatabaseModel.Store.UserRole" Multiplicity="*" /> + <ReferentialConstraint> + <Principal Role="Role"> + <PropertyRef Name="Id" /> + </Principal> + <Dependent Role="UserRole"> + <PropertyRef Name="RoleId" /> + </Dependent> + </ReferentialConstraint> + </Association> + <Association Name="FK_UserRole_User"> + <End Role="User" Type="DatabaseModel.Store.User" Multiplicity="1"> + <OnDelete Action="Cascade" /> + </End> + <End Role="UserRole" Type="DatabaseModel.Store.UserRole" Multiplicity="*" /> + <ReferentialConstraint> + <Principal Role="User"> + <PropertyRef Name="Id" /> + </Principal> + <Dependent Role="UserRole"> + <PropertyRef Name="UserId" /> + </Dependent> + </ReferentialConstraint> + </Association> + </Schema></edmx:StorageModels> + <!-- CSDL content --> + <edmx:ConceptualModels> + <Schema Namespace="DatabaseModel" Alias="Self" xmlns="http://schemas.microsoft.com/ado/2006/04/edm"> + <EntityContainer Name="DatabaseEntities"> + <EntitySet Name="Role" EntityType="DatabaseModel.Role" /> + <EntitySet Name="User" EntityType="DatabaseModel.User" /> + <AssociationSet Name="UserRole" Association="DatabaseModel.UserRole"> + <End Role="Role" EntitySet="Role" /> + <End Role="User" EntitySet="User" /> + </AssociationSet> + <EntitySet Name="AuthenticationToken" EntityType="DatabaseModel.AuthenticationToken" /> + <AssociationSet Name="UserAuthenticationToken" Association="DatabaseModel.UserAuthenticationToken"> + <End Role="User" EntitySet="User" /> + <End Role="AuthenticationToken" EntitySet="AuthenticationToken" /></AssociationSet> + </EntityContainer> + <EntityType Name="AuthenticationToken" Abstract="false"> + <Key> + <PropertyRef Name="Id" /></Key> + <Property Name="Id" Type="Int32" Nullable="false" a:SetterAccess="Public" xmlns:a="http://schemas.microsoft.com/ado/2006/04/codegeneration" /> + <NavigationProperty Name="User" Relationship="DatabaseModel.UserAuthenticationToken" FromRole="AuthenticationToken" ToRole="User" /> + <Property Name="ClaimedIdentifier" Type="String" Nullable="false" /> + <Property Name="FriendlyIdentifier" Type="String" Nullable="true" /></EntityType> + <EntityType Name="Role"> + <Key> + <PropertyRef Name="Id" /> + </Key> + <Property Name="Id" Type="Int32" Nullable="false" a:SetterAccess="Private" xmlns:a="http://schemas.microsoft.com/ado/2006/04/codegeneration" /> + <Property Name="Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" /> + <NavigationProperty Name="Users" Relationship="DatabaseModel.UserRole" FromRole="Role" ToRole="User" /> + </EntityType> + <EntityType Name="User"> + <Key> + <PropertyRef Name="Id" /> + </Key> + <Property Name="Id" Type="Int32" Nullable="false" a:SetterAccess="Private" xmlns:a="http://schemas.microsoft.com/ado/2006/04/codegeneration" /> + <Property Name="FirstName" Type="String" MaxLength="50" Unicode="true" FixedLength="false" /> + <Property Name="LastName" Type="String" MaxLength="50" Unicode="true" FixedLength="false" /> + <Property Name="EmailAddress" Type="String" MaxLength="100" Unicode="true" FixedLength="false" /> + <NavigationProperty Name="Roles" Relationship="DatabaseModel.UserRole" FromRole="User" ToRole="Role" /> + <NavigationProperty Name="AuthenticationTokens" Relationship="DatabaseModel.UserAuthenticationToken" FromRole="User" ToRole="AuthenticationToken" /></EntityType> + <Association Name="UserRole"> + <End Role="Role" Type="DatabaseModel.Role" Multiplicity="*" /> + <End Role="User" Type="DatabaseModel.User" Multiplicity="*" /> + </Association> + <Association Name="UserAuthenticationToken"> + <End Type="DatabaseModel.User" Role="User" Multiplicity="1" /> + <End Type="DatabaseModel.AuthenticationToken" Role="AuthenticationToken" Multiplicity="*" /></Association></Schema> + </edmx:ConceptualModels> + <!-- C-S mapping content --> + <edmx:Mappings> + <Mapping Space="C-S" xmlns="urn:schemas-microsoft-com:windows:storage:mapping:CS"> + <EntityContainerMapping StorageEntityContainer="DatabaseModelStoreContainer" CdmEntityContainer="DatabaseEntities"> + <EntitySetMapping Name="Role"> + <EntityTypeMapping TypeName="IsTypeOf(DatabaseModel.Role)"> + <MappingFragment StoreEntitySet="Role"> + <ScalarProperty Name="Id" ColumnName="Id" /> + <ScalarProperty Name="Name" ColumnName="Name" /> + </MappingFragment> + </EntityTypeMapping> + </EntitySetMapping> + <EntitySetMapping Name="User"> + <EntityTypeMapping TypeName="IsTypeOf(DatabaseModel.User)"> + <MappingFragment StoreEntitySet="User"> + <ScalarProperty Name="Id" ColumnName="Id" /> + <ScalarProperty Name="FirstName" ColumnName="FirstName" /> + <ScalarProperty Name="LastName" ColumnName="LastName" /> + <ScalarProperty Name="EmailAddress" ColumnName="EmailAddress" /> + </MappingFragment> + </EntityTypeMapping> + </EntitySetMapping> + <AssociationSetMapping Name="UserRole" TypeName="DatabaseModel.UserRole" StoreEntitySet="UserRole"> + <EndProperty Name="Role"> + <ScalarProperty Name="Id" ColumnName="RoleId" /> + </EndProperty> + <EndProperty Name="User"> + <ScalarProperty Name="Id" ColumnName="UserId" /> + </EndProperty> + </AssociationSetMapping> + <EntitySetMapping Name="AuthenticationToken"><EntityTypeMapping TypeName="IsTypeOf(DatabaseModel.AuthenticationToken)"> + <MappingFragment StoreEntitySet="AuthenticationToken"> + <ScalarProperty Name="FriendlyIdentifier" ColumnName="OpenIdFriendlyIdentifier" /> + <ScalarProperty Name="ClaimedIdentifier" ColumnName="OpenIdClaimedIdentifier" /> + <ScalarProperty Name="Id" ColumnName="Id" /> + </MappingFragment> + </EntityTypeMapping> + </EntitySetMapping> + <AssociationSetMapping Name="UserAuthenticationToken" TypeName="DatabaseModel.UserAuthenticationToken" StoreEntitySet="AuthenticationToken"> + <EndProperty Name="AuthenticationToken"> + <ScalarProperty Name="Id" ColumnName="Id" /></EndProperty> + <EndProperty Name="User"> + <ScalarProperty Name="Id" ColumnName="UserId" /></EndProperty></AssociationSetMapping> + </EntityContainerMapping> + </Mapping> + </edmx:Mappings> + </edmx:Runtime> + <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) --> + <edmx:Designer xmlns="http://schemas.microsoft.com/ado/2007/06/edmx"> + <edmx:Connection> + <DesignerInfoPropertySet> + <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" /> + </DesignerInfoPropertySet> + </edmx:Connection> + <edmx:Options> + <DesignerInfoPropertySet> + <DesignerProperty Name="ValidateOnBuild" Value="true" /> + </DesignerInfoPropertySet> + </edmx:Options> + <!-- Diagram content (shape and connector positions) --> + <edmx:Diagrams> + <Diagram Name="Model"> + <EntityTypeShape EntityType="DatabaseModel.AuthenticationToken" Width="1.875" PointX="5.25" PointY="1.125" Height="1.4033821614583335" IsExpanded="true" /> + <EntityTypeShape EntityType="DatabaseModel.Role" Width="1.5" PointX="0.75" PointY="1.25" Height="1.5956835937500002" IsExpanded="true" /> + <EntityTypeShape EntityType="DatabaseModel.User" Width="1.75" PointX="2.875" PointY="0.875" Height="2.364889322916667" IsExpanded="true" /> + <AssociationConnector Association="DatabaseModel.UserRole" ManuallyRouted="false"> + <ConnectorPoint PointX="2.25" PointY="2.0478417968750002" /> + <ConnectorPoint PointX="2.875" PointY="2.0478417968750002" /></AssociationConnector> + <InheritanceConnector EntityType="DatabaseModel.AuthenticationToken"> + <ConnectorPoint PointX="6.5625" PointY="3.375" /> + <ConnectorPoint PointX="6.5625" PointY="2.9129850260416665" /></InheritanceConnector> + <AssociationConnector Association="DatabaseModel.UserAuthenticationToken"> + <ConnectorPoint PointX="4.625" PointY="1.8266910807291668" /> + <ConnectorPoint PointX="5.25" PointY="1.8266910807291668" /></AssociationConnector></Diagram></edmx:Diagrams> + </edmx:Designer> +</edmx:Edmx>
\ No newline at end of file |