<?xml version= "1.0" encoding= "Utf-8"?>
<EDMX:EDMX version= "2.0" xmlns:edmx= "HTTP://SCHEMAS.MICROSOFT.COM/ADO/2008/10/EDMX" >
<!--EF Runtime Content--
<edmx:Runtime>
<!--SSDL Content--
<edmx:StorageModels>
<schema namespace= "Leavewordboradmodel.store" alias= "Self" provider= "System.Data.SqlClient" Providermanifesttoken= "Xmlns:store=" http://schemas.microsoft.com/ado/2007/12/edm/ Entitystoreschemagenerator "xmlns=" http://schemas.microsoft.com/ado/2009/02/edm/ssdl ">
<entitycontainer name= "Leavewordboradmodelstorecontainer" >
<entityset name= "MSG" entitytype= "LEAVEWORDBORADMODEL.STORE.MSG" store:type= "Tables" schema= "dbo"/>
<entityset name= "Users" entitytype= "LeaveWordBoradModel.Store.Users" store:type= "Tables" schema= "dbo"/>
<associationset name= "Fk_msg_users" association= "LeaveWordBoradModel.Store.FK_Msg_Users" >
<end role= "Users" entityset= "users"/>
<end role= "msg" entityset= "msg"/>
</AssociationSet>
<associationset name= "fk_msg_users1" association= "LeaveWordBoradModel.Store.FK_Msg_Users1" >
<end role= "Users" entityset= "users"/>
<end role= "msg" entityset= "msg"/>
</AssociationSet>
</EntityContainer>
<entitytype name= "MSG" >
<Key>
<propertyref name= "MId"/>
</Key>
<property name= "mId" type= "int" nullable= "false" storegeneratedpattern= "Identity"/>
<property name= "Mfromuser" type= "int" nullable= "false"/>
<property name= "Mtouser" type= "int" nullable= "false"/>
<property name= "mmsg" type= "nvarchar" nullable= "false" Maxlength= "/>"
<property name= "Maddtime" type= "datetime" nullable= "false"/>
<property name= "Misdel" type= "bit" nullable= "false"/>
</EntityType>
<entitytype name= "Users" >
<Key>
<propertyref name= "UId"/>
</Key>
<property name= "uId" type= "int" nullable= "false" storegeneratedpattern= "Identity"/>
<property name= "uName" type= "nvarchar" nullable= "false" Maxlength= "/>"
<property name= "uloginname" type= "nvarchar" nullable= "false" Maxlength= "/>"
<property name= "Upwd" type= "char" nullable= "false" maxlength= "+"/>
<property name= "Uaddtime" type= "datetime" nullable= "false"/>
<property name= "Uisdel" type= "bit" nullable= "false"/>
</EntityType>
<association name= "Fk_msg_users" >
<end role= "Users" type= "LeaveWordBoradModel.Store.Users" multiplicity= "1"/>
<end role= "MSG" type= "LEAVEWORDBORADMODEL.STORE.MSG" multiplicity= "*"/>
<ReferentialConstraint>
<principal role= "Users" >
<propertyref name= "UId"/>
</Principal>
<dependent role= "MSG" >
<propertyref name= "Mfromuser"/>
</Dependent>
</ReferentialConstraint>
</Association>
<association name= "Fk_msg_users1" >
<end role= "Users" type= "LeaveWordBoradModel.Store.Users" multiplicity= "1"/>
<end role= "MSG" type= "LEAVEWORDBORADMODEL.STORE.MSG" multiplicity= "*"/>
<ReferentialConstraint>
<principal role= "Users" >
<propertyref name= "UId"/>
</Principal>
<dependent role= "MSG" >
<propertyref name= "Mtouser"/>
</Dependent>
</ReferentialConstraint>
</Association>
</Schema>
</edmx:StorageModels>
<!--CSDL Content--
<edmx:ConceptualModels>
<schema namespace= "Leavewordboradmodel" alias= "Self" xmlns:annotation= "http://schemas.microsoft.com/ado/2009/ 02/edm/annotation "xmlns=" http://schemas.microsoft.com/ado/2008/09/edm ">
<entitycontainer name= "Leavewordboradentities" annotation:lazyloadingenabled= "true" >
<entityset name= "Msgs" entitytype= "leavewordboradmodel.msg"/>
<entityset name= "Users" entitytype= "Leavewordboradmodel.user"/>
<associationset name= "Fk_msg_users" association= "Leavewordboradmodel.fk_msg_users" >
<end role= "Users" entityset= "users"/>
<end role= "MSG" entityset= "Msgs"/>
</AssociationSet>
<associationset name= "fk_msg_users1" association= "Leavewordboradmodel.fk_msg_users1" >
<end role= "Users" entityset= "users"/>
<end role= "MSG" entityset= "Msgs"/>
</AssociationSet>
</EntityContainer>
<entitytype name= "MSG" >
<Key>
<propertyref name= "MId"/>
</Key>
<property name= "MId" type= "Int32" nullable= "false" annotation:storegeneratedpattern= "Identity"/>
<property name= "Mfromuser" type= "Int32" nullable= "false"/>
<property name= "Mtouser" type= "Int32" nullable= "false"/>
<property name= "mmsg" type= "String" nullable= "false" Maxlength= "$" unicode= "true" Fixedlength= "false"/>
<property name= "Maddtime" type= "DateTime" nullable= "false" precision= "3"/>
<property name= "Misdel" type= "Boolean" nullable= "false"/>
<navigationproperty name= "User" relationship= "Leavewordboradmodel.fk_msg_users" fromrole= "MSG" ToRole= "Users"/ >
<navigationproperty name= "User1" relationship= "leavewordboradmodel.fk_msg_users1" fromrole= "MSG" ToRole= "Users" />
</EntityType>
<entitytype name= "User" >
<Key>
<propertyref name= "UId"/>
</Key>
<property name= "UId" type= "Int32" nullable= "false" annotation:storegeneratedpattern= "Identity"/>
<property name= "UName" type= "String" nullable= "false" Maxlength= "" "Unicode=" true "Fixedlength=" false "/>
<property name= "Uloginname" type= "String" nullable= "false" Maxlength= "" "Unicode=" true "Fixedlength=" false "/>
<property name= "upwd" type= "String" nullable= "false" maxlength= "+" unicode= "false" fixedlength= "true"/>
<property name= "Uaddtime" type= "DateTime" nullable= "false" precision= "3"/>
<property name= "Uisdel" type= "Boolean" nullable= "false"/>
<navigationproperty name= "Msgs" relationship= "Leavewordboradmodel.fk_msg_users" fromrole= "Users" ToRole= "MSG"/ >
<navigationproperty name= "MSGS1" relationship= "leavewordboradmodel.fk_msg_users1" fromrole= "Users" ToRole= "MSG" />
</EntityType>
<association name= "Fk_msg_users" >
<end role= "Users" type= "Leavewordboradmodel.user" multiplicity= "1"/>
<end role= "MSG" type= "leavewordboradmodel.msg" multiplicity= "*"/>
<ReferentialConstraint>
<principal role= "Users" >
<propertyref name= "UId"/>
</Principal>
<dependent role= "MSG" >
<propertyref name= "Mfromuser"/>
</Dependent>
</ReferentialConstraint>
</Association>
<association name= "Fk_msg_users1" >
<end role= "Users" type= "Leavewordboradmodel.user" multiplicity= "1"/>
<end role= "MSG" type= "leavewordboradmodel.msg" multiplicity= "*"/>
<ReferentialConstraint>
<principal role= "Users" >
<propertyref name= "UId"/>
</Principal>
<dependent role= "MSG" >
<propertyref name= "Mtouser"/>
</Dependent>
</ReferentialConstraint>
</Association>
</Schema>
</edmx:ConceptualModels>
<!--c-s mapping Content--
<edmx:Mappings>
<mapping space= "C-s" xmlns= "Http://schemas.microsoft.com/ado/2008/09/mapping/cs" >
<entitycontainermapping storageentitycontainer= "Leavewordboradmodelstorecontainer" CdmEntityContainer= " Leavewordboradentities ">
<entitysetmapping name= "Msgs" >
<entitytypemapping typename= "Leavewordboradmodel.msg" >
<mappingfragment storeentityset= "MSG" >
<scalarproperty name= "Mid" columnname= "mid"/>
<scalarproperty name= "Mfromuser" columnname= "Mfromuser"/>
<scalarproperty name= "Mtouser" columnname= "Mtouser"/>
<scalarproperty name= "mmsg" columnname= "mmsg"/>
<scalarproperty name= "Maddtime" columnname= "Maddtime"/>
<scalarproperty name= "Misdel" columnname= "Misdel"/>
</MappingFragment>
</EntityTypeMapping>
</EntitySetMapping>
<entitysetmapping name= "Users" >
<entitytypemapping typename= "Leavewordboradmodel.user" >
<mappingfragment storeentityset= "Users" >
<scalarproperty name= "UID" columnname= "UID"/>
<scalarproperty name= "UName" columnname= "UName"/>
<scalarproperty name= "Uloginname" columnname= "Uloginname"/>
<scalarproperty name= "upwd" columnname= "Upwd"/>
<scalarproperty name= "Uaddtime" columnname= "Uaddtime"/>
<scalarproperty name= "Uisdel" columnname= "Uisdel"/>
</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/2008/10/EDMX" >
<Connection>
<DesignerInfoPropertySet>
<designerproperty name= "metadataartifactprocessing" value= "embedinoutputassembly"/>
</DesignerInfoPropertySet>
</Connection>
<Options>
<DesignerInfoPropertySet>
<designerproperty name= "Validateonbuild" value= "true"/>
<designerproperty name= "enablepluralization" value= "False"/>
<designerproperty name= "Includeforeignkeysinmodel" value= "True"/>
<designerproperty name= "Codegenerationstrategy" value= "None"/>
</DesignerInfoPropertySet>
</Options>
<!--Diagram content (shape and connector positions)-
<Diagrams></Diagrams>
</Designer>
</edmx:Edmx>
Entity Framework edmx (mapping file)