LINQ Fundamentals – Part 2

 

 

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

 

 

 

 

 

 

Blogger Labels: LINQ,Fundamentals,Part,Namespaces,Traversal,Standard,Query,Operators,Extensions,Modify,node,Functional,Construction,Create,Demo,Transformation,Validation,XPATH,Data,Code,Overview,POCO,Approach,generation,Attributes,Context,SQLMetal,Relationships,Lazy,Load,Options,Projections,Inheritance,Queries,procedure,Source,Pattern,Object,Life,Cycle,Updates,Note,SubmitChanges,Change,Associations,Association,Inserts,Delete,Concurrency,Transactions,Entities,Framework,Focus,Model,Designer,Browser,Details,Services,Explicit,option,Method,Eagar,Include,Deletes,Update,Versus,Maps,Remember,basis,Motivation,RESTful,Primitive,Client,Service,Server