ADO.NET and LINQ

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.