CO550 WA05 - Web Tutor

Week 5 Activities - ASP.NET Core 2.1 Razor Pages

Task	Lesson Activity	Learning Assessment	Skill Developed
5.1	15 min Razor Pages ASP.NET Core Web Application 5 min Goto page 2 of the Contoso University Razor Pages tutorial 5 min Read and understand LINQ and Lambda expressions so that the CRUD code produced by scaffolding will make more sense Also look at Query Syntax and Method Syntax 1 min Download Logbook 3 CRUD 1 min Open your ASP.NET Core Razor Pages Contoso Project 10 min Customise the Students Details page, and add the enrollments for that student .	Logbook 3	LINQ and Lambda Expressions
5.2	15 min LINQ and Data Migrations 5 min Select Page 4 of the Razor Pages Tutorial - Data Migrations 15 min Use the Package Manager Console to drop (delete) the database. Then add-migration IntitialCreate 5 min Annotate the Student model to ensure valid data, add add-migration AnnotateStudent and update the database Video 30 min Derek demonstrating the above changes	Logbook 3	Db Annotations and Migrations

Wesbite TutorialsTeacher: A good website for ASP.NET Cire, MVC and LINQ
Have a look at Why LINQ, Query Syntax, Method Syntax, Lambda Expreesions and the query operators
Wesbite LINQSamples.com: A good selection of example LINQ queries in Query and Method Syntax
Wesbite Get started with EF Code First using Core Razor Pages (Contoso University)
Wesbite Get started with EF Code First using Core MVC (Contoso University)
Wesbite Get started with EF Code First using MVC 5 (Contoso University)
Wesbite A good explanation of the different Initialisation stategies with EF 6 Code-First and how to set them.
Wesbite A good explanation of the Fluent API which can be used to configure your database schema in a customised way.