In this section, we will implement a few LINQ queries that we might have to write quite often while working with a data-centric application. We will be using the following database in our application:
A database schema for the sample application
Now let's generate the Entity Data Model from this database. The generated Entity Data Model will look like the following:
A generated Entity Data Model for the sample application
Let's now take a look at how to perform some common operations on this Entity Data Model using LINQ to Entities.
Let's start by looking at executing simple queries using LINQ to Entities. The first scenario could be that we want to retrieve a list of all the data from the table. Let's try to retrieve a list of all the employees using the LINQ query syntax:
using(SampleDbEntities db = new SampleDbEntities())
{
var employees = from employee in db.Employees
select employee;
}If we...