Course 6687: Implementing Data Access using Language Integrated Query to SQL.

Introduction This 2-hour online course provides you with the knowledge and skills to implement data access by using LINQ to SQL.

Topics covered in the course include:

• Entity classes in ADO.NET
• Methods to query databases by using LINQ to SQL
• Data modification by using LINQ to SQL

This course helps you prepare for exam 70-561 TS: Microsoft .NET Framework 3.5 - ADO.NET.

Student Prerequisites

• Three years of experience in developing Web applications, Windows-based applications, or distributed applications by using Microsoft .NET Framework 1.1 or 2.0
• Knowledge of programming in C# or Microsoft Visual Basic .NET (VB.NET)
• At least one year of experience in using Microsoft SQL Server and other relational database management systems such as Oracle, DB2, and MySQL
• Knowledge of Web services and XML
• Knowledge of stored procedures and data-bound controls

Objectives At the end of the course, students will be able to:

• Create entity classes in ADO.NET.
• Query databases by using LINQ to SQL.
• Modify data by using LINQ to SQL.

Modules & Lessons Course Overview Module Overview Navigation Overview Course Information Implementing Data Access by Using LINQ to SQL Module Overview Creating Entity Classes Querying Databases by Using LINQ to SQL Modifying Data by Using LINQ to SQL Lab: Implementing Data Access by Using LINQ to SQL Module Summary Glossary System Requirements To view this course, you need:

• A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
• Microsoft® Windows® 2000 or higher
• Microsoft Internet Explorer 6.0 or higher
• Adobe Flash 7.0 or higher (1MB disk space needed to install)
• Microsoft Silverlight 4.0 or higher
• Microsoft Windows Media Player 7.0 or higher
• Microsoft XML Core Services 3.0 or higher
• A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
• A sound card, and either speakers or headphones (for multi-media audio).
• Internet bandwidth of 56K or faster. Broadband internet access is recommended.

For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:

• Microsoft Virtual Server ActiveX control (1MB disk space needed to install)

Test your computer's capabilities to see if it supports this course. Accessibility Requirements The following software must be running on your computer in order to access this course with Screen Reader Software:

• Microsoft Internet Explorer 6.0 or higher
• Window-Eyes from GW Micro
• JAWS from Freedom Scientific
• MSAA enabled