LINQ Queries
The following example performs a simple query for every Leads record whose FirstName equals "Bob":
using System.Linq;
//...
SimpleDBEntities context = new SimpleDBEntities();
var LeadsQuery = from Leads in context.Leads
where Leads.FirstName == "Bob"
orderby Leads.FullName
select Leads;
foreach(var result in LeadsQuery) {
Console.WriteLine("{0} {1} ", result.Id, result.FullName);
}