linq-to-sql

How to do Select All(*) in linq to sql

How do you select all rows when doing linq to sql?

Select * From TableA

In both query syntax and method syntax please.

Solution 
  • from row in TableA select row

    Or just:

    TableA

    In method syntax, with other operators:

    TableA.Where(row => row.IsInteresting) // no .Select(), returns the whole row.

    Essentially, you already are selecting all columns, the select then transforms that to the columns you care about, so you can even do things like:

    from user in Users select user.LastName+", "+user.FirstName