Generics And LINQ

C# and Generics

• Without generics consumer of ArraryList type can store any data inside of it
  

 Different approach to solve this problem without generics

 But this way there is code redundant

 Calculate the performance between Collection and Generic Collection objects

 Generating Unbound Generics types from Reflection

 

Generating Open/Closed Generics types from Reflection

 

C# and LINQ

 LINQ implementation without Extension method

 LINQ with Extension methods

Extension method and Lambdas

Anonymous method with delegate in LINQ

Lambda code with LINQ

Lambdas with FUNC, ACTION and PREDICATE

LINQ to XML

Creating XML

Saving XML

Loading XML

Processing XML

Namespaces

Traversal

Standard Query Operators

Query Extensions

Modify XML node

Functional Construction

Create and Query Demo

Transformation

Validation

XPATH

LINQ to SQL Part I

Data Access Code

LINQ to SQL Overview

Mapping with POCO Approach – Code generation manually

POCO Demo

Mapping with Attributes

The Data Context

Demo of Data Context – Code generating with VS

Code Generating with SQLMetal.exe

 

 

Relationships

Lazy Linq to SQL

Data Load Options

Projections

Inheritance

Compiled Queries

Executing SQL

Stored procedure

LINQ Data Source

LINQ to SQL Part II

Modifying Data

Identity

Identity Map Pattern

Demo of Object Map

Entity Life Cycle

Updates

Note: SubmitChanges is all going to work as a whole or it's all going to roll back.

Change Tracking

Updating Associations

 

Managing Association in Demo

Inserts

Delete

Concurrency

Transactions

Detached Entities

The ADO.NET Entity Framework Part I

New ADO.NET

Entity Focus

Entity Data Model Designer

Model Browser

Using the Model

Mapping Details

EF Services

Object Context

LINQ to Entities

Query with LINQ

Query with Stored Procedure

Deffered Loading

 

Explicit Load option with LOAD Method

Note:  This is very expensive as it will issue multiple SQL commands to the DB in loop.

Eagar Loading with Include method

Inserts

Updates

Deletes

Entity Update Demo

L2S Versus EF

The ADO.NET Entity Framework Part 2

 

ORM and Entity Identity

Identity Maps

Note: Remember this identity map is maintained on a per context basis.

Entity Life Cycle

 

Changing Associations

(OR)

Transactions

Stored Procedure

Detached Entities

ADO.NET Data Services

Motivation

RESTful Services

LINQ and DATA Services

Demo of Data Services

URL Options

POCO Data sources

Primitive Client

Data Service Context Client

 

Demo of Data Service Context

Create, Update and Delete

Silverlight

Data Service Server

 

Client

Client call on Service operations