http://msdn.microsoft.com/en-us/data/cc299426.aspx video with entity model
ADO.NET
-
What's
New in ADO.NET
-
ADO.NET
Overview
-
Securing
ADO.NET Applications
-
Data
Type Mappings in ADO.NET
-
DataSets,
DataTables, and DataViews (ADO.NET)
-
Creating
a DataSet (ADO.NET)
-
Adding
a DataTable to a DataSet (ADO.NET)
-
Adding
DataRelations (ADO.NET)
-
Navigating
DataRelations (ADO.NET)
-
Merging
DataSet Contents (ADO.NET)
-
Copying
DataSet Contents (ADO.NET)
-
Handling
DataSet Events (ADO.NET)
-
Typed
DataSets (ADO.NET)
-
DataTables
(ADO.NET)
-
DataTableReaders
(ADO.NET)
-
DataViews
(ADO.NET)
-
Creating
a DataView (ADO.NET)
-
Sorting
and Filtering Data (ADO.NET)
-
DataRows
and DataRowViews (ADO.NET)
-
Finding
Rows (ADO.NET)
-
ChildViews
and Relations (ADO.NET)
-
Modifying
DataViews (ADO.NET)
-
Handling
DataView Events (ADO.NET)
-
Managing
DataViews (ADO.NET)
-
Creating
a DataTable from a DataView
(ADO.NET)
-
-
Using
XML in a DataSet (ADO.NET)
-
DiffGrams
(ADO.NET)
-
Loading
a DataSet from XML (ADO.NET)
-
Writing
DataSet Contents as XML Data
(ADO.NET)
-
Loading
DataSet Schema Information from XML
(ADO.NET)
-
Writing
DataSet Schema Information as XSD
(ADO.NET)
-
DataSet
and XmlDataDocument Synchronization
(ADO.NET)
-
Nesting
DataRelations (ADO.NET)
-
Deriving
DataSet Relational Structure from
XML Schema (XSD)
-
Inferring
DataSet Relational Structure from
XML (ADO.NET)
-
-
Consuming
a DataSet from an XML Web Service
(ADO.NET)
-
-
LINQ
to DataSet
-
Retrieving
and Modifying Data in ADO.NET
-
Connecting
to a Data Source (ADO.NET)
-
Connection
Strings (ADO.NET)
-
Connection
Pooling (ADO.NET)
-
Commands
and Parameters (ADO.NET)
-
DataAdapters
and DataReaders (ADO.NET)
-
Retrieving
Data Using a DataReader (ADO.NET)
-
Populating
a DataSet from a DataAdapter
(ADO.NET)
-
DataAdapter
Parameters (ADO.NET)
-
Adding
Existing Constraints to a DataSet
(ADO.NET)
-
DataAdapter
DataTable and DataColumn Mappings
(ADO.NET)
-
Paging
Through a Query Result (ADO.NET)
-
Updating
Data Sources with DataAdapters
(ADO.NET)
-
Handling
DataAdapter Events (ADO.NET)
-
Performing
Batch Operations Using DataAdapters
(ADO.NET)
-
-
Transactions
and Concurrency (ADO.NET)
-
Retrieving
Identity or Autonumber Values (ADO.NET)
-
Retrieving
Large Data (ADO.NET)
-
Modifying
Data with Stored Procedures (ADO.NET)
-
Retrieving
Database Schema Information (ADO.NET)
-
DbProviderFactories
(ADO.NET)
-
Data
Tracing in ADO.NET
-
Performance
Counters (ADO.NET)
-
-
ADO.NET
Entity Framework
-
Introducing
the Entity Framework
-
Getting
Started
-
Programming
Guide
-
Application
Scenarios
-
Entity
Framework Tasks
-
Configuring
the Entity Framework
-
Defining
an Entity Data Model
-
How
to: Manually Define an
Entity Data Model
-
How
to: Define the Connection
String
-
How
to: Use EdmGen.exe to
Generate an Entity Data
Model
-
How
to: Use EdmGen.exe to
Generate Object Model Files
-
How
to: Use EdmGen.exe to
Validate an Entity Data
Model
-
How
to: Pre-Generate Views to
Improve Query Performance
-
How
to: Make Model and Mapping
Files Embedded Resources
-
Defining
Advanced Data Models
-
-
Querying
an Entity Data Model
-
How
to: Execute a Query that
Returns an Entity Type
-
How
to: Execute a Parameterized
Query
-
How
to: Navigate Relationships
Using Navigation Properties
-
How
to: Use Query Paths to Shape
Results
-
How
to: Explicitly Load Related
Objects
-
How
to: Filter Data
-
How
to: Sort Data
-
How
to: Group Data
-
How
to: Aggregate Data
-
How
to: Execute a Query that
Returns an Anonymous Type
-
How
to: Execute a Query that
Returns a Primitive Type
-
How
to: Return a Specific Object
Using its Key
-
How
to: Query Related Objects in
an EntityCollection
-
How
to: Order Two Unionized
Queries
-
How
to: Page Through Query
Results
-
How
to: View the Store Commands
-
How
to: Remove Duplicate
Elements From LINQ to
Entities Query Results
-
How
to: Convert the Results of a
LINQ to Entities Query to an
Array
-
Querying
Advanced Data Models
-
-
Working
with Objects
-
How
to: Add, Modify, and Delete
Objects
-
How
to: Create an Object Using
the Static Create Method
-
How
to: Manage Data Concurrency
in the Object Context
-
How
to: Execute Business Logic
During Property Changes
-
How
to: Execute Business Logic
When Saving Changes
-
How
to: Attach Related Objects
-
How
to: Apply Changes Made to a
Detached Object
-
How
to: Change Relationships
Between Objects
-
How
to: Detach Objects from an
Object Context
-
How
to: Serialize and
Deserialize Objects
-
How
to: Customize Generated Data
Objects
-
Working
with Objects from an
Advanced Data Model
-
Working
with Custom Objects
-
-
Binding
Objects to Controls
-
Managing
Connections and Transactions
-
Working
with EntityClient
-
How
to: Build an
EntityConnection Connection
String
-
How
to: Execute a Query that
Returns PrimitiveType
Results
-
How
to: Execute a Query that
Returns StructuralType
Results
-
How
to: Execute a Query that
Returns RefType
-
How
to: Execute a Query that
Returns Complex Types
-
How
to: Execute a Query that
Returns Nested Collections
-
How
to: Execute a Parameterized
Entity SQL Query Using
EntityCommand
-
How
to: Execute a Parameterized
Stored Procedure Using
EntityCommand
-
How
to: Execute a Polymorphic
Query
-
How
to: Navigate Relationships
with Navigate Operator
-
-
-
Security
Considerations
-
Performance
Considerations
-
Migration
Considerations
-
Deployment
Considerations
-
-
Feature
Reference
-
Samples
-
Entity
Framework Terminology
-
-
Entity
Data Model Tools
-
What's
New in the Documentation
-
Entity
Data Model Wizard
-
ADO.NET
Entity Data Model Designer
-
Update
Model Wizard
-
ADO.NET
Entity Data Model Designer Scenarios
-
Creating
an Application Using an Entity Data
Model
-
Walkthrough:
Mapping Inheritance -
Table-per-Hierarchy
-
Walkthrough:
Mapping Inheritance - Table-per-Type
-
Walkthrough:
Mapping an Entity to Multiple Tables
-
Walkthrough:
Mapping an Entity to Stored
Procedures
-
Walkthrough:
Retrieving Entity Types with a
Stored Procedure
-
Using
the Entity Designer with ASP.NET
-
-
Entity
Data Model Tools Tasks
-
-
ADO.NET
Data Services Framework
-
SQL
Server and ADO.NET
-
Oracle
and ADO.NET
-
Language-Integrated
Query (LINQ)
-
Introduction
to LINQ
-
Getting
Started with LINQ in C#
-
Getting
Started with LINQ in Visual Basic
-
How
to: Create a LINQ Project
-
Visual
Studio IDE and Tools Support for LINQ
-
LINQ
General Programming Guide
-
LINQ
to Objects
-
LINQ
and Strings
-
How
to: Count Occurrences of a Word in a
String (LINQ)
-
How
to: Query for Sentences that Contain
a Specified Set of Words (LINQ)
-
How
to: Query for Characters in a String
(LINQ)
-
How
to: Combine LINQ Queries with
Regular Expressions
-
How
to: Find the Set Difference Between
Two Lists (LINQ)
-
How
to: Sort or Filter Text Data by Any
Word or Field (LINQ)
-
How
to: Reorder the Fields of a
Delimited File (LINQ)
-
How
to: Combine and Compare String
Collections (LINQ)
-
How
to: Populate Object Collections from
Multiple Sources (LINQ)
-
How
to: Split a File Into Many Files by
Using Groups (LINQ)
-
How
to: Join Content from Dissimilar
Files (LINQ)
-
How
to: Compute Column Values in a CSV
Text File (LINQ)
-
-
LINQ
and Reflection
-
LINQ
and File Directories
-
How
to: Query for Files with a Specified
Attribute or Name
-
How
to: Group Files by Extension (LINQ)
-
How
to: Query for the Total Number of
Bytes in a Set of Folders (LINQ)
-
How
to: Compare the Contents of Two
Folders (LINQ)
-
How
to: Query for the Largest File or
Files in a Directory Tree (LINQ)
-
How
to: Query for Duplicate Files in a
Directory Tree (LINQ)
-
How
to: Query the Contents of Files in a
Folder (LINQ)
-
-
How
to: Query an ArrayList with LINQ
-
How
to: Add Custom Methods for LINQ Queries
-
-
LINQ
to XML
-
Getting
Started (LINQ to XML)
-
Programming
Guide (LINQ to XML)
-
LINQ
to XML Programming Overview
-
Creating
XML Trees
-
Functional
Construction (LINQ to XML)
-
Creating
XML Trees in C# (LINQ to XML)
-
Introduction
to XML Literals in Visual Basic
-
Cloning
vs. Attaching
-
Parsing
XML
-
How
to: Populate an XML Tree with an
XmlWriter (LINQ to XML)
-
How
to: Validate Using XSD (LINQ to
XML)
-
Valid
Content of XElement and
XDocument Objects
-
-
Working
with XML Namespaces
-
Serializing
XML Trees
-
LINQ
to XML Axes
-
LINQ
to XML Axes Overview
-
How
to: Retrieve a Collection of
Elements (LINQ to XML)
-
How
to: Retrieve the Value of an
Element (LINQ to XML)
-
How
to: Filter on Element Names
(LINQ to XML)
-
How
to: Chain Axis Method Calls
(LINQ to XML)
-
How
to: Retrieve a Single Child
Element (LINQ to XML)
-
How
to: Retrieve a Collection of
Attributes (LINQ to XML)
-
How
to: Retrieve a Single Attribute
(LINQ to XML)
-
How
to: Retrieve the Value of an
Attribute (LINQ to XML)
-
How
to: Retrieve the Shallow Value
of an Element
-
Language-Integrated
Axes in Visual Basic (LINQ to
XML)
-
-
Querying
XML Trees
-
Basic
Queries (LINQ to XML)
-
How
to: Find an Element with a
Specific Attribute
-
How
to: Find an Element with a
Specific Child Element
-
Querying
an XDocument vs. Querying an
XElement
-
How
to: Find Descendants with a
Specific Element Name
-
How
to: Find a Single Descendant
Using the Descendants Method
-
How
to: Write Queries with
Complex Filtering
-
How
to: Filter on an Optional
Element
-
How
to: Find All Nodes in a
Namespace
-
How
to: Sort Elements
-
How
to: Sort Elements on
Multiple Keys
-
How
to: Calculate Intermediate
Values
-
How
to: Write a Query that Finds
Elements Based on Context
-
How
to: Debug Empty Query
Results Sets
-
-
Projections
and Transformations (LINQ to
XML)
-
How
to: Work with Dictionaries
Using LINQ to XML
-
How
to: Transform the Shape of
an XML Tree
-
How
to: Control the Type of a
Projection
-
How
to: Project a New Type (LINQ
to XML)
-
How
to: Project an Object Graph
-
How
to: Project an Anonymous
Type
-
How
to: Generate Text Files from
XML
-
How
to: Generate XML from CSV
Files
-
-
Advanced
Query Techniques (LINQ to XML)
-
How
to: Join Two Collections
(C#) (LINQ to XML)
-
How
to: Create Hierarchy Using
Grouping
-
How
to: Query LINQ to XML Using
XPath
-
How
to: Write a LINQ to XML Axis
Method
-
How
to: Perform Streaming
Transformations of Text to
XML
-
How
to: List All Nodes in a Tree
-
How
to: Retrieve Paragraphs from
an Office Open XML Document
-
How
to: Modify an Office Open
XML Document
-
How
to: Populate an XML Tree
from the File System
-
-
LINQ
to XML for XPath Users
-
Comparison
of XPath and LINQ to XML
-
How
to: Find a Child Element (XPath-LINQ
to XML)
-
How
to: Find a List of Child
Elements (XPath-LINQ to XML)
-
How
to: Find the Root Element (XPath-LINQ
to XML)
-
How
to: Find Descendant Elements
(XPath-LINQ to XML)
-
How
to: Filter on an Attribute (XPath-LINQ
to XML)
-
How
to: Find Related Elements (XPath-LINQ
to XML)
-
How
to: Find Elements in a
Namespace (XPath-LINQ to
XML)
-
How
to: Find Preceding Siblings
(XPath-LINQ to XML)
-
How
to: Find Descendants of a
Child Element (XPath-LINQ to
XML)
-
How
to: Find a Union of Two
Location Paths (XPath-LINQ
to XML)
-
How
to: Find Sibling Nodes (XPath-LINQ
to XML)
-
How
to: Find an Attribute of the
Parent (XPath-LINQ to XML)
-
How
to: Find Attributes of
Siblings with a Specific
Name (XPath-LINQ to XML)
-
How
to: Find Elements with a
Specific Attribute (XPath-LINQ
to XML)
-
How
to: Find Child Elements
Based on Position (XPath-LINQ
to XML)
-
How
to: Find the Immediate
Preceding Sibling (XPath-LINQ
to XML)
-
-
Pure
Functional Transformations of
XML
-
-
Modifying
XML Trees (LINQ to XML)
-
In-Memory
XML Tree Modification vs.
Functional Construction (LINQ to
XML)
-
Adding
Elements, Attributes, and Nodes
to an XML Tree
-
Modifying
Elements, Attributes, and Nodes
in an XML Tree
-
Removing
Elements, Attributes, and Nodes
from an XML Tree
-
Maintaining
Name/Value Pairs
-
How
to: Change the Namespace for an
Entire XML Tree
-
-
Performance
(LINQ to XML)
-
Advanced
LINQ to XML Programming
-
LINQ
to XML Annotations
-
LINQ
to XML Events
-
Programming
with Nodes
-
Mixed
Declarative Code/Imperative Code
Bugs (C#) (LINQ to XML)
-
How
to: Stream XML Fragments with
Access to Header Information
-
How
to: Perform Streaming Transform
of Large XML Documents
-
How
to: Read and Write an Encoded
Document
-
Using
XSLT to Transform an XML Tree
-
How
to: Use Annotations to Transform
LINQ to XML Trees in an XSLT
Style
-
Serializing
Object Graphs that Contain
XElement Objects
-
WPF
Data Binding with LINQ to XML
-
-
LINQ
to XML Security
-
Sample
XML Documents (LINQ to XML)
-
Sample
XML File: Typical Purchase Order
(LINQ to XML)
-
Sample
XML File: Typical Purchase Order
in a Namespace
-
Sample
XML File: Multiple Purchase
Orders (LINQ to XML)
-
Sample
XML File: Multiple Purchase
Orders in a Namespace
-
Sample
XML File: Test Configuration
(LINQ to XML)
-
Sample
XML File: Test Configuration in
a Namespace
-
Sample
XML File: Customers and Orders
(LINQ to XML)
-
Sample
XSD File: Customers and Orders
-
Sample
XML File: Customers and Orders
in a Namespace
-
Sample
XML File: Numerical Data (LINQ
to XML)
-
Sample
XML File: Numerical Data in a
Namespace
-
Sample
XML File: Books (LINQ to XML)
-
Sample
XML File: Consolidated Purchase
Orders
-
-
-
Reference
(LINQ to XML)
-
Samples
(LINQ to XML)
-
-
LINQ
to ADO.NET (Portal Page)
-
LINQ
Samples
-
LINQ
C# Samples
-
Connecting
to LINQ Sample Databases
-
Sample
Queries
-
Data
Sample
-
Dynamic
Query Sample
-
Expression
Tree Visualizer Sample
-
LINQ
to Northwind Sample
-
LINQ
Query Visualizer Sample
-
Object
Dumper Sample
-
Paste
XML as LINQ Sample
-
Reflector
Sample
-
RSS
Sample
-
Simple
Lambdas Sample
-
Windows
Forms Data Binding Sample
-
Introduction
to LINQ to XML Sample
-
XQuery
Sample
-
LINQ
to XML Databinding Sample
-
NorthwindMapping
Sample
-
Simple
LINQ to Objects Sample
-
LINQ
to TerraServer Provider Sample
-
-
LINQ
Sample Applications in Visual Basic
-
-
Supplementary
LINQ Resources
-
Programming
with the .NET
Framework
-
Accessing
Data with
ADO.NET
-
Overview
of ADO.NET
-
Using
.NET
Framework
Data
Providers to
Access Data
-
Connecting
to a
Data
Source
Using
ADO.NET
-
Connecting
to
SQL
Server
Using
ADO.NET
-
Connection
Pooling
for
the
.NET
Framework
Data
Provider
for
SQL
Server
-
Connecting
to
an
OLE
DB
Data
Source
Using
ADO.NET
-
Connection
Pooling
for
the
.NET
Framework
Data
Provider
for
OLE
DB
-
Connecting
to
an
ODBC
Data
Source
Using
ADO.NET
-
Connection
Pooling
for
the
.NET
Framework
Data
Provider
for
ODBC
-
Connecting
to
an
Oracle
Data
Source
Using
ADO.NET
-
Connection
Pooling
for
the
.NET
Framework
Data
Provider
for
Oracle
-
Working
with
Connection
Events
-
-
Executing
a
Command
-
Retrieving
Data
Using
the
DataReader
-
Using
Stored
Procedures
with a
Command
-
Obtaining
a Single
Value
from a
Database
-
Obtaining
BLOB
Values
from a
Database
-
Writing
BLOB
Values
to a
Database
-
Performing
Database
Operations
and
Modifying
Data
-
Obtaining
Data as
XML from
SQL
Server
-
Populating
a
DataSet
from a
DataAdapter
-
Updating
the
Database
with a
DataAdapter
and the
DataSet
-
Adding
Existing
Constraints
to a
DataSet
-
Setting
Up
DataTable
and
DataColumn
Mappings
-
Using
Parameters
with a
DataAdapter
-
Input
and
Output
Parameters,
and
Return
Values
-
Automatically
Generated
Commands
-
Working
with
DataAdapter
Events
-
Obtaining
Schema
Information
from a
Database
-
Performing
Transactions
-
Code
Access
Security
for .NET
Framework
Data
Providers
-
-
Creating
and Using
DataSets
-
XML
and the
DataSet
-
DiffGrams
-
Loading
a
DataSet
from XML
-
Writing
a
DataSet
as XML
Data
-
Loading
DataSet
Schema
Information
from XML
-
Writing
DataSet
Schema
Information
as XML
Schema
(XSD)
-
Synchronizing
a
DataSet
with an
XmlDataDocument
-
Nested
DataRelations
-
Generating
DataSet
Relational
Structure
from XML
Schema
(XSD)
-
Inferring
DataSet
Relational
Structure
from XML
-
-
Creating
and Using
DataTables
-
Creating
and Using
DataViews
-
Accessing
an ADO
Recordset or
Record from
ADO.NET
-
Sample
ADO.NET
Scenarios
-
Writing
Secure
ADO.NET Code
-
Implementing
a .NET
Framework
Data
Provider
-