LINQ Data Access

Visit Tutorial Page ( Report)

Language Integrated Query (LINQ) introduces fundamental changes to the techniques .NET developers will use to access data. LINQ brings general-purpose query facilities to the .NET framework and allows a developer to query data inside of in-memory objects, data inside of relational databases, and data inside of XML using a uniform API and syntax.

  • LINQ to XML
    00:58:02
    • Introduction
      00:00:31
    • XML Today
      00:03:18
    • Motivation for a new API
      00:02:49
    • System.XML.Linq
      00:01:18
    • Creating XML
      00:05:57
    • Saving XML
      00:02:41
    • Loading XML
      00:02:03
    • Processing XML
      00:06:54
    • Namespaces
      00:07:10
    • Traversal
      00:04:54
    • Query Operators
      00:02:29
    • Query Extensions
      00:02:04
    • Functional Construction
      00:02:15
    • Create and Query Demo
      00:07:25
    • Transformation
      00:02:54
    • Validation
      00:01:10
    • XPath
      00:00:48
    • Summary
      00:01:22
  • LINQ to SQL Part I
    01:10:00
    • Introduction
      00:00:48
    • Data Access Code
      00:07:06
    • Object Relational Mapping
      00:03:23
    • LINQ to SQL Overview
      00:04:38
    • POCOs
      00:01:36
    • POCO Demo
      00:03:14
    • Attributes
      00:01:54
    • The DataContext
      00:04:34
    • DataContext Demo
      00:06:44
    • SqlMetal.exe
      00:02:33
    • Relationships
      00:04:22
    • Lazy LINQ to SQL
      00:07:39
    • Data Load Options
      00:01:31
    • Projections
      00:01:43
    • Inheritance
      00:05:23
    • Compiled Queries
      00:02:33
    • Executing SQL
      00:02:15
    • Stored Procedures
      00:05:57
    • LINQ DataSource
      00:02:16
    • Summary
      00:00:50
  • LINQ to SQL Part II
    01:06:00
    • Introduction
      00:01:17
    • Modifying Data
      00:01:39
    • Identity
      00:01:09
    • Identity Map Pattern
      00:03:46
    • Identity Map Demo
      00:06:29
    • Unit of Work Pattern
      00:03:37
    • Entity Lifecycle
      00:02:09
    • Updates
      00:03:14
    • Change Tracking
      00:03:41
    • Updating Associations
      00:06:11
    • EntitySets
      00:04:01
    • Managing Associations Demo
      00:03:47
    • Inserts
      00:02:22
    • Deletes
      00:03:50
    • Concurrency
      00:06:18
    • Concurrency Violations
      00:01:15
    • Transactions
      00:03:07
    • Detached Entities
      00:03:55
    • Limitations
      00:02:59
    • Summary
      00:01:49
  • The ADO.NET Entity Framework Part I
    00:56:28
    • Introduction
      00:00:57
    • Impedance Mismatch
      00:03:09
    • The New ADO.NET
      00:02:14
    • Entity Focus
      00:02:45
    • Entity Data Model Designer
      00:05:40
    • Model Browser
      00:04:45
    • Using the Model
      00:03:54
    • Mapping Details
      00:01:10
    • EF Services
      00:02:01
    • Entity Client
      00:03:32
    • The ObjectContext
      00:01:55
    • LINQ to Entities
      00:01:10
    • Query With LINQ
      00:02:14
    • Query With Stored Procedure
      00:03:08
    • Deferred Loading
      00:05:24
    • Inserts
      00:01:41
    • Updates
      00:01:08
    • Deletes
      00:01:07
    • Entity Update Demo
      00:04:11
    • L2S versus EF
      00:03:10
    • Summary
      00:01:13
  • The ADO.NET Entity Framework Part 2
    00:45:27
    • Introduction
      00:01:07
    • ORMs and Entities
      00:01:28
    • Row Identity
      00:01:47
    • Object Identity
      00:01:29
    • Identity Maps
      00:05:16
    • Identity Map Consequences
      00:03:42
    • Unit of Work
      00:02:58
    • Entity Lifecycle
      00:01:36
    • Change Tracking
      00:02:05
    • Changing Associations
      00:05:52
    • Concurrency
      00:04:53
    • Concurrency Violations
      00:01:51
    • Transactions
      00:01:47
    • Stored Procedures
      00:03:22
    • Detached Entities
      00:04:37
    • Summary
      00:01:37
  • ADO.NET Data Services
    00:43:16
    • Overview
      00:01:05
    • Motivation
      00:04:54
    • RESTful Services
      00:02:33
    • LINQ and Data Services
      00:01:22
    • Data Service Demo
      00:03:33
    • Response Formats
      00:02:17
    • URL Options
      00:02:51
    • Ingredients
      00:01:57
    • POCO Data Source
      00:01:42
    • Configuration
      00:01:02
    • Primitive Client
      00:01:33
    • DataServiceContext
      00:01:50
    • Context Demo
      00:03:39
    • Create, Update, Delete
      00:03:22
    • Silverlight
      00:02:13
    • Interceptors
      00:03:41
    • Service Operations
      00:02:57
    • Summary
      00:00:45
Write Your Review

Reviews