CSE686 - Internet Programming

Lecture #7 - Using LINQ to Access XML and SQL Data

Web Resources:

Color Lab, Color Codes, HTML tags, Everything HTML, XML, HTML, Scripting, webdeveloper.earthweb, devx..., W3Schools, Web Developer's Virtual Library, World-Wide Web Consortium, WebReference

Resources for This Lecture:

SQL Server

XML Tutorial - W3Schools, SQL Tutorial - W3Schools

Simple LINQ Tutorials

LINQ (How Do I in C#), Simple LINQ tutorial - CodeProject, LINQ tutorial - tutorialspoint 101 LINQ Samples

LINQ to SQL

links to all of Scott Guthrie's LINQ to SQL tutorials
ScottGu: Using LINQ to SQL, Joins using LINQ to SQL Creating Model Classes with LINQ to SQL
LINQ Tutorial: Mapping Tables to Objects - codeproject, Create many-to-many relationships in LINQ for SQL

Entity Framework

Links to Entity Framework Tutorials
Getting Started with Entity Framework, Entity Framework Quickstart, Creating an Entity Framework Data Model

Asp.Net MVC

Asp.net MVC 5 - ASP.NET, Vijay's Roles Demo
Action Filtering, Models and Validation, Passing Data in an Asp.Net MVC Application
Rendering a Form using HTML Helpers, Views and UI Rendering, Walkthrough: Using Templated Helpers, View Calling Multiple Actions, Walkthrough: Using View Templates with Scaffolding Pass QueryString in ActionLink

Content:

This lecture is concerned with data persistence using eXtensible Markup Language and SQL Server databases.
  1. Syllabus describes topics to be covered, reading material for you to digest before coming to class, and due dates for the assigned projects.
  2. Final Projects:
  3. XML Tutorials and Document Object Model References:

  4. The Simple part of XML:

  5. LINQ:

  6. LINQ to SQL and Entity Framework

  7. Roles - part 3:

  8. MVC 5 Update using Nuget:

  9. Relational Database Presentation and Examples:

  10. Client and Server Validation

  11. Role Models

    The links below use the Asp.Net Configuration Manager - a useful tool provided by Asp.Net Mvc 4, but removed from Asp.Net Mvc 5. So these instructions only work for versions before Mvc 5.

    MVC Role Model, MVC Role Model Screenshots
  12. Lab Assignment #7