[转]Creating an Entity Framework Data Model for an ASP.NET MVC Application (1 of 10)

本文转自:http://www.asp.net/mvc/overview/older-versions/getting-started-with-ef-5-using-mvc-4/creating-an-entity-framework-data-model-for-an-asp-net-mvc-application

Creating an Entity Framework Data Model for an ASP.NET MVC Application (1 of 10)
  By          Tom DykstraTom Dykstra|July 30, 2013

Download Completed Project

A newer version of this tutorial series is available, for Visual Studio 2013, Entity Framework 6, and MVC 5.

The Contoso University sample web application demonstrates how to create ASP.NET MVC  4 applications using the Entity Framework 5 and Visual Studio 2012. The sample application is a web site for a fictional Contoso University. It includes functionality such as student admission, course creation, and instructor assignments. This tutorial series explains  how to build the Contoso University sample application.  You can download the completed application.

Code First

There are three ways you can work with data in the Entity Framework: Database First, Model First, and Code First.  This tutorial is for Code First. For information about the differences between  these workflows and guidance on how to choose the best one for your scenario,  see Entity Framework Development Workflows.

MVC

The sample application is built on ASP.NET MVC. If you prefer to work with the ASP.NET Web Forms model,  see the  Model Binding and Web Forms tutorial series and ASP.NET  Data Access Content Map.

Software versions

Shown in the tutorial Also works with
Windows 8 Windows 7
Visual Studio 2012 Visual Studio 2012 Express for Web. This is automatically installed by the Windows Azure SDK if you don't already have VS 2012 or VS 2012 Express for Web.
Visual Studio 2013 should work, but the tutorial has not been tested with it, and some menu selections and dialog boxes are different. The VS 2013 version of the Windows Azure SDK is required for Windows Azure deployment.
.NET 4.5 Most of the features shown will work in .NET 4, but some won't. For example,  enum support in EF requires .NET 4.5.
Entity Framework 5  
Windows Azure SDK 2.1 If you skip the Windows Azure deployment steps, you don't need the SDK.
When a new version of the SDK is released, the link will install the newer version. In that case, you might have to adapt some of the instructions to new UI and features.

Questions

If you have questions that are not directly related to the tutorial, you can post them to the ASP.NET Entity Framework forum, the Entity Framework and LINQ to Entities forum,  or *.com.

Acknowledgments

See the last tutorial in the series for  acknowledgments and a note about VB.

Original version of the tutorial

The original version of the tutorial is available in the the EF 4.1 / MVC 3 e-book.

The Contoso University Web Application

The application you'll be building in these tutorials is a simple university web site.

Users can view and update student, course, and instructor information. Here  are a few of the screens you'll create.

[转]Creating an Entity Framework Data Model for an ASP.NET MVC Application (1 of 10) 

[转]Creating an Entity Framework Data Model for an ASP.NET MVC Application (1 of 10)

The UI style of this site has been kept close to what's generated by the built-in templates, so that the tutorial can focus mainly on how to use the Entity Framework.

Prerequisites

The directions and screen shots in this tutorial assume that you're using Visual Studio 2012 or Visual Studio  2012 Express for Web, with the latest update and Windows Azure SDK installed as  of July, 2013.  You can get  all of this with the following link:

Windows Azure SDK for Visual Studio 2012

If you have Visual Studio installed, the link above will install any missing  components. If you don't have Visual Studio, the link will install Visual Studio  2012 Express for Web. You can use Visual Studio 2013, but some of the required  procedures and screens will differ.

Create an MVC Web Application

Open Visual Studio and create a new C# project named "ContosoUniversity" using the ASP.NET MVC  4 Web Application template. Make sure you target .NET Framework  4.5 (you'll be using enum properties, and that requires .NET 4.5).

[转]Creating an Entity Framework Data Model for an ASP.NET MVC Application (1 of 10)

In the New ASP.NET MVC 4 Project dialog box select the Internet Application template.

Leave the Razor view engine selected, and leave the Create a unit test project check box  cleared.

Click OK.

[转]Creating an Entity Framework Data Model for an ASP.NET MVC Application (1 of 10)

Set Up the Site Style

A few simple changes will set up the site menu, layout, and home page.

Open ViewsShared\_Layout.cshtml, and replace the contents of the  file with  the following code. The changes are highlighted.

<!DOCTYPE html>
<html lang="en">
    <head>
        <meta charset="utf-8" />
        <title>@ViewBag.Title - Contoso University</title>
        <link href="~/favicon.ico" rel="shortcut icon" type="image/x-icon" />
        <meta name="viewport" content="width=device-width" />
        @Styles.Render("~/Content/css")
        @Scripts.Render("~/bundles/modernizr")
    </head>
    <body>
        <header>
            <div class="content-wrapper">
                <div class="float-left">
                    <p class="site-title">@Html.ActionLink("Contoso University", "Index", "Home")</p>
                </div>
                <div class="float-right">
                    <section id="login">
                        @Html.Partial("_LoginPartial")
                    </section>
                    <nav>
                        <ul id="menu">
                            <li>@Html.ActionLink("Home", "Index", "Home")</li>
                            <li>@Html.ActionLink("About", "About", "Home")</li>
                            <li>@Html.ActionLink("Students", "Index", "Student")</li>
                            <li>@Html.ActionLink("Courses", "Index", "Course")</li>
                            <li>@Html.ActionLink("Instructors", "Index", "Instructor")</li>
                            <li>@Html.ActionLink("Departments", "Index", "Department")</li>
                        </ul>
                    </nav>
                </div>
            </div>
        </header>
        <div id="body">
            @RenderSection("featured", required: false)
            <section class="content-wrapper main-content clear-fix">
                @RenderBody()
            </section>
        </div>
        <footer>
            <div class="content-wrapper">
                <div class="float-left">
                    <p>&copy; @DateTime.Now.Year - Contoso University</p>
                </div>
            </div>
        </footer>

        @Scripts.Render("~/bundles/jquery")
        @RenderSection("scripts", required: false)
    </body>
</html>

This code makes the following changes:

  • Replaces the template  instances of "My ASP.NET MVC Application" and "your logo here" with "Contoso  University".
  • Adds several action links that will be used later in the tutorial.

In ViewsHomeIndex.cshtml, replace the contents of the file with the  following code to eliminate the template paragraphs about ASP.NET and MVC:

@{
    ViewBag.Title = "Home Page";
}
@section featured {
    <section class="featured">
        <div class="content-wrapper">
            <hgroup class="title">
                <h1>@ViewBag.Title.</h1>
                <h2>@ViewBag.Message</h2>
            </hgroup>
        </div>
    </section>
}

In ControllersHomeController.cs, change the value for ViewBag.Message in the Index Action method to "Welcome to Contoso University!",  as shown in the following example:

public ActionResult Index()
{
    ViewBag.Message = "Welcome to Contoso University";

    return View();
}

Press CTRL+F5 to run the site. You see the home page with the main menu.

[转]Creating an Entity Framework Data Model for an ASP.NET MVC Application (1 of 10)

Create the Data Model

Next you'll create entity classes for the Contoso University application.  You'll start with the following three entities:

[转]Creating an Entity Framework Data Model for an ASP.NET MVC Application (1 of 10)

There's a one-to-many relationship between Student and Enrollment entities, and there's a one-to-many relationship between Course and Enrollment entities. In other words, a student can be enrolled in any number of courses, and a course can have any number of students enrolled in it.

In the following sections you'll create a class for each one of these entities.

Note If you try to compile the project before you finish creating all of these entity classes, you'll get compiler errors.

The Student Entity

[转]Creating an Entity Framework Data Model for an ASP.NET MVC Application (1 of 10)

In the Models folder, create Student.cs and replace the existing code with the following code:

using System;
using System.Collections.Generic;

namespace ContosoUniversity.Models
{
    public class Student
    {
        public int StudentID { get; set; }
        public string LastName { get; set; }
        public string FirstMidName { get; set; }
        public DateTime EnrollmentDate { get; set; }
        
        public virtual ICollection<Enrollment> Enrollments { get; set; }
    }
}

The StudentID property will become the primary key column of the database table that corresponds to this class. By default, the Entity Framework interprets a property that's named ID or classnameID as the primary key.

The Enrollments property is a navigation property. Navigation properties hold other entities that are related to this entity. In this case, the Enrollments property of a Student entity will hold all of the Enrollment entities that are related to that Student entity. In other words, if a given Student row in the database has two related Enrollment rows (rows that contain that student's primary key value in their StudentID foreign key column), that Student entity's Enrollments navigation property will contain those two Enrollment entities.

Navigation properties are typically defined as virtual so that they can take advantage of  certain Entity Framework functionality such as lazy loading. (Lazy loading will be explained later, in the  Reading Related Data tutorial later in this series.

If a navigation property can hold multiple entities (as in many-to-many or one-to-many relationships),  its type must be a list in which entries can be added, deleted, and  updated, such as ICollection.

The Enrollment Entity

[转]Creating an Entity Framework Data Model for an ASP.NET MVC Application (1 of 10)

In the Models folder, create Enrollment.cs and replace the existing code with the following code:

namespace ContosoUniversity.Models
{
    public enum Grade
    {
        A, B, C, D, F
    }

    public class Enrollment
    {
        public int EnrollmentID { get; set; }
        public int CourseID { get; set; }
        public int StudentID { get; set; }
        public Grade? Grade { get; set; }
        
        public virtual Course Course { get; set; }
        public virtual Student Student { get; set; }
    }
}

The Grade property is an enum. The question mark after the Grade type declaration indicates that the Grade property is  nullable. A grade that's null is different from a zero grade — null means a grade  isn't known or hasn't been assigned yet.

The StudentID property is a foreign key, and the corresponding navigation property is Student. An Enrollment entity is associated with one Student entity, so the property can only hold a single Student entity (unlike the Student.Enrollments navigation property you saw earlier, which can hold multiple Enrollment entities).

The CourseID property is a foreign key, and the corresponding navigation property is Course. An Enrollment entity is associated with one Course entity.

The Course Entity

[转]Creating an Entity Framework Data Model for an ASP.NET MVC Application (1 of 10)

In the Models folder, create Course.cs, replacing the existing code with the following code:

using System.Collections.Generic;
using System.ComponentModel.DataAnnotations.Schema;

namespace ContosoUniversity.Models
{
    public class Course
    {
        [DatabaseGenerated(DatabaseGeneratedOption.None)]
        public int CourseID { get; set; }
        public string Title { get; set; }
        public int Credits { get; set; }
        
        public virtual ICollection<Enrollment> Enrollments { get; set; }
    }
}

The Enrollments property is a navigation property. A Course entity can be related to any number of Enrollment entities. 

We'll say more about the [DatabaseGenerated(DatabaseGeneratedOption.None)] attribute in the next tutorial. Basically, this attribute lets you enter  the primary key for the course rather than having the database generate it.

Create the Database Context

The main class that coordinates Entity Framework functionality for a given data model is the database context class. You create this class by deriving from the  System.Data.Entity.DbContext class. In your code you specify which entities are included in the data model. You can also customize certain Entity Framework behavior. In this project, the class is named SchoolContext.

Create a folder named DAL (for Data Access Layer). In that folder create a new class file named SchoolContext.cs, and replace the existing code with the following code:

using ContosoUniversity.Models;
using System.Data.Entity;
using System.Data.Entity.ModelConfiguration.Conventions;

namespace ContosoUniversity.DAL
{
    public class SchoolContext : DbContext
    {
        public DbSet<Student> Students { get; set; }
        public DbSet<Enrollment> Enrollments { get; set; }
        public DbSet<Course> Courses { get; set; }

        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();
        }
    }
}

This code creates a  DbSet property for each entity set. In Entity Framework terminology, an entity set typically corresponds to a database table, and an entity corresponds to a row in the table.

The modelBuilder.Conventions.Remove statement in the  OnModelCreating method prevents table names from being pluralized. If you didn't do this, the generated tables would be named Students, Courses, and Enrollments. Instead, the table names will be Student, Course, and Enrollment. Developers disagree about whether table names should be pluralized or not. This tutorial uses the singular form, but the important point is that you can select whichever form you prefer by including or omitting this line of code.

SQL Server Express LocalDB

LocalDB is a lightweight version of the SQL Server Express Database Engine  that starts on demand and runs in user mode. LocalDB runs in a special execution mode of SQL Server Express that enables you to  work with databases as .mdf files. Typically, LocalDB database files  are kept in the App_Data folder of a web project. The user instance feature in SQL Server Express also  enables you to work with .mdf files, but the user instance feature is  deprecated; therefore, LocalDB is recommended for working with .mdf files.

Typically SQL Server Express is not used for production web applications.  LocalDB in particular is not recommended for production use with a web  application because it is not designed to work with IIS.

In Visual Studio 2012 and later versions, LocalDB is installed by default with Visual Studio. In  Visual Studio 2010 and earlier versions, SQL Server Express (without LocalDB) is  installed by default with Visual Studio; you have to install it  manually if you're using Visual Studio 2010.

In this tutorial you'll work with LocalDB so that the database can be  stored in the App_Data folder as an .mdf file. Open the  root Web.config file and add a new connection string to the connectionStrings collection, as shown in the following example. (Make sure you update the  Web.config file in the root project folder. There's also a Web.config file is in the  Views subfolder that you don't need to update.)

 <add name="SchoolContext" connectionString="Data Source=(LocalDb)v11.0;Initial Catalog=ContosoUniversity;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|ContosoUniversity.mdf" providerName="System.Data.SqlClient" />

By default, the Entity Framework looks for a connection string named the same  as the DbContext class (SchoolContext for this project). The connection string you've added specifies a  LocalDB database named ContosoUniversity.mdf located in the  App_Data folder. For more  information, see  SQL Server Connection Strings for ASP.NET Web Applications.

You don't actually need to specify the connection string. If you don't supply  a connection string, Entity Framework will create one for you; however, the  database might not be in the App_data folder of your app. For information  on where the database will be created, see Code First to a New  Database.

The connectionStrings collection also has a connection string named DefaultConnection which is used for the membership database. You won't be using the membership  database in this tutorial. The only difference between the two connection  strings is the database name and the name attribute value.

Set up and Execute a Code First Migration

When you first start to develop an application, your data model changes  frequently, and  each time the model changes it gets out of sync with the database. You  can configure the Entity Framework to automatically drop and re-create the database each time  you change the data model. This is not a problem early in development because test  data is easily re-created, but after you have deployed to production you usually want to update the  database schema without dropping the database. The Migrations feature enables  Code First to update the database without dropping and re-creating it. Early in  the development cycle of a new project you might want to use DropCreateDatabaseIfModelChanges to drop, recreate and re-seed the database  each time the model changes.  One you get ready to deploy your application,  you can convert to the migrations approach. For this tutorial you'll only use migrations. For more information, see Code First Migrations and Migrations Screencast Series.

Enable Code First Migrations

  1. From the Tools menu, click Library Package Manager and then Package Manager Console.

    [转]Creating an Entity Framework Data Model for an ASP.NET MVC Application (1 of 10)

  2. At the PM> prompt enter the following command:

    enable-migrations -contexttypename SchoolContext

    [转]Creating an Entity Framework Data Model for an ASP.NET MVC Application (1 of 10)

    This command creates a Migrations folder in the  ContosoUniversity project, and it puts in that folder a Configuration.cs file that you can edit to configure Migrations.

    [转]Creating an Entity Framework Data Model for an ASP.NET MVC Application (1 of 10)

    The Configuration class includes a Seed method that is called  when the database is created and every time it is updated after a data model  change.

    internal sealed class Configuration : DbMigrationsConfiguration<ContosoUniversity.Models.SchoolContext>
    {
        public Configuration()
        {
            AutomaticMigrationsEnabled = false;
        }
    
        protected override void Seed(ContosoUniversity.Models.SchoolContext context)
        {
            //  This method will be called after migrating to the latest version.
    
            //  You can use the DbSet<T>.AddOrUpdate() helper extension method 
            //  to avoid creating duplicate seed data. E.g.
            //
            //    context.People.AddOrUpdate(
            //      p => p.FullName,
            //      new Person { FullName = "Andrew Peters" },
            //      new Person { FullName = "Brice Lambson" },
            //      new Person { FullName = "Rowan Miller" }
            //    );
            //
        }
    }

     The purpose of this Seed method is to enable you to insert test data  into the database after Code First creates it or updates it.

Set up the Seed Method

The Seed method runs when Code First Migrations creates the database and every  time it updates the database to the latest migration. The purpose of the Seed  method is to enable you to insert data into your tables before the application  accesses the database for the first time.

In earlier versions of Code First, before Migrations was released, it was  common for Seed methods to insert test data, because with every model change  during development the database had to be completely deleted and re-created from  scratch. With Code First Migrations, test data is retained after database  changes, so including test data in the  Seed method is typically not necessary. In fact, you don't want the Seed method to insert test data if you'll be  using Migrations to deploy the database to production, because the Seed method  will run in production. In that case you want the Seed method to insert into the database only the data that you  want to be inserted in production. For example, you might want the database to  include actual department names in the Department table when the  application becomes available in production.

For this tutorial, you'll be using Migrations for deployment, but your Seed method will insert test data anyway in order to make it easier to see how  application functionality works without having to manually insert a lot of data.

  1. Replace the contents of the Configuration.cs file with the following code, which will load test data into the new database. 
    namespace ContosoUniversity.Migrations
    {
       using System;
       using System.Collections.Generic;
       using System.Data.Entity.Migrations;
       using System.Linq;
       using ContosoUniversity.Models;
    
       internal sealed class Configuration : DbMigrationsConfiguration<ContosoUniversity.DAL.SchoolContext>
       {
          public Configuration()
          {
             AutomaticMigrationsEnabled = false;
          }
    
          protected override void Seed(ContosoUniversity.DAL.SchoolContext context)
          {
             var students = new List<Student>
                {
                    new Student { FirstMidName = "Carson",   LastName = "Alexander", 
                        EnrollmentDate = DateTime.Parse("2010-09-01") },
                    new Student { FirstMidName = "Meredith", LastName = "Alonso",    
                        EnrollmentDate = DateTime.Parse("2012-09-01") },
                    new Student { FirstMidName = "Arturo",   LastName = "Anand",     
                        EnrollmentDate = DateTime.Parse("2013-09-01") },
                    new Student { FirstMidName = "Gytis",    LastName = "Barzdukas", 
                        EnrollmentDate = DateTime.Parse("2012-09-01")