ADO.NET and LINQ

ADO.NET and LINQ

Audience

This course is intended for developers and others who need to use ADO.NET 6.0 (Visual Studio 2013) when building applications.

The class is also relevant for developers using previous versions of Visual Studio, please advise us of which version you are using when booking.

Prerequisites

Those attending should have a basic understanding of the .NET Framework and Microsoft Visual Studio and be competent in Microsoft Visual Basic or C#.

A basic understanding of relational databases and how they are structured, as well as some knowledge of SQL syntax, will be an advantage.

Duration

4 days. Hands on.

Course Objectives

On completion of this course delegates will:

  • Have received a basic introduction to databases, SQL, and ADO.NET.
  • Be able to quickly prototype database applications using Rapid Application Development (RAD) tools like data sources.
  • Know how to build 3-layer applications the ways the pros do, with presentation, business, and database classes.
  • Be familiar with LINQ (Language-Integrated Query), a .NET feature that lets developers handle all types of data using a query language that's integrated into Visual Basic and that saves a lot of ADO.NET coding. That means delegates will know how to:
    • Use LINQ to DataSet to query the data in typed or untyped datasets.
    • Use LINQ to SQL, which enables the generation of an object model from the objects in a SQL Server database that can then be used to access and update the database data.
    • Use LINQ to XML to manipulate XML data much more easily than would be possible using the Document Object Model.
    • Use LINQ data source controls with web applications.
  • Be able to work with the ADO.NET Entity Framework. This is another way to let .NET generate the code. This feature enables the creation of an Entity Data Model that defines a conceptual model for the business objects used by an application, a storage model for the objects in a database, and mappings that relate the two. Then:
    • Use LINQ or a special form of SQL to retrieve data into the business objects.
    • Work with the business objects and save changes to the database using generated code.
    • Use Entity data source controls with web applications.

Course Content

An Introduction to ADO.NET Programming
An introduction to database programming.
An introduction to ADO.NET.

How to use Data Sources and Datasets for Rapid Application Development
How to work with data sources and datasets.
How to work with bound controls and parameterized queries.
How to use the Dataset Designer.

Three-Layer Windows Forms Applications
How to work with connections, commands, and data readers.
How to work with parameters and stored procedures.
How to work with transactions.
How to work with object data sources.
A complete Payable Entry application.

How to use LINQ
An introduction to LINQ.
How to use LINQ to DataSet.
How to use LINQ to SQL.
How to use LINQ data source controls with web applications.
How to use LINQ to XML.

How to use the Entity Framework
How to create an Entity Data Model.
How to use LINQ to Entities.
How to use Entity SQL.
How to use Entity data source controls with web applications.

Public Courses

On-Site Courses

Can't attend one of our public classes? Booking for multiple people?

All our courses are available on your site! Delivered for your staff, at your premises.

Contact us to find out more...