Basic Handling and Types of Database Relationships in Entity Framework

Ws Hu

Rate me:

4.84/5 (24 votes)

25 Jul 2012CPOL18 min read

146.9K

139

This article tries to fit all levels of readers by covering both basic database concept and practical tips for handling Entity Framework.

DbRelationshipInDbContext.zip
- DbRelationshipInDbContext
  - 3rdPartyTools
    - EntityFramework.4.3.1
      - lib
        
        net40
        
        EntityFramework.dll
  - db.sql
  - DBRelationshipInDbContext.sln
  - DBRelationshipInDbContext.suo
  - DBRelationshipInDbContext.vsmdi
  - DbRelationshipInDbContextLib
    - App.Config
    - bin
      - Debug
        
        EntityFramework.dll
        
        RelationshipInEFDemoLib.dll
        
        RelationshipInEFDemoLib.dll.config
        
        RelationshipInEFDemoLib.pdb
    - DbRelationshipInDbContextLib.csproj
    - DbRelationshipLib.cs
    - EF
      - Class.cs
      - ClassRegModel.Context.cs
      - ClassRegModel.Context.tt
      - ClassRegModel.cs
      - ClassRegModel.tt
      - ClassRegModels.Designer.cs
      - ClassRegModels.edmx
      - Club.cs
      - Student.cs
      - StudentClubMatch.cs
      - Teacher.cs
    - obj
      - Debug
        
        DbRelationshipInDbContextLib.csproj.FileListAbsolute.txt
        
        DesignTimeResolveAssemblyReferencesInput.cache
        
        edmxResourcesToEmbed
        
        EF
        
        ClassRegModels.csdl
        
        ClassRegModels.msl
        
        ClassRegModels.ssdl
        
        RelationshipInEFDemoLib.dll
        
        RelationshipInEFDemoLib.pdb
        
        TempPE
    - Properties
      - AssemblyInfo.cs
  - DbRelationshipInDbContextLibTests
    - App.Config
    - bin
      - Debug
        
        EntityFramework.dll
        
        RelationshipInEFDemoLib.dll
        
        RelationshipInEFDemoLib.pdb
        
        RelationshipInEFDemoLibTests.dll
        
        RelationshipInEFDemoLibTests.dll.config
        
        RelationshipInEFDemoLibTests.pdb
    - DbRelationshipInDbContextTests.csproj
    - obj
      - Debug
        
        DbRelationshipInDbContextTests.csproj.FileListAbsolute.txt
        
        DesignTimeResolveAssemblyReferencesInput.cache
        
        RelationshipInEFDemoLibTests.dll
        
        RelationshipInEFDemoLibTests.pdb
        
        ResolveAssemblyReference.cache
        
        TempPE
    - Properties
      - AssemblyInfo.cs
    - RelationshipInEFDemoLibTests.cs
  - Local.testsettings
  - TestResults
    - Wilson_WILSON-PC 2012-06-04 21_40_48.trx
    - Wilson_WILSON-PC 2012-06-04 21_40_48
      - In
        
        WILSON-PC
      - Out
        
        AgentRestart.dat
    - Wilson_WILSON-PC 2012-06-04 21_46_09.trx
    - Wilson_WILSON-PC 2012-06-04 22_01_17.trx
  - TraceAndTestImpact.testsettings
DbRelationshipInDbContext-noexe.zip
- db.sql
- DBRelationshipInDbContext.sln
- DBRelationshipInDbContext.suo
- DBRelationshipInDbContext.vsmdi
- App.Config
- RelationshipInEFDemoLib.dll.config
- DbRelationshipInDbContextLib.csproj
- DbRelationshipLib.cs
- Class.cs
- ClassRegModel.Context.cs
- ClassRegModel.Context.tt
- ClassRegModel.cs
- ClassRegModel.tt
- ClassRegModels.Designer.cs
- ClassRegModels.edmx
- Club.cs
- Student.cs
- StudentClubMatch.cs
- Teacher.cs
- DbRelationshipInDbContextLib.csproj.FileListAbsolute.txt
- ClassRegModels.csdl
- ClassRegModels.msl
- ClassRegModels.ssdl
- AssemblyInfo.cs
- App.Config
- RelationshipInEFDemoLibTests.dll.config
- DbRelationshipInDbContextTests.csproj
- DbRelationshipInDbContextTests.csproj.FileListAbsolute.txt
- AssemblyInfo.cs
- RelationshipInEFDemoLibTests.cs
- Local.testsettings
- Wilson_WILSON-PC 2012-06-04 21_40_48.trx
- AgentRestart.dat
- Wilson_WILSON-PC 2012-06-04 21_46_09.trx
- Wilson_WILSON-PC 2012-06-04 22_01_17.trx
- TraceAndTestImpact.testsettings

<?xml version="1.0" encoding="utf-8"?>
<configuration>
	<connectionStrings>
		<add name="ClassRegDemoEntities" connectionString="metadata=res://*/EF.ClassRegModels.csdl|res://*/EF.ClassRegModels.ssdl|res://*/EF.ClassRegModels.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=WILSON-PC\SQLEXPRESS;Initial Catalog=ClassRegDemo;Integrated Security=True;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />
	</connectionStrings>
</configuration>

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Ws Hu

United States

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Basic Handling and Types of Database Relationships in Entity Framework

License

Comments and Discussions