MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

LINQ Data Access

Course Summary

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,


  • +

    Course Syllabus


    Course Fee:
    USD 29
    ● LINQ to XML
        ◦ Introduction
        ◦ XML Today
        ◦ Motivation for a new API
        ◦ System.XML.Linq
        ◦ Creating XML
        ◦ Saving XML
        ◦ Loading XML
        ◦ Processing XML
        ◦ Namespaces
        ◦ Traversal
        ◦ Query Operators
        ◦ Query Extensions
        ◦ Functional Construction
        ◦ Create and Query Demo
        ◦ Transformation
        ◦ Validation
        ◦ XPath
        ◦ Summary
    ● LINQ to SQL Part I
        ◦ Introduction
        ◦ Data Access Code
        ◦ Object Relational Mapping
        ◦ LINQ to SQL Overview
        ◦ POCOs
        ◦ POCO Demo
        ◦ Attributes
        ◦ The DataContext
        ◦ DataContext Demo
        ◦ SqlMetal.exe
        ◦ Relationships
        ◦ Lazy LINQ to SQL
        ◦ Data Load Options
        ◦ Projections
        ◦ Inheritance
        ◦ Compiled Queries
        ◦ Executing SQL
        ◦ Stored Procedures
        ◦ LINQ DataSource
        ◦ Summary
    ● LINQ to SQL Part II
        ◦ Introduction
        ◦ Modifying Data
        ◦ Identity
        ◦ Identity Map Pattern
        ◦ Identity Map Demo
        ◦ Unit of Work Pattern
        ◦ Entity Lifecycle
        ◦ Updates
        ◦ Change Tracking
        ◦ Updating Associations
        ◦ EntitySets
        ◦ Managing Associations Demo
        ◦ Inserts
        ◦ Deletes
        ◦ Concurrency
        ◦ Concurrency Violations
        ◦ Transactions
        ◦ Detached Entities
        ◦ Limitations
        ◦ Summary
    ● The ADO.NET Entity Framework Part I
        ◦ Introduction
        ◦ Impedance Mismatch
        ◦ The New ADO.NET
        ◦ Entity Focus
        ◦ Entity Data Model Designer
        ◦ Model Browser
        ◦ Using the Model
        ◦ Mapping Details
        ◦ EF Services
        ◦ Entity Client
        ◦ The ObjectContext
        ◦ LINQ to Entities
        ◦ Query With LINQ
        ◦ Query With Stored Procedure
        ◦ Deferred Loading
        ◦ Inserts
        ◦ Updates
        ◦ Deletes
        ◦ Entity Update Demo
        ◦ L2S versus EF
        ◦ Summary
    ● The ADO.NET Entity Framework Part 2
        ◦ Introduction
        ◦ ORMs and Entities
        ◦ Row Identity
        ◦ Object Identity
        ◦ Identity Maps
        ◦ Identity Map Consequences
        ◦ Unit of Work
        ◦ Entity Lifecycle
        ◦ Change Tracking
        ◦ Changing Associations
        ◦ Concurrency
        ◦ Concurrency Violations
        ◦ Transactions
        ◦ Stored Procedures
        ◦ Detached Entities
        ◦ Summary
    ● ADO.NET Data Services
        ◦ Overview
        ◦ Motivation
        ◦ RESTful Services
        ◦ LINQ and Data Services
        ◦ Data Service Demo
        ◦ Response Formats
        ◦ URL

    Course Type:

    Self-Study

    Course Status:

    Active

    Workload:

    1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top