Query Data
Introduction
To retrieve using LINQ query, the first step is to specify the data source and a variable must be declared before it can be used.
MyDatabase db = new MyDatabase();
var query =
from p in db.Members
join g in db.Groups on p.GroupId equals g.Id
select new { Name = p.Name, Group = g.Name };
query.ToList()
You can also use LINQ to Entities, e.g., to enumerate a table.
MyDatabase db = new MyDatabase();
var groups = db.Groups.ToList();
var members = db.Members.ToList();