Data Access

How to create a Data Access Layer (DAL).

• ADO.NET Data Services

  • Data Access Layers in ASP.NET Applications
  • Manually Bind a Dataset to a Datagrid
  • Work with Datasets and Filters from an ASP Application

• How Do I with LINQ

  • LINQ to SQL: Overview
  • LINQ to SQL: Data Model
  • LINQ to SQL: Querying the Database
  • LINQ to SQL: Updating the Database
  • LINQ to SQL: LinqDataSource
  • LINQ to SQL: Custom LinqDataSource
  • LINQ to SQL: Using Stored Procedures
  • LINQ to SQL: Updating with Stored Procedures
  • LINQ to SQL: Executing Arbitrary SQL

• LINQ Videos from the VB Team

  • Get Started with LINQ
  • Perform Group and Aggregate Queries
  • Upgrade Visual Basic Projects to Enable LINQ
  • Get Started with LINQ to XML
  • Enable XML IntelliSense and Use XML Namespaces
  • Create XML Documents from SQL Data
  • Create Excel Spreadsheets using LINQ to XML