-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathModelMusicGenesis.edmx
126 lines (126 loc) · 6.57 KB
/
ModelMusicGenesis.edmx
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx">
<!-- EF Runtime content -->
<edmx:Runtime>
<!-- SSDL content -->
<edmx:StorageModels>
<Schema Namespace="MusicPlayModel.Store" Alias="Self" Provider="System.Data.SqlClient" ProviderManifestToken="2008" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
<EntityContainer Name="MusicPlayModelStoreContainer">
<EntitySet Name="MusicAlbum" EntityType="MusicPlayModel.Store.MusicAlbum" store:Type="Tables" Schema="dbo" />
<EntitySet Name="MusicArtist" EntityType="MusicPlayModel.Store.MusicArtist" store:Type="Tables" Schema="dbo" />
<EntitySet Name="MusicBand" EntityType="MusicPlayModel.Store.MusicBand" store:Type="Tables" Schema="dbo" />
</EntityContainer>
<EntityType Name="MusicAlbum">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
<Property Name="AlbumName" Type="varchar" Nullable="false" MaxLength="50" />
<Property Name="IsDeleted" Type="bit" Nullable="false" />
</EntityType>
<EntityType Name="MusicArtist">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
<Property Name="ArtistName" Type="varchar" MaxLength="50" />
<Property Name="IsDeleted" Type="bit" Nullable="false" />
</EntityType>
<EntityType Name="MusicBand">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
<Property Name="BandName" Type="varchar" Nullable="false" MaxLength="50" />
<Property Name="IsDeleted" Type="bit" Nullable="false" />
</EntityType>
</Schema>
</edmx:StorageModels>
<!-- CSDL content -->
<edmx:ConceptualModels>
<Schema Namespace="MusicPlayModel" Alias="Self" p1:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns:p1="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
<EntityContainer Name="MusicPlayEntities2" p1:LazyLoadingEnabled="true">
<EntitySet Name="MusicAlbums" EntityType="MusicPlayModel.MusicAlbum" />
<EntitySet Name="MusicArtists" EntityType="MusicPlayModel.MusicArtist" />
<EntitySet Name="MusicBands" EntityType="MusicPlayModel.MusicBand" />
</EntityContainer>
<EntityType Name="MusicAlbum">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Type="Int32" Nullable="false" p1:StoreGeneratedPattern="Identity" />
<Property Name="AlbumName" Type="String" Nullable="false" MaxLength="50" Unicode="false" FixedLength="false" />
<Property Name="IsDeleted" Type="Boolean" Nullable="false" />
</EntityType>
<EntityType Name="MusicArtist">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Type="Int32" Nullable="false" p1:StoreGeneratedPattern="Identity" />
<Property Name="ArtistName" Type="String" MaxLength="50" Unicode="false" FixedLength="false" />
<Property Name="IsDeleted" Type="Boolean" Nullable="false" />
</EntityType>
<EntityType Name="MusicBand">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Type="Int32" Nullable="false" p1:StoreGeneratedPattern="Identity" />
<Property Name="BandName" Type="String" Nullable="false" MaxLength="50" Unicode="false" FixedLength="false" />
<Property Name="IsDeleted" Type="Boolean" Nullable="false" />
</EntityType>
</Schema>
</edmx:ConceptualModels>
<!-- C-S mapping content -->
<edmx:Mappings>
<Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
<EntityContainerMapping StorageEntityContainer="MusicPlayModelStoreContainer" CdmEntityContainer="MusicPlayEntities2">
<EntitySetMapping Name="MusicAlbums">
<EntityTypeMapping TypeName="MusicPlayModel.MusicAlbum">
<MappingFragment StoreEntitySet="MusicAlbum">
<ScalarProperty Name="Id" ColumnName="Id" />
<ScalarProperty Name="AlbumName" ColumnName="AlbumName" />
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
</MappingFragment>
</EntityTypeMapping>
</EntitySetMapping>
<EntitySetMapping Name="MusicArtists">
<EntityTypeMapping TypeName="MusicPlayModel.MusicArtist">
<MappingFragment StoreEntitySet="MusicArtist">
<ScalarProperty Name="Id" ColumnName="Id" />
<ScalarProperty Name="ArtistName" ColumnName="ArtistName" />
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
</MappingFragment>
</EntityTypeMapping>
</EntitySetMapping>
<EntitySetMapping Name="MusicBands">
<EntityTypeMapping TypeName="MusicPlayModel.MusicBand">
<MappingFragment StoreEntitySet="MusicBand">
<ScalarProperty Name="Id" ColumnName="Id" />
<ScalarProperty Name="BandName" ColumnName="BandName" />
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
</MappingFragment>
</EntityTypeMapping>
</EntitySetMapping>
</EntityContainerMapping>
</Mapping>
</edmx:Mappings>
</edmx:Runtime>
<!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
<Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
<Connection>
<DesignerInfoPropertySet>
<DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
</DesignerInfoPropertySet>
</Connection>
<Options>
<DesignerInfoPropertySet>
<DesignerProperty Name="ValidateOnBuild" Value="true" />
<DesignerProperty Name="EnablePluralization" Value="True" />
<DesignerProperty Name="IncludeForeignKeysInModel" Value="True" />
<DesignerProperty Name="CodeGenerationStrategy" Value="None" />
</DesignerInfoPropertySet>
</Options>
<!-- Diagram content (shape and connector positions) -->
<Diagrams></Diagrams>
</Designer>
</edmx:Edmx>