ASP.Net MVC 5 Application Development Using Entity Framework 6 and VS 2015

cover image of ASP.Net MVC 5 Application Development Using Entity Framework 6 book

     Prev Book Contents »     Next Book Contents »     Price »



Detailed Comparision with SAP Business One »»



Special Offer, Learner Pack = 8 Books + Software

Free, 6 Books + Software

Pay only for 2



Table of Contents

The objective of this book is to teach how to integrate Entity Framework into and build an ASP.Net MVC Application.

Chapter 1: Introduction to Entity Framework 6

  1. Where does Entity Framework fit in a n-tier application?
  2. Why should we consider moving from ADO.Net to Entity framework as the data access technology for our applications?
  3. What is O/RM? How does O/RM handle mismatch?
  4. Benefits of using EF
  5. Roles of ORMS
  6. Create an Entity Data Model for Sales Order Management System
  7. What is an ER diagram?
  8. Degree of a relationship
  9. Cardinality of a relationship
  10. Components of Entity Data Model
  11. Create an EDM for Sales Order Management System using Visual Studio 2015 and Entity Framework 6
  12. Entity Framework Development Approaches
    • Database First
    • Model First
    • Code First
  13. Building blocks of generated EDM (SOMModel.edmx)
  14. EF Context and Entity Classes - SOMModel.Context.tt and SOMModel.tt
  15. SOMModel.tt
  16. POCO Class (Plain Old CLR Object)
  17. EDM Designer
  18. Exploring conceptual model of the EDM using Model Browser
  19. EntitySet element
  20. EntityType element
  21. key element
  22. Property element
  23. Associations
  24. Navigation properties
  25. Mappings Section
  26. Context Class
  27. Responsibilities of DbContext
  28. Instantiating DbContext
  29. DBSet Class and its Methods
  30. Querying with EDM
  31. Query the Entity Data Model using LINQ to Entities
  32. Filtering data
  33. Retrieving a Single entity
  34. How to load related entities
    • Lazy Loading
    • Eager loading using Include() method in Entity Framework
    • Explicit Loading
  35. Projections in LINQ to Entities queries
  36. Grouping
  37. Grouping by Multiple Properties
  38. Sorting
  39. Inserting new Entities into the database
  40. Modifying Entities
  41. Deleting Entities
  42. Saving objects graph
  43. What is entity state and role of entity state while persisting data into the database
contents of the book leading to EF Application Development, Creating a full fledged ASP.Net Application using EF with Code First approach and Database First approach

Chapter : 2. Develop ASP.Net Application Using Entity Framework 6

  1. Data Source Controls in ASP.Net
    • SqlDataSource Control
    • LinqDataSource Control
    • ObjectDataSource Control
    • EntityDataSource Control
  2. EntityDataSource control vs ObjectDataSource control
  3. EntityDataSource Web Server Control
  4. Maintaining the life cycle of the ObjectContext with the EntityDataSource control
  5. Develop ASP.Net Application Using the EntityDataSource control
  6. Create an ASP.Net web application
  7. Create an Entity Data Model as a separate Class Library Project
  8. Using EntityDataSource control for EntityFramework 6
  9. Install the package Microsoft.AspNet.EntityDataSource
  10. Create a new Web Form page
  11. Add and configure the EntityDataSource control on a web form
  12. Configure properties of the EntityDataSource Control
  13. ContextTypeName property
  14. EntitySetName property
  15. How to Bind Web Controls to an EntityDataSource control
  16. Ex 1: How to bind a Drop-Down List to an EntityDataSource control and display data
  17. Ex 2: How to filter data using Where property of EntityDataSource control
  18. Ex 3: Pass parameter values to the Where property using a Control Parameter
  19. Ex 4: Display, update and delete related entities data using EntityDataSource control Include property in a GridView Control
  20. Ex 5: Binding DropDownList to an EntityDataSource in EditItemTemplate of a GridView
  21. Ex 6 : Displaying and updating related entities using multiple EntityDataSource controls - (Master - Detail page)
  22. Ex 7: How to display and insert an entity in a Master/Detail form using GridView and ListView controls
  23. How to build Three-Tier ASP.Net application using EntityFramework 6 and ObjectDataSouce control
  24. Properties of ObjectDatasource control
  25. Create a Class Library project for the Business layer in the solution
  26. Create a business-class and implement methods in the class to perform CRUD operations
  27. Passing objects as parameters to the methods
  28. Displaying Data With the ObjectDataSource control using Entity Framework 6
  29. Add and configure Object Data Source and GridView
  30. ObjectDatasource control Properties
    • SelectMethod
    • DeleteMethod
    • UpdateMethod
  31. Binding a GridView to the ObjectDataSource
  32. Deleting data with GridView Control
  33. Editing Data with the GridView
  34. InsertMethod Property of ObjectDataSource
  35. Display, Update and Delete Entities data using ObjectDataSource control in a DetailsView
  36. Handling Concurrency with the Entity Framework in an ASP.NET Web Application
  37. Implement optimistic Concurrency Conflicts with the EF
  38. Handling Optimistic Concurrency Exceptions
  39. Managing Transactions in the EntityFramework


entity framework book is free with learner pack

Chapter 3 : Building Sales Order Management Application using MVC 5 & EF 6 using DataBase First Approach

  1. Introduction to ASP.NET MVC Architecture
  2. Page Controller Pattern vs MVC design Pattern in ASP.Net
  3. Advantages of an MVC-Based Web Application
  4. Building blocks of MVC application
  5. Creating an ASP.Net MVC 5 application in VS 2015
  6. How ASP.NET MVC Framework maps browser requests to Controller actions
  7. How to apply Routing Constraints in ASP.NET MVC?
  8. Creating a controller in MVC 5
  9. Action methods
  10. Controllers View method in ASP.Net MVC application
  11. Default Action method
  12. Action Results
  13. Receiving Data From Request to Controller
  14. Getting data from Context Objects
  15. Action method parameters
  16. Model Binding
  17. Creating Views in MVC 5
  18. Create a Index view of Customer
  19. Passing data from Controller to View in ASP.Net MVC application
  20. Using ViewData object in MVC application
  21. TempData object
  22. Using ViewBag object in MVC application
  23. Using ViewModels
  24. Domain class vs ViewModel class
  25. Access a View Model object
  26. CRUD operations with Entity Framework 6 Database First using MVC 5
  27. Set up the database
  28. Create a Model using EF
  29. Add new Scaffold item to create controller and views
  30. What is Scaffolding ?
  31. What are the Advantages of using Scaffolding ?
  32. How to connect Customer Views from the Home page of the Application
  33. Explore and understand the code generated for the CRUD operations
  34. How to refer Model object in the Razor View
  35. Strongly typed Model object
  36. Exploring the Details Method
  37. Exploring the Delete Method
  38. Exploring the Edit Action method
  39. Html.BeginForm and Html.EditorFor Html Helper Methods
  40. Model Binding
  41. Binding to Simple Types
  42. Model binding Complex objects
  43. Bind Attribute
  44. Understanding ModelState and integration with HTML Helper Methods
  45. Exploring the Create method
  46. Repository Pattern
  47. Create Repository
  48. Show List of Products
  49. Implementing the Index View Template
  50. Show Details of Product
  51. Implementing the Details View Template
  52. Update Product Details
  53. Delete Product
  54. Razor Syntax
  55. Customizing a View

Chapter 4: Creating ASP.Net MVC 5 Application with Entity Framework 6 Code First

  1. Create the Data Model
  2. Create the EntityFramework Context
  3. Set up EF to initialize the database
  4. Set up EF to use a SQL Server Express LocalDB database
  5. Configuring Connections
  6. Creating a Product Controller and Views
  7. View the Database