微软正版图书：GettingStartedwiththeEntityFramework4.1usingASP.NETMVC资源-CSDN文库

4星 · 超过85%的资源需积分: 10 93 浏览量 2013-10-19 16:23:48 上传评论收藏 10.81MB PDF 举报

微软正版图书：Getting Started with the Entity Framework 4.1 using ASP.NET MVC 微软正版图书：Getting Started with the Entity Framework 4.1 using ASP.NET MVC 微软正版图书：Getting Started with the Entity Framework 4.1 using ASP.NET MVC 根据给定文件信息，本篇文档主要涉及了Entity Framework 4.1和*** MVC4的知识点，我们将详细展开这些知识点。标题中的《*** MVC》表明了这是一本入门级书籍，旨在帮助读者学习如何在使用*** MVC框架开发的Web应用中通过Entity Framework 4.1来展示和编辑数据。本书是由微软官方发布，详细介绍了Entity Framework 4.1的基础知识，并侧重于*** MVC的应用场景。文档中提到了Entity Framework的三种主要开发方法： 1. Database First（数据库优先）：在这种方法中，开发人员从一个现有数据库开始设计，Entity Framework工具将帮助生成实体数据模型和上下文类，使得开发人员可以集中于逻辑层的代码编写。 2. Model First（模型优先）：Model First方法允许开发人员从设计一个数据模型开始，可以使用设计器来创建实体及其关系。然后工具生成数据库和数据库上下文类。 3. Code First（代码优先）：Code First方法侧重于从代码创建模型，使用实体类来表示数据模型和数据库上下文。这是目前流行的开发方式，它允许开发者以更灵活的方式控制模型和数据库的创建过程。接下来，文档介绍了POCO（Plain Old CLR Objects）的概念，这是一种不依赖于特定框架的普通旧 CLR 对象。使用POCO类可以帮助开发者创建更易于测试和重用的代码。实体数据模型的创建是文档的重要部分。文档解释了如何创建一个*** MVC Web应用，包括设置站点样式，创建数据模型，比如学生（Student），注册（Enrollment），课程（Course）实体，以及相应的数据库上下文（DatabaseContext）。作者介绍了如何设置数据库连接字符串，以及如何使用Entity Framework来初始化数据库并填充测试数据。之后，文档讲解了如何创建控制器（Controller），例如学生控制器（StudentController），以及如何实现基本的CRUD（创建、读取、更新、删除）功能。文档还提供了一些约定（Conventions）和最佳实践，这些约定是Entity Framework为简化开发流程而内置的规则，比如约定的命名规则和约定的数据库模式生成。此外，文档详细讲解了如何创建具体的页面来展示数据详情（Details Page）、创建记录（Create Page）、编辑记录（Edit Page）、删除记录（Delete Page），以及实现分页和筛选功能。由于文档中提到了Entity States和Attach和SaveChanges方法，这意味着文档还涵盖了Entity Framework中实体状态的管理，以及如何有效地将更改持久化到数据库中。文档提到了如何确保数据库连接不会被意外地遗留在打开状态，这是数据库操作中的一个重要方面，以避免资源泄露和性能问题。这本图书是一个为开发者提供的实用教程，系统地讲述了在*** MVC环境下使用Entity Framework 4.1进行数据操作的关键知识点，从基础的数据模型构建、CRUD操作的实现，到更高级的功能如实体状态管理和数据库连接管理等。通过阅读并实践这些内容，开发者可以构建高效、响应迅速、数据驱动的Web应用。

资源推荐

资源详情

资源评论

Contents

Creating an Entity Framework Data Model for an ASP.NET MVC Application............................................................. 7

The Contoso University Web Application......................................................................................................................... 7

Entity Framework Development Approaches .............................................................................................................. 11

Database First ........................................................................................................................................................................... 12

Model First ................................................................................................................................................................................. 12

Code First ................................................................................................................................................................................... 13

POCO (Plain Old CLR Objects) ........................................................................................................................................... 13

Creating an MVC Web Application .................................................................................................................................. 13

Setting Up the Site Style....................................................................................................................................................... 15

Creating the Data Model ...................................................................................................................................................... 18

The Student Entity................................................................................................................................................................... 19

The Enrollment Entity ............................................................................................................................................................ 21

The Course Entity .................................................................................................................................................................... 22

Creating the Database Context ......................................................................................................................................... 23

Setting the Connection String............................................................................................................................................ 24

Initializing the Database with Test Data ......................................................................................................................... 24

Creating a Student Controller ............................................................................................................................................ 27

Conventions............................................................................................................................................................................... 33

Implementing Basic CRUD Functionality.................................................................................................................................. 35

Creating a Details Page ......................................................................................................................................................... 39

Creating a Create Page ......................................................................................................................................................... 43

Creating an Edit Page ............................................................................................................................................................ 47

Entity States and the Attach and SaveChanges Methods ....................................................................................... 48

Creating a Delete Page ......................................................................................................................................................... 51

Ensuring that Database Connections Are Not Left Open ....................................................................................... 56

Sorting, Filtering, and Paging ....................................................................................................................................................... 57

Adding Column Sort Links to the Students Index Page .......................................................................................... 58

Adding Sorting Functionality to the Index Method .................................................................................................. 58

Adding Column Heading Hyperlinks to the Student Index View ......................................................................... 60

Adding a Search Box to the Students Index Page ..................................................................................................... 62

Adding Filtering Functionality to the Index Method ................................................................................................. 62

Adding a Search Box to the Student Index View ........................................................................................................ 63

Adding Paging to the Students Index Page ................................................................................................................. 64

Installing the PagedList NuGet Package ........................................................................................................................ 65

Adding Paging Functionality to the Index Method ................................................................................................... 66

Adding Paging Links to the Student Index View ........................................................................................................ 69

Creating an About Page That Shows Student Statistics .......................................................................................... 73

Creating the View Model ..................................................................................................................................................... 74

Modifying the Home Controller ........................................................................................................................................ 74

Modifying the About View .................................................................................................................................................. 75

Creating a More Complex Data Model ..................................................................................................................................... 78

Using Attributes to Control Formatting, Validation, and Database Mapping ................................................ 79

The DisplayFormat Attribute............................................................................................................................................... 79

The MaxLength Attribute ..................................................................................................................................................... 81

The Column Attribute ............................................................................................................................................................ 83

Creating the Instructor Entity ............................................................................................................................................. 85

The Required and Display Attributes .............................................................................................................................. 86

The FullName Calculated Property ................................................................................................................................... 86

The Courses and OfficeAssignment Navigation Properties ................................................................................... 87

Creating the OfficeAssignment Entity ............................................................................................................................. 87

The Key Attribute .................................................................................................................................................................... 88

The Instructor Navigation Property ................................................................................................................................. 88

Modifying the Course Entity ............................................................................................................................................... 89

The DatabaseGenerated Attribute.................................................................................................................................... 90

Foreign Key and Navigation Properties ......................................................................................................................... 90

Creating the Department Entity ........................................................................................................................................ 91

The Column Attribute ............................................................................................................................................................ 92

Foreign Key and Navigation Properties ......................................................................................................................... 92

Modifying the Student Entity ............................................................................................................................................. 93

Modifying the Enrollment Entity ....................................................................................................................................... 94