LINQ To SQL - Executing Text Queries
Executing text queries with LINQ is simple as that...
Assuming you have Adventure Works Database installed.
public void DoExecuteQuery()
{
AdventureWorksDataContext aw = new AdventureWorksDataContext();
IEnumerable<Employee> employees =
aw.ExecuteQuery<Employee>("SELECT * FROM HumanResources.Employee");
foreach (Employee e in employees)
{
Console.WriteLine(e.Title);
}
}