مشخصات کتاب

نویسنده:

Tom Dykstra
تاریخ انتشار:

2014
زبان:

انگلیسی
تعداد بازدید:

29223
تعداد دانلود:

1299
لایک ها :

0

Getting Started with Entity Framework 6 Code First using MVC 5

نویسنده :Tom Dykstra

Creating an Entity Framework Data Model ................................................................................................. 9

Introduction .............................................................................................................................................. 9

Software versions used in the tutorial ................................................................................................... 9

Tutorial versions ..................................................................................................................................... 9

Questions and comments ........................................................................................................................ 9

The Contoso University Web Application .......................................................................................... 10

Prerequisites .......................................................................................................................................... 11

Create an MVC Web Application ....................................................................................................... 12

Set Up the Site Style .............................................................................................................................. 13

Install Entity Framework 6 .................................................................................................................. 17

Create the Data Model .......................................................................................................................... 17

The Student Entity ............................................................................................................................ 18

The Enrollment Entity ...................................................................................................................... 19

The Course Entity ............................................................................................................................. 20

Create the Database Context ............................................................................................................... 21

Specifying entity sets ......................................................................................................................... 22

Specifying the connection string ...................................................................................................... 22

Specifying singular table names....................................................................................................... 22

Set up EF to initialize the database with test data ............................................................................. 23

Set up EF to use a SQL Server Express LocalDB database .............................................................. 26

Creating a Student Controller and Views ........................................................................................... 26

View the Database ................................................................................................................................. 31

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

Summary ................................................................................................................................................ 33

Implementing Basic CRUD Functionality with the Entity Framework in ASP.NET MVC Application ...... 34

Create a Details Page ............................................................................................................................ 37

Route data .......................................................................................................................................... 38

Update the Create Page ........................................................................................................................ 41

Update the Edit HttpPost Page ............................................................................................................ 46

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

Updating the Delete Page ..................................................................................................................... 50

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

Handling Transactions ......................................................................................................................... 54

Summary ................................................................................................................................................ 54

Sorting, Filtering, and Paging with the Entity Framework in an ASP.NET MVC Application ................... 55

Add Column Sort Links to the Students Index Page ......................................................................... 56

Add Sorting Functionality to the Index Method ............................................................................ 56

Add Column Heading Hyperlinks to the Student Index View ...................................................... 58

Add a Search Box to the Students Index Page ................................................................................... 60

Add Filtering Functionality to the Index Method .......................................................................... 60

Add a Search Box to the Student Index View................................................................................. 62

Add Paging to the Students Index Page .............................................................................................. 63

Install the PagedList.MVC NuGet Package ................................................................................... 64

Add Paging Functionality to the Index Method ............................................................................. 65

Add Paging Links to the Student Index View ................................................................................ 67

Create an About Page That Shows Student Statistics ....................................................................... 71

Create the View Model ..................................................................................................................... 71

Modify the Home Controller ............................................................................................................ 72

Modify the About View..................................................................................................................... 73

Summary ................................................................................................................................................ 74

Connection Resiliency and Command Interception with the Entity Framework in an ASP.NET MVC Application.................................................................................................................................................. 75

Enable connection resiliency ................................................................................................................ 75

Enable Command Interception............................................................................................................ 77

Create a logging interface and class ................................................................................................ 77

Create interceptor classes ................................................................................................................. 80

Test logging and connection resiliency ................................................................................................ 86

Summary ................................................................................................................................................ 91

Code First Migrations and Deployment with the Entity Framework in an ASP.NET MVC Application ... 92

Enable Code First Migrations .............................................................................................................. 92

Set up the Seed Method .................................................................................................................... 96

Execute the First Migration ........................................................................................................... 101

Deploy to Windows Azure .................................................................................................................. 103

Using Code First Migrations to Deploy the Database .................................................................. 103

Get a Windows Azure account ....................................................................................................... 103

Create a web site and a SQL database in Windows Azure ......................................................... 103

Deploy the application to Windows Azure.................................................................................... 107

Advanced Migrations Scenarios ........................................................................................................ 122

Code First Initializers ......................................................................................................................... 122

Summary .............................................................................................................................................. 123

Creating a More Complex Data Model for an ASP.NET MVC Application .............................................. 124

Customize the Data Model by Using Attributes ............................................................................... 125

The DataType Attribute ................................................................................................................. 126

The StringLengthAttribute ............................................................................................................ 128

The Column Attribute .................................................................................................................... 130

Complete Changes to the Student Entity .......................................................................................... 132

The Required Attribute .................................................................................................................. 133

The Display Attribute ..................................................................................................................... 134

The FullName Calculated Property .............................................................................................. 134

Create the Instructor Entity .............................................................................................................. 134

The Courses and OfficeAssignment Navigation Properties ........................................................ 135

Create the OfficeAssignment Entity .................................................................................................. 136

The Key Attribute ........................................................................................................................... 137

The ForeignKey Attribute .............................................................................................................. 137

The Instructor Navigation Property ............................................................................................. 137

Modify the Course Entity ................................................................................................................... 138

The DatabaseGenerated Attribute ................................................................................................ 139

Foreign Key and Navigation Properties ........................................................................................ 139

Create the Department Entity ........................................................................................................... 139

The Column Attribute .................................................................................................................... 140

Foreign Key and Navigation Properties ........................................................................................ 141

Modify the Enrollment Entity ............................................................................................................ 141

Foreign Key and Navigation Properties ........................................................................................ 142

Many-to-Many Relationships ......................................................................................................... 142

Entity Diagram Showing Relationships ............................................................................................ 145

Customize the Data Model by adding Code to the Database Context............................................ 147

Seed the Database with Test Data ..................................................................................................... 148

Add a Migration and Update the Database ...................................................................................... 154

Summary .............................................................................................................................................. 157

Reading Related Data with the Entity Framework in an ASP.NET MVC Application ............................. 158

Lazy, Eager, and Explicit Loading of Related Data ........................................................................ 160

Performance considerations ........................................................................................................... 161

Disable lazy loading before serialization ....................................................................................... 161

Create a Courses Page That Displays Department Name ............................................................... 162

Create an Instructors Page That Shows Courses and Enrollments ............................................... 165

Create a View Model for the Instructor Index View ................................................................... 168

Create the Instructor Controller and Views ................................................................................. 168

Modify the Instructor Index View ................................................................................................. 171

Adding Explicit Loading ................................................................................................................ 178

Summary .............................................................................................................................................. 179

Updating Related Data with the Entity Framework in an ASP.NET MVC Application ........................... 180

Customize the Create and Edit Pages for Courses .......................................................................... 183

Adding an Edit Page for Instructors ................................................................................................. 191

Adding Course Assignments to the Instructor Edit Page ................................................................ 195

Update the DeleteConfirmed Method ............................................................................................... 205

Add office location and courses to the Create page ......................................................................... 205

Handling Transactions ....................................................................................................................... 209

Summary .............................................................................................................................................. 209

Async and Stored Procedures with the Entity Framework in an ASP.NET MVC Application ................ 210

Why bother with asynchronous code ................................................................................................ 212

Create the Department controller ..................................................................................................... 213

Use stored procedures for inserting, updating, and deleting .......................................................... 217

Deploy to Windows Azure .................................................................................................................. 221

Summary .............................................................................................................................................. 222

Handling Concurrency with the Entity Framework 6 in an ASP.NET MVC 5 Application (10 of 12) ...... 223

Concurrency Conflicts ........................................................................................................................ 224

Pessimistic Concurrency (Locking) ............................................................................................... 225

Optimistic Concurrency ................................................................................................................. 225

Detecting Concurrency Conflicts ................................................................................................... 228

Add an Optimistic Concurrency Property to the Department Entity........................................... 229

Modify the Department Controller ................................................................................................... 230

Testing Optimistic Concurrency Handling ....................................................................................... 233

Updating the Delete Page ................................................................................................................... 240

Summary .............................................................................................................................................. 248

Implementing Inheritance with the Entity Framework 6 in an ASP.NET MVC 5 Application (11 of 12)249

Options for mapping inheritance to database tables ....................................................................... 249

Create the Person class ....................................................................................................................... 251

Make Student and Instructor classes inherit from Person .............................................................. 252

Add the Person Entity Type to the Model ........................................................................................ 253

Create and Update a Migrations File ................................................................................................ 253

Testing .................................................................................................................................................. 255

Deploy to Windows Azure .................................................................................................................. 258

Summary .............................................................................................................................................. 260

Advanced Entity Framework 6 Scenarios for an MVC 5 Web Application (12 of 12) ............................ 261

Performing Raw SQL Queries ........................................................................................................... 263

Calling a Query that Returns Entities ........................................................................................... 264

Calling a Query that Returns Other Types of Objects ................................................................ 265

Calling an Update Query ................................................................................................................ 267

No-Tracking Queries .......................................................................................................................... 273

Examining SQL sent to the database ................................................................................................ 278

Repository and unit of work patterns ............................................................................................... 283

Proxy classes ........................................................................................................................................ 284

Automatic change detection ............................................................................................................... 286

Automatic validation .......................................................................................................................... 286

Entity Framework Power Tools......................................................................................................... 286

Entity Framework source code .......................................................................................................... 289

Summary .............................................................................................................................................. 289

Acknowledgments ............................................................................................................................... 289

VB ......................................................................................................................................................... 289

Common errors, and solutions or workarounds for them .................................................................. 289

Cannot create/shadow copy............................................................................................................ 290

Update-Database not recognized ................................................................................................... 290

1394/07/27 29223 1299

رمز عبور : tahlildadeh.com یا www.tahlildadeh.com

سوالات و نظرات