LINQ Data Access

Pluralsight

Course Summary

This course covers how to query objects, XML, databases, and web services using LINQ

+
Course Description

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.

Course Description

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.

+
Course Syllabus

LINQ to XML
- 58m 2s

—Introduction 0m 31s
—XML Today 3m 18s
—Motivation for a new API 2m 49s
—System.XML.Linq 1m 18s
—Creating XML 5m 57s
—Saving XML 2m 41s
—Loading XML 2m 3s
—Processing XML 6m 54s
—Namespaces 7m 10s
—Traversal 4m 54s
—Query Operators 2m 29s
—Query Extensions 2m 4s
—Functional Construction 2m 15s
—Create and Query Demo 7m 25s
—Transformation 2m 54s
—Validation 1m 10s
—XPath 0m 48s
—Summary 1m 22s

LINQ to SQL Part I
- 1h 10m

—Introduction 0m 48s
—Data Access Code 7m 6s
—Object Relational Mapping 3m 23s
—LINQ to SQL Overview 4m 38s
—POCOs 1m 36s
—POCO Demo 3m 14s
—Attributes 1m 54s
—The DataContext 4m 34s
—DataContext Demo 6m 44s
—SqlMetal.exe 2m 33s
—Relationships 4m 22s
—Lazy LINQ to SQL 7m 39s
—Data Load Options 1m 31s
—Projections 1m 43s
—Inheritance 5m 23s
—Compiled Queries 2m 33s
—Executing SQL 2m 15s
—Stored Procedures 5m 57s
—LINQ DataSource 2m 16s
—Summary 0m 50s

LINQ to SQL Part II
- 1h 6m

—Introduction 1m 17s
—Modifying Data 1m 39s
—Identity 1m 9s
—Identity Map Pattern 3m 46s
—Identity Map Demo 6m 29s
—Unit of Work Pattern 3m 37s
—Entity Lifecycle 2m 9s
—Updates 3m 14s
—Change Tracking 3m 41s
—Updating Associations 6m 11s
—EntitySets 4m 1s
—Managing Associations Demo 3m 47s
—Inserts 2m 22s
—Deletes 3m 50s
—Concurrency 6m 18s
—Concurrency Violations 1m 15s
—Transactions 3m 7s
—Detached Entities 3m 55s
—Limitations 2m 59s
—Summary 1m 49s

The ADO.NET Entity Framework Part I
- 56m 28s

—Introduction 0m 57s
—Impedance Mismatch 3m 9s
—The New ADO.NET 2m 14s
—Entity Focus 2m 45s
—Entity Data Model Designer 5m 40s
—Model Browser 4m 45s
—Using the Model 3m 54s
—Mapping Details 1m 10s
—EF Services 2m 1s
—Entity Client 3m 32s
—The ObjectContext 1m 55s
—LINQ to Entities 1m 10s
—Query With LINQ 2m 14s
—Query With Stored Procedure 3m 8s
—Deferred Loading 5m 24s
—Inserts 1m 41s
—Updates 1m 8s
—Deletes 1m 7s
—Entity Update Demo 4m 11s
—L2S versus EF 3m 10s
—Summary 1m 13s

The ADO.NET Entity Framework Part 2
- 45m 27s

—Introduction 1m 7s
—ORMs and Entities 1m 28s
—Row Identity 1m 47s
—Object Identity 1m 29s
—Identity Maps 5m 16s
—Identity Map Consequences 3m 42s
—Unit of Work 2m 58s
—Entity Lifecycle 1m 36s
—Change Tracking 2m 5s
—Changing Associations 5m 52s
—Concurrency 4m 53s
—Concurrency Violations 1m 51s
—Transactions 1m 47s
—Stored Procedures 3m 22s
—Detached Entities 4m 37s
—Summary 1m 37s

ADO.NET Data Services
- 43m 16s

—Overview 1m 5s
—Motivation 4m 54s
—RESTful Services 2m 33s
—LINQ and Data Services 1m 22s
—Data Service Demo 3m 33s
—Response Formats 2m 17s
—URL Options 2m 51s
—Ingredients 1m 57s
—POCO Data Source 1m 42s
—Configuration 1m 2s
—Primitive Client 1m 33s
—DataServiceContext 1m 50s
—Context Demo 3m 39s
—Create, Update, Delete 3m 22s
—Silverlight 2m 13s
—Interceptors 3m 41s
—Service Operations 2m 57s
—Summary 0m 45s