ASP.NET 4 Unleashed

Selecting with LINQ to SQL

If you want to perform a simple, unordered select, you can use the following query (assuming that you have an entity named Movie that represents the Movies database table):

No LINQ extension methods are used in this query. All the items are retrieved from the Movies table. If you prefer, you can use query syntax instead of method syntax, like this:

Selecting Particular Columns

If you want to select only particular columns, and not all the columns, from a database table, you can create an anonymous type on-the-fly, like ...