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 ...
Get ASP.NET 4 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
