Mahindra Satyam Learning World
Course Language-Integrated Query Code Phase 2 (Advanced) Duration (Hrs) <12> Prerequisites Participants need to have prior knowledge/skill of Developing applications with 3.0/3.5 The basic concepts of Object-Oriented Programming, Delegates, Generics, Collections, AutoImplemented Properties, Object Initializers, Collection Initializers, Extension Methods, Implicit Typing, Anonymous Types, Microsoft’s .NET strategy and the .NET framework. Working with Microsoft Windows 2000, XP, or Vista. Course Objectives On completion of the course the learner will be able to demonstrate concepts and skills in Introduction to LINQ LINQ to Arrays and Collections LINQ to XML (XLINQ) LINQ to DataSets LINQ to SQL Server Database (DLINQ)
S.#
Learning Objectives
Course Plan- Language-Integrated Query
Points to Cover
Concept Type*
Delivery Method#
Page 1 of 3
Hrs
Mahindra Satyam Learning World a. b.
1.
Introduction to LINQ
c. d. e. f. g. a. b.
2.
LINQ to Arrays and Collections
c. d.
a.
3.
LINQ to XML
b.
a. b. 4.
LINQ to Datasets
a. b. c. 5.
LINQ to SQL Server Database objects
d. e.
Collaterals Details Collaterals Deployed Virtual learning Case studies
Query Expression Basics LINQ Query Expressions or Standard Query Operators ‘from’ operator ‘where’ operator ‘select’ operator ‘orderby’ operator Internal representation of LINQ Query operators LINQ and Arrays LINQ and Generic Collections LINQ and Nongeneric Collections Take<>(), Skip<>(), TakeWhile<>(), SkipWhile<>(), Distinct<>() operators Filtering data in XML documents using LINQ query operators. Manipulating XML Documents using LINQ to XML.
The role of LINQ to ADO.Net Programming with LINQ to DataSet.
Programming with LINQ to SQL. Generating Entity Classes using SqlMetal.exe Building Entity Classes Using Visual Studio 2008. Implementing DML operations using DataContext. Invoking stored procedures using DataContext.
C3
<1>
C3
<2>
C3
<3>
C3
<2>
C3
<4>
Collateral Available Path \\hstslc006\SLW_TECH\Streams- Collaterals\MS.Net \\hstslc006\SLW_TECH\Case Studies
Resources Required (With Version Number) Windows OS (Windows XP/Vista is recommended) Visual Studio 2008 Standard Edition with Service Pack1 References http://msdn.microsoft.com/en-us/library/bb397676.aspx Version History Version # Date 1.0
Created/Changed by Changes made
31-Dec- Veerendra Kumar 08 Ankem
Reviewed by
Srikanth Nivarthi
*Concept Type C1 - Factual knowledge: The basic elements that associates must know and understand Course Plan- Language-Integrated Query
Page 2 of 3
Mahindra Satyam Learning World C2 - Conceptual knowledge: The interrelationships among the basic elements within a large structure that enable them to function together. C3 - Procedural Knowledge: How to do something; methods of inquiry and criteria for using skills, algorithms, techniques and methods. #Delivery Method CL - Class Room Learning CS - Case Study Learning PB - Problem Based Learning VL - Virtual Learning
Course Plan- Language-Integrated Query
Page 3 of 3