ASP.NET MVC with Entity Framework and CSS

628 Pages·2016·29.92 MB·English

by  Lee Naylor (auth.)

ASP.NET MVC with
Entity Framework
and CSS
—
Lee Naylor
ASP.NET MVC
with Entity Framework
and CSS

Lee Naylor
ASP.NET MVC with Entity Framework and CSS
Lee Naylor
Newton-le-Willows, Merseyside
United Kingdom
ISBN-13 (pbk): 978-1-4842-2136-5 ISBN-13 (electronic): 978-1-4842-2137-2
DOI 10.1007/978-1-4842-2137-2
Library of Congress Control Number: 2016952810
Copyright © 2016 by Lee Naylor
This work is subject to copyright. All rights are reserved by the Publisher, whether the whole or part of the
material is concerned, specifically the rights of translation, reprinting, reuse of illustrations, recitation,
broadcasting, reproduction on microfilms or in any other physical way, and transmission or information storage
and retrieval, electronic adaptation, computer software, or by similar or dissimilar methodology now known or
hereafter developed.
Trademarked names, logos, and images may appear in this book. Rather than use a trademark symbol with
every occurrence of a trademarked name, logo, or image we use the names, logos, and images only in an
editorial fashion and to the benefit of the trademark owner, with no intention of infringement of the trademark.
The use in this publication of trade names, trademarks, service marks, and similar terms, even if they are
not identified as such, is not to be taken as an expression of opinion as to whether or not they are subject to
proprietary rights.
While the advice and information in this book are believed to be true and accurate at the date of publication,
neither the authors nor the editors nor the publisher can accept any legal responsibility for any errors or
omissions that may be made. The publisher makes no warranty, express or implied, with respect to the
material contained herein.
Managing Director: Welmoed Spahr
Lead Editor: Celestin Suresh John
Development Editor: Laura Berendson
Technical Reviewer: Fabio Ferracchiati
Editorial Board: Steve Anglin, Pramila Balan, Laura Berendson, Aaron Black, Louise Corrigan,
Jonathan Gennick, Robert Hutchinson, Celestin Suresh John, Nikhil Karkal, James Markham,
Susan McDermott, Matthew Moodie, Natalie Pao, Gwenan Spearing
Coordinating Editor: Nancy Chen
Copy Editor: Kezia Endsley
Compositor: SPi Global
Indexer: SPi Global
Artist: SPi Global
Distributed to the book trade worldwide by Springer Science+Business Media New York, 233 Spring Street,
6th Floor, New York, NY 10013. Phone 1-800-SPRINGER, fax [phone], e-mail o rders-ny@springer-
sbm.com , or visit w ww.springer.com . Apress Media, LLC is a California LLC and the sole member (owner) is
Springer Science + Business Media Finance Inc (SSBM Finance Inc). SSBM Finance Inc is a Delaware
corporation.
For information on translations, please e-mail [e-mail] , or visit w ww.apress.com .
Apress and friends of ED books may be purchased in bulk for academic, corporate, or promotional use.
eBook versions and licenses are also available for most titles. For more information, reference our Special
Bulk Sales–eBook Licensing web page at w ww.apress.com/bulk-sales .
Any source code or other supplementary materials referenced by the author in this text are available to
readers at w ww.apress.com . For detailed information about how to locate your book’s source code, go to
w ww.apress.com/source-code/ . Readers can also access source code at SpringerLink in the Supplementary
Material section for each chapter.
Printed on acid-free paper
I would like to dedicate this book to two special women in my life; my late mother
Pauline, who sadly passed away while I was drafting the first few chapters, and my wife,
Michelle. To Mum, thanks for always being there for me and I miss you every day, and to
Michelle, thanks for all your support during difficult times, for giving me our wonderful
son Peter, and for finding my best friend, our dog Chocky.

Contents at a Glance
About the Author ....................................................................................................xix
About the Technical Reviewer ................................................................................xxi
Acknowledgments ................................................................................................xxiii
Introduction ...........................................................................................................xxv
■ Chapter 1: Building a Basic MVC Web Site ............................................................1
■ Chapter 2: Creating Views, Controllers, and a Database from Model Classes .....13
■ Chapter 3: Searching, Advanced Filtering, and View Models ..............................43
■ Chapter 4: More Advanced Data Management ....................................................59
■ Chapter 5: Sorting, Paging, and Routing .............................................................83
■ Chapter 6: Managing Product Images: Many-to-Many Relationships ...............107
■ Chapter 7: Authentication and Authorization Using ASP.NET Identity ...............185
■ Chapter 8: Creating a Shopping Basket .............................................................285
■ Chapter 9: Checkout: Creating and Viewing Orders ..........................................333
■ Chapter 10: Advanced Scenarios and Common Workarounds ...........................371
■ Chapter 11: Using Entity Framework Code First with an Existing Database ......407
■ Chapter 12: Introduction to ASP.NET Core v1.0 (MVC6 and EF 7) ......................427
■ Chapter 13: Deploying to Azure .........................................................................441
■ Chapter 14: Restyling the Web Site: An Introduction ........................................467
■ Chapter 15: Styling the Home Page ...................................................................485
v
■ CONTENTS AT A GLANCE
■ Chapter 16: Styling Forms, Grid Layouts, and Tables ........................................501
■ Chapter 17: Advanced CSS ................................................................................537
■ Chapter 18: Responsive Web Sites: Styling for Mobile/Cell and
Tablet Sized Devices ..........................................................................................561
Index .....................................................................................................................603
vi
Contents
About the Author ....................................................................................................xix
About the Technical Reviewer ................................................................................xxi
Acknowledgments ................................................................................................xxiii
Introduction ...........................................................................................................xxv
■ Chapter 1: Building a Basic MVC Web Site ............................................................1
MVC and ASP.NET MVC .....................................................................................................1
Entity Framework and Code First .....................................................................................2
Using Code First with an Existing Database ...........................................................................................2
Software Required for Web Site Development .................................................................2
Creating the Project ..........................................................................................................2
Viewing the Web Site ..............................................................................................................................5
How the Home Page Works ....................................................................................................................6
The About and Contact Pages and ViewBag ...........................................................................................7
Routing: How the Web Site Knows Which Controllers and Methods
to Request ..............................................................................................................................................8
The Purpose of the Layout Page ...........................................................................................................10
Summary ........................................................................................................................12
■ Chapter 2: Creating Views, Controllers, and a Database from Model Classes .....13
Adding the Model Classes ..............................................................................................13
Adding a Database Context ............................................................................................15
Specifying a Connection String ......................................................................................15
vii
■ CONTENTS
Adding Controllers and Views ........................................................................................16
Adding a Category Controller and Views ..............................................................................................16
Examining the CategoriesController Class and Methods ......................................................................17
Examining the Category Views .............................................................................................................21
Adding a Product Controller and Views ................................................................................................29
Using the New Product and Category Views ..................................................................31
Examining the Newly Created BabyStore Database .............................................................................32
Adding Some Data Using the Views ......................................................................................................34
Changing the Way the Category and Product Name Properties are
Displayed Using DataAnnotations .........................................................................................................36
A Simple Query: Sorting Categories Alphabetically ........................................................39
Filtering Products by Category: Searching Related Entities
Using Navigational Properties and Include .....................................................................40
Summary ........................................................................................................................42
■ Chapter 3: Searching, Advanced Filtering, and View Models ..............................43
Adding Product Search ...................................................................................................43
Updating the Controller for Product Searching .....................................................................................43
Testing Product Search .........................................................................................................................44
Adding a Search Box to the Main Site Navigation Bar ..........................................................................45
How to Style Using Bootstrap ...............................................................................................................47
Filtering the Search Results by Category Using ViewBag ..............................................48
Updating the ProductsController Index Method to Filter by Category ...................................................49
Adding the Filter to the Products Index Page .......................................................................................49
Using a View Model for More Complex Filtering .............................................................52
Creating a View Model ..........................................................................................................................52
Updating the ProductsController Index Method to Use the View Model ...............................................54
Modifying the View to Display the New Filter Using the View Model ....................................................55
Summary ........................................................................................................................58
viii
■ CONTENTS
■ Chapter 4: More Advanced Data Management ....................................................59
Deleting an Entity Used as a Foreign Key .......................................................................59
Enabling Code First Migrations and Seeding the Database with Data ...........................61
Enabling Code First Migrations .............................................................................................................61
Seeding the Database with Test Data ...................................................................................................64
Creating the Database Using the Initial Database Migration ................................................................66
Adding Data Validation and Formatting Constraints to Model Classes ...........................69
Adding Validation and Formatting to the Category Class .....................................................................70
Adding Formatting and Validation to the Product Class .......................................................................75
How Validation Works ...........................................................................................................................79
Summary ........................................................................................................................82
■ Chapter 5: Sorting, Paging, and Routing .............................................................83
Sorting Products by Price ...............................................................................................83
Adding Sorting to the Products Index View ..........................................................................................85
Adding Paging ................................................................................................................89
Installing PagedList.Mvc .......................................................................................................................90
Updating the View Model and Controller for Paging .............................................................................90
Updating the Products Index View for Paging .......................................................................................92
Routing ...........................................................................................................................95
Adding Routes ......................................................................................................................................96
Using Routes in Forms ........................................................................................................................103
Using a Route in a Hyperlink ..............................................................................................................104
Setting a Project Start URL ...........................................................................................104
Summary ......................................................................................................................105
■ Chapter 6: Managing Product Images: Many-to-Many Relationships ...............107
Creating Entities to Store Image Filenames .................................................................107
Uploading Images .........................................................................................................108
Defi ning Reusable Constants ..............................................................................................................108
Adding a ProductImage Controller and Views ....................................................................................110
ix