Title: Visual Studio C# - LINQ - LINQToDataSet
Duration: 15:19 min
Description: In this video, I am going to discuss how to user LINQ with a Dataset. We are going to
connect to Northwnd and select all the employees. Using the DataAdapter, we will fill the dataset. Then, we will use the Employees table in the dataset to display first name, last name, title and hire date on the screen.
Methodology: Using LINQ to retrieve data from a database.
Technologies: LINQ, LINQ to DataSet.
Examples constructed: We create a connection to NorthWnd database, we build a DataSet using a SQLDataAdapter. Then we use LINQ to select a subset of the employees (all the ones whose first name starts with 'M'). Finally, we enumerate over the rows and print them on the screen.
Key words: LINQ, DataSet, SQLDataAdapter, SqlConnection, SqlCommand, Fill, DataTable, IEnumerable, AsEnumerable, DataRow, StartsWith, Field, foreach.