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

Question

Hi

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

Select * From TableA

In both query syntax and method syntax please.

Thanks

Answer 1

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

Answer 2

Do you want to select all rows or all columns?

Either way, you don't actually need to do anything.

The DataContext has a property for each table; you can simply use that property to access the entire table.

For example:

var allOrders = context.Orders;

foreach(var order in allOrders) {
    //Do something
}

Answer 3

using (MyDataContext dc = new MyDataContext())
{
    var rows = from myRow in dc.MyTable
               select myRow;
}

OR

using (MyDataContext dc = new MyDataContext())
{
    var rows = dc.MyTable.Select(row => row);
}

Answer 4

Dim q = From c In TableA Select c.TableA

ObjectDumper.Write(q)