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, WebReferenceResources for This Lecture:
SQL Server
XML Tutorial - W3Schools, SQL Tutorial - W3SchoolsSimple LINQ Tutorials
LINQ (How Do I in C#), Simple LINQ tutorial - CodeProject, LINQ tutorial - tutorialspoint 101 LINQ SamplesLINQ to SQL
links to all of Scott Guthrie's LINQ to SQL tutorialsScottGu: 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 TutorialsGetting 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 DemoAction 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.- Syllabus describes topics to be covered, reading material for you to digest before coming to class, and due dates for the assigned projects.
-
Final Projects:
-
XML Tutorials and Document Object Model References:
-
The Simple part of XML:
-
LINQ:
Introduction to LINQ Net 3.5 Prerequisites, delegate structure
IEnumerable Interface, IEnumerator Interface, IQueryable Interface Basic Linq Examples
Examples of Queries on collections and LINQ to XML. Linq Query Examples
More Queries including a join. 101 LINQ Samples -
LINQ to SQL and Entity Framework
Create Database with LINQ MVC CRUD with XML, MVC CRUD with XML code folder MVC CRUD with SQL, MvcCRUDwithSQL code folder Linq Pad Demo Linq to SQL Interactive Demo Parallel Linq Demo Note: zips for the last three demos are in the parent directory:
Handouts/CSE687/code/Palider/Lect7 -
Roles - part 3:
-
MVC 5 Update using Nuget:
-
Relational Database Presentation and Examples:
-
Client and Server Validation
-
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 - Lab Assignment #7