When you have a table containing a lot of columns you will probably want to design a query which returns a subset of these. To reduce typing i imagine that i in the datagrid multiselects the columns i want. Ctrl C and then Ctrl V in the query text. Pasted text would be ".Select(t=> new {t.col1, t.col2})"