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

Assuming TableA as an entity of table TableA, and TableADBEntities as DB Entity class,

1. LINQ Method

IQueryable<TableA> result;
using (var context = new TableADBEntities())
{
   result = context.TableA.Select(s => s);
}

2. LINQ-to-SQL Query

IQueryable<TableA> result;
using (var context = new TableADBEntities())
{
   var qry = from s in context.TableA
               select s;
   result = qry.Select(s => s);
}

Native SQL can also be used as:

3. Native SQL

IList<TableA> resultList;
using (var context = new TableADBEntities())
{
   resultList = context.TableA.SqlQuery("Select * from dbo.TableA").ToList();
}

Note: dbo is a default schema owner in SQL Server. One can construct a SQL SELECT query as per the database in the context.

I often need to retrieve 'all' columns, except a few. so Select(x => x) does not work for me.

LINQPad's editor can auto-expand * to all columns.

after select '* all', LINQPad expands *, then I can remove not-needed columns.

Simple -

var data=db.table.ToList();

data is variable

db is your dbcontext variable

table is dbset Table from which data you want to fetch.

And finally converting in list.