LINQ Video Tutorials

Add LINQ data classes to a project

Learn ASP.NET 4.0, C# and Visual Studio 2010 Essential Skills Lesson 10-2

A basic introduction to what LINQ does and how to create LINQ to SQL classes.

Check whether a record exists using LINQ

Learn ASP.NET 4.0, C# and Visual Studio 2010 Essential Skills Lesson 10-6

How to check whether a record exists in a database by using the LINQ SingleOrDefault method and checking for a 'null' result.

Update database records using LINQ

Learn ASP.NET 4.0, C# and Visual Studio 2010 Essential Skills Lesson 10-7

How to use LINQ to change the values of database records by changing the values of LINQ objects and calling the SubmitChanges method.

Use LINQ with collections

Learn ASP.NET 4.0, C# and Visual Studio 2010 Essential Skills Lesson 10-10

How to use LINQ to extract records from any collection, allowing all collections to be treated like database tables.

Log errors to a database

Learn ASP.NET 4.0, C# and Visual Studio 2010 Essential Skills Lesson 12-3

How to log all errors that occur in your application to a database by using the Application_Error event handler in the Global.asax file.

Use LINQ anonymous types

Learn ASP.NET 4.0, C# and Visual Studio 2010 Expert Skills Lesson 9-2

How to use 'anonymous types' with LINQ to extract dynamic objects that contain a custom set of database fields.

Use the Sum and GroupBy LINQ methods

Learn ASP.NET 4.0, C# and Visual Studio 2010 Expert Skills Lesson 9-3

How to use LINQ's Sum and GroupBy methods to summarize and group data from a database.

Send SQL code through LINQ

Learn ASP.NET 4.0, C# and Visual Studio 2010 Expert Skills Lesson 9-4

How to send custom SQL queries to a database using LINQ's ExecuteQuery and ExecuteCommand methods.

Connect to a database using the SqlClient namespace

Learn ASP.NET 4.0, C# and Visual Studio 2010 Expert Skills Lesson 9-5

How to connect to a database using the classes in the SqlClient namespace. The SqlClient namespace is likely to be used in older projects.

Understand primary and foreign keys

Learn ASP.NET 4.0, C# and Visual Studio 2010 Expert Skills Lesson 6-7

An explanation of relational databases and how primary and foreign keys are used to link tables together using relationships. This information is important to understand later lessons.

Use the Average LINQ method

Learn ASP.NET 4.0, C# and Visual Studio 2010 Expert Skills Lesson 9-1

How to use LINQ's Average method to get average values from a database.

Insert database records using LINQ

Learn ASP.NET 4.0, C# and Visual Studio 2010 Essential Skills Lesson 10-8

How to insert new records into a database using LINQ by calling the InsertOnSubmit method.

Delete database records using LINQ

Learn ASP.NET 4.0, C# and Visual Studio 2010 Essential Skills Lesson 10-9

How to delete database records using the LINQ DeleteOnSubmit method.

Retrieve a single row of data using LINQ

Learn ASP.NET 4.0, C# and Visual Studio 2010 Essential Skills Lesson 10-3

How to use LINQ to retrieve a single record of data from a database table.

Retrieve multiple rows of data using LINQ

Learn ASP.NET 4.0, C# and Visual Studio 2010 Essential Skills Lesson 10-4

How to use LINQ to retrieve multiple database records using the Where method.

Sort results and call stored procedures using LINQ

Learn ASP.NET 4.0, C# and Visual Studio 2010 Essential Skills Lesson 10-5

How to sort the results of your LINQ database queries and call stored procedures using LINQ.

Use the .NET library

Learn ASP.NET 4.0, C# and Visual Studio 2010 Essential Skills Lesson 6-3

How to access different parts of the .NET framework by adding 'using' lines to your code. As an example, you will access the System.Text.StringBuilder class.