Preview course for free

Preview this course for free.

To preview this course, you will need to create a free account. Once you register, we'll send
you right along and you will get access to the first task in the course (day 1).


No credit card or payment info is required. Existing users, sign-in to begin.

Preview this course for free.

To preview this course, you will need to create a free account. Once you register, we'll send
you right along and you will get access to the first task in the course (day 1).


No credit card or payment info is required. Existing users, sign-in to begin.

Take a class, join the instructor-supported online learning revolution.

Choose a class date below to get started. Every class comes with a complimentary subscription which begins immediately even if your class doesn't start for a week or two. You can be learning in just minutes.

Upcoming classes: Choose this date >>


Take this course.

You'll need to get a subscription to join this course.
Our subscriptions start at $29.

View your subscription options
Course Summary

From zero to data-driven websites in MVC is all about building data-driven ASP.NET MVC applications that both accept user input and store and retrieve that data from databases such as SQL Server using LINQ and Entity Framework as the data access API.

We start with developers who are proficient in C# but otherwise are basically new to MVC, LINQ, and Entity Framework.

Virtually all modern data-access APIs in .NET support LINQ as their primary means of querying. That is where this course begins. We look at LINQ and some of the C# foundational concepts (e.g. lambda expressions). Next, we quickly move on to working with databases and Entity Framework (aka EF).

Once we have covered the requisite data access concepts, we introduce ASP.NET MVC. We cover how to create a new web application and how to add logic and views to our app. We then look at the variety of ways to acquire data in MVC (from user input, from the URL, and from databases) as well as validate that data.

We finish the class exploring several techniques for displaying data safety and efficiently back to the user. When you are done with this class, building data-driven web apps with MVC should be a breeze.

Course Objectives

After completing this course, you should be proficient in the following:

  • Write basic LINQ queries.
  • Treat in-memory collections (e.g. arrays, lists) as databases with LINQ to Objects.
  • Create a set of objects based on a database schema.
  • Read data from a database.
  • Know the value of using an ORM such as EF.
  • See how C# methods are converted into database queries in LINQ.
  • Create new ASP.NET MVC projects.
  • Create input forms that accept all types of user input.
  • Enable MVC’s client-side validation libraries.
  • Discover additional validation libraries built for MVC.
Edit video url:

Edit Course Objectives











Change objectives

Tasks

Search tasks

tasks found
Save
Preview this task « This task is available right now for free, no payment info required.
Use lambda expressions to call methods that require delegate parameters
9 Activities | Time: 1h 49m | Types: Article (2) | Practice (4) | Video (3)
Filter and Order Data Using LINQ to Objects
12 Activities | Time: 1h 27m | Types: Article (3) | Blog (1) | Practice (4) | Video (4)
Use LocalDB as a development database
4 Activities | Time: 40m | Types: Blog (1) | Practice (2) | Video (1)
Read database data with Entity Framework 4
11 Activities | Time: 3h 24m | Types: Blog (1) | Practice (5) | Video (5)
Insert, update, and delete data from a database using Entity Framework.
7 Activities | Time: 1h 3m | Types: Article (2) | Blog (2) | Practice (1) | Video (2)
Write LINQ to Entity Framework queries
12 Activities | Time: 2h 31m | Types: Article (3) | Blog (2) | Practice (6) | Run (1)
"Hello world", MVC style
8 Activities | Time: 1h 30m | Types: Article (1) | Blog (2) | Practice (1) | Run (2) | Video (2)
Create views in MVC (Razor and C#)
8 Activities | Time: 1h 34m | Types: Blog (5) | Practice (2) | Video (1)
Pass data to views
9 Activities | Time: 1h 23m | Types: Article (4) | Blog (1) | Practice (2) | Video (2)
Handle parameters from a URL (routing in MVC)
5 Activities | Time: 1h 16m | Types: Blog (1) | Practice (2) | Run (1) | Video (1)
Build Rich Forms to Accept Data with MVC
5 Activities | Time: 1h 1m | Types: Article (2) | Blog (1) | Practice (1) | Video (1)
Validating User Input with Data Annotations
7 Activities | Time: 1h 30m | Types: Article (3) | Practice (3) | Video (1)
Implement a rich data grid using MVC
2 Activities | Time: 34m | Types: Practice (2)