Lecture #8 - SQL Server Data Models

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

SQL Tutorial - W3Schools,

Simple LINQ Tutorials

LINQ (How Do I in C#), Simple LINQ tutorial, 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 - MSDN Home, Vijay's Roles Demo
Controllers and Action Methods, 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 continues with Relational Databases and Active Data Objects and focuses on Examples relevant to the Final Project.

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:

   Final Project1, Final Project2, Final Project3

3. LINQ:

   Net 3.5 Prerequisites, delegate structure
   IEnumerable Interface, IEnumerator Interface, IQueryable Interface

   Linq Examples
   Examples of Queries on collections and LINQ to XML.

4. Relational Database Presentation and Examples:

   
   
   SQL Presentation, Sql Code, Database Code Examples

   The Relational Database Model, Database Schema Examples, 101 LINQ Samples

5. LINQ to SQL

   Create Database with LINQ

   MvcBooks, Code Folder

   Creating DropDownList in MVC
   I used some of the code described here to populate DropDowns in TestBooksDB. The site has a lot of useful discussion with code snippets.

   Adding Query Strings to ActionLink
   This can occasionally be useful.

   Accessing Data with ADO.NET, .Net Framework 4
   Accessing Data with ADO.NET, .Net Framework 4.5
   Accessing Data with ASP.NET

6. Interesting things that appeared in Asp.Net MVC 4.0

   Video of Scott Guthrie's presentation on Asp.Net 4.0, Scott Guthrie's RSS Feed
   Asp.Net Web API - implementation of REST

7. Relational Database Tutorials:

   w3schools.com-sql-tutorial, database tutor

8. LINQ to SQL tutorials:

   LINQ to SQL Samples - MSDN, Getting Started - MSDN
   Links to some great Scott Guthrie Tutorials, Guthrie on LINQ CRUD, Scott Guthrie's Nerd Dinner MVC Demo
   Joe Stevens, CodeProject Hacker Chick, CRUD - Hacker Chick, LINQ to SQL - MSDN, LINQ Join, LINQ Methods,
9. Model Repository:
   Prateek's Repository Demo
10. Asp.Net tutorials and videos - Recommended
    Asp.Net videos
    
11. ADO Tutorials:
    ADO QuickStart, Overview of ADO Operations, Asp QuickStart, ADO articles, Single Table Commands
12. ADO Notes:
    ADO Presentation, Murat's SQL Queries with Joins Presentation
13. Structured Query Language (SQL) Tutorials:
    SqlZoo, w3schools, Microsoft PDC, sqlTeam, sqlCourse2, sql-tutorial, Introduction to SQL, SQL Tutorial, firstsql
14. Web Services
    Web Services
    Windows Communication Foundation (WCF)
15. WCF Service Example:
    File Transfer WCF service
    FileTransfer Web service - view web page
    FileTransfer web service - view folder
16. Lab Assignment #8