Learning Outomes

[dgilleland]

Topics

• [x] 1) Extension Methods
• [x] 2) Database Fundamentals
  • [x] Relational Database vs. Rich Objects
• [x] 3) Client-Server Architecture
• [x] 4) Entity Framework
  • [x] Code-First, no database
  • [x] Code-First, existing database
  • [x] Model-First, no database
  • [x] Model-First, existing database
  • [x] Annotations
• [x] 5) LINQ-to-Entities
  • [x] Anonymous Types
  • [x] LinqPad
• [ ] 6) CQRS
• [ ] 7) Console front-end
• [ ] 8) Web Site front-end
• [ ] 9) Web Application front-end
• [ ] 10) Windows Forms front-end

[dagilleland]

1) Extension Methods

• [ ] resource links....

[dagilleland]

4) Entity Framework

Code-First, no database

Code-First, existing database

Model-First, no database

Model-First, existing database

Annotations

[dagilleland]

5) LINQ-to-Entities

• [ ] LINQ In General
  • Introduction to LINQ Queries
  • :-1: LINQ and Generic types
  • :+1: (in LinqPad) Basic LINQ query Operations
  • Filtering Where, Ordering orderby, Grouping, Joining, Selecting (Projections)
  • :+1: Standard Query Operators Overview
  • LINQ Query Expressions
  • Data Transformations
  • Concat (similar to Union), Anon types
  • Query Syntax vs. Method Syntax
  • C# Features That Support LINQ

Anonymous Types

LinqPad Linq Insight

[dagilleland]

CQRS

• [ ] links to resources

[dagilleland]

3) Client-Server Architecture

• [ ] links to resources

[dagilleland]

Application Front-End

Configuration files contain connection string information. This includes

1. Where is the DB Server?
2. What is the name of the database
3. Why should I (my program) be allowed access (Security Credentials)
4. Who handles the details (Provider)

Console front-end

Web Site front-end

Web Application front-end

Windows Form front-end

[dagilleland]

2) Database Fundamentals

Relational Database vs. Rich Objects