LINQ Data Access
This course covers how to query objects, XML, databases, and web services using LINQ
What you'll learn
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.
Table of contents
- Introduction 1m
- XML Today 3m
- Motivation for a new API 3m
- System.XML.Linq 1m
- Creating XML 6m
- Saving XML 3m
- Loading XML 2m
- Processing XML 7m
- Namespaces 7m
- Traversal 5m
- Query Operators 2m
- Query Extensions 2m
- Functional Construction 2m
- Create and Query Demo 7m
- Transformation 3m
- Validation 1m
- XPath 1m
- Summary 1m
- Introduction 1m
- Data Access Code 7m
- Object Relational Mapping 3m
- LINQ to SQL Overview 5m
- POCOs 2m
- POCO Demo 3m
- Attributes 2m
- The DataContext 5m
- DataContext Demo 7m
- SqlMetal.exe 3m
- Relationships 4m
- Lazy LINQ to SQL 8m
- Data Load Options 2m
- Projections 2m
- Inheritance 5m
- Compiled Queries 3m
- Executing SQL 2m
- Stored Procedures 6m
- LINQ DataSource 2m
- Summary 1m
- Introduction 1m
- Modifying Data 2m
- Identity 1m
- Identity Map Pattern 4m
- Identity Map Demo 6m
- Unit of Work Pattern 4m
- Entity Lifecycle 2m
- Updates 3m
- Change Tracking 4m
- Updating Associations 6m
- EntitySets 4m
- Managing Associations Demo 4m
- Inserts 2m
- Deletes 4m
- Concurrency 6m
- Concurrency Violations 1m
- Transactions 3m
- Detached Entities 4m
- Limitations 3m
- Summary 2m
- Introduction 1m
- Impedance Mismatch 3m
- The New ADO.NET 2m
- Entity Focus 3m
- Entity Data Model Designer 6m
- Model Browser 5m
- Using the Model 4m
- Mapping Details 1m
- EF Services 2m
- Entity Client 4m
- The ObjectContext 2m
- LINQ to Entities 1m
- Query With LINQ 2m
- Query With Stored Procedure 3m
- Deferred Loading 5m
- Inserts 2m
- Updates 1m
- Deletes 1m
- Entity Update Demo 4m
- L2S versus EF 3m
- Summary 1m
- Introduction 1m
- ORMs and Entities 1m
- Row Identity 2m
- Object Identity 1m
- Identity Maps 5m
- Identity Map Consequences 4m
- Unit of Work 3m
- Entity Lifecycle 2m
- Change Tracking 2m
- Changing Associations 6m
- Concurrency 5m
- Concurrency Violations 2m
- Transactions 2m
- Stored Procedures 3m
- Detached Entities 5m
- Summary 2m
- Overview 1m
- Motivation 5m
- RESTful Services 3m
- LINQ and Data Services 1m
- Data Service Demo 4m
- Response Formats 2m
- URL Options 3m
- Ingredients 2m
- POCO Data Source 2m
- Configuration 1m
- Primitive Client 2m
- DataServiceContext 2m
- Context Demo 4m
- Create, Update, Delete 3m
- Silverlight 2m
- Interceptors 4m
- Service Operations 3m
- Summary 1m
About the author
Scott has worked on everything from 8-bit embedded devices to large scale web sites during his 15+ years in commercial software development. Since 2001, Scott has focused on server-side and web technologies, like ASP.NET, ASP.NET AJAX, Windows Workflow, Silverlight, and LINQ. Scott is also a speaker at national conferences like VSLive!, as well as code camps and user groups near his hometown of Hagerstown, MD. Scott has been recognized as a Microsoft MVP since 2005, and has written or co-... more