Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
Business Analysis
Business Intelligence
Business Objects
Business Skills
C++ programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Datawarehousing
DB2
Desktop Application Software
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Microsoft technologies
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Microsoft LINQ Using Visual C# 2008
.NET Training Overview

In this course, you’ll learn to use the exciting new .NET Framework 3.5 feature, Language Integrated Query (LINQ) to easily create complex data-independent queries. In addition, you’ll learn about the new language features added to Visual C# in Visual Studio 2008 in order to make LINQ possible. You’ll start by working through a quick overview of LINQ, and how it applies to working with collections of objects, retrieving data stored in SQL Server, and creating XML content. Subsequent topics introduce new LINQ-oriented language features, LINQ to Objects, LINQ to DataSets, LINQ to SQL, LINQ to XML, and LINQ to Entities. By the time you’ve completed the course, you’ll have a good understanding of now only how to construct LINQ queries to work with data, but also how to use the features added to Visual C# that support LINQ.

.NET Training Prerequisites

A good working knowledge of .NET in general and more specifically, with programming ADO.NET. Please note that this course does not cover the fundamentals of Visual Studio 2008 or .NET Framework.

.NET Training Audience

NET programmers interested in learning the fundamentals of LINQ.

.NET Training Course duration

2 days

.NET Training Course outline

Introducing LINQ

  • Language Integrated Query
  • Data Access, Historically
  • LINQ to the Rescue
  • LINQ Providers
  • Structure of a LINQ Query
  • The Three Stages of a LINQ Query
  • Returning Multiple Values
  • Deferred Execution
  • Language Extensions for LINQ
  • LINQ and Languages
  • Implicitly Typed Local Variables and Object Initializers
  • Implicit Type Declarations
  • Object Initializers
  • Lambda Expressions, Extension Methods, and Anonymous Types
  • Lambda Expressions
  • Extension Methods
  • Anonymous Types
  • LINQ to Objects
  • Using LINQ with In-Memory Collections
  • What Can You Query?
  • Arrays
  • Generic Lists
  • Generic Dictionaries
  • Strings
  • Other Collections (Non-Generic Collections)
  • LINQ Operators and Extension Methods
  • Working with Data
  • Creating Sequences
  • Selecting Sequences
  • Retrieving a Single Element
  • Filtering Sequences
  • Ordering Sequences
  • Verifying Sequences
  • Converting Sequences
  • Positioning within Sequences
  • Calculating Sequences
  • Set Operations
  • LINQ to SQL
  • LINQ and Relational Data
  • Creating an Object Model
  • The DataContext Class
  • Entity Classes
  • Associations Between Entities
  • Querying Data
  • Simple Queries
  • Scalar Functions
  • Aggregate Functions
  • Querying Related Tables
  • Lambda Expressions
  • Extension Methods
  • Grouping
  • Joins
  • Modifying Data
  • Using Stored Procedures
  • Configuring the Update Behavior of Entity Classes
  • LINQ to SQL vs. DataSets
  • More LINQ to SQL
  • LINQ to SQL Advanced Features
  • Deferred Loading
  • Read-Only Queries
  • Compiled Queries
  • Direct Execution of Queries
  • Transactions
  • Cascading Deletes
  • Tracking Changes
  • Creating and Deleting Databases
  • Validating Data
  • Using LINQ to SQL in a Windows Applications
  • Exploring the Data Layer
  • Exploring the User Interface
  • Using LINQ to SQL in a Web Application
  • Working with Customers
  • Working with Orders
  • Working with Products
  • LINQ to DataSet
  • Review of DataSets
  • Retrieving and Modifying Data
  • Querying Data with LINQ to DataSet
  • Querying Data in Tables
  • Querying Tables in Untyped DataSets
  • Querying Tables in Typed DataSets
  • LINQ to DataSet and DataViews
  • Binding to Data
  • Convert Query Results to a List
  • Copy Query Results to a DataTable
  • Create a DataView from Query Results
  • LINQ to XML
  • Creating and Manipulating XML Content
  • Creating XML Content
  • Traversing XML
  • Updating XML Content
  • Verifying XML Content Using a Schema
  • Using LINQ to Query XML Content
  • Simple LINQ Queries
  • Anonymous Types in LINQ to XML
  • Using Extension Methods with LINQ to XML
  • LINQ to XML and Lambda Expressions
  • Transforming XML Using LINQ
  • Creating New Output
  • Filling in the Details
  • LINQ to Entities
  • Overview of the Entity Framework
  • Creating an Entity Data Model
  • The ObjectContext Class
  • Entity Classes
  • Associations Between Entities
  • Querying Data
  • Simple Queries
  • Scalar Functions
  • Aggregate Functions
  • Querying Related Tables
  • Lambda Expressions
  • Grouping
  • Joins
  • Differences Between LINQ to Entities and LINQ to SQL
  • Modifying Data
  • Using Stored Procedures
  • Configuring the Update Behavior of Entity Classes

  •  
    About us
    Contact us
    Careers at Wintrac
    Our Clients
    Why Wintrac


    Register for a free training CD-ROM drawing
    Refer a client or instructor and earn $$$


    Wintrac Inc.
    16523 SW McGwire Ct.
    Beaverton OR 97007
     
    © Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy