How to retrieve only one field from a table with many fields using Linq query and EF

Question

I have a table with various fields and I would like to know how to retrieve only one of those fields using linq and put them to list?

var st = context.myTable.FirstOrDefault.ToList

`var st = context.myTable.Select(x => x.SomeProperty);` – Jun 23 '15 at 06:53 — , Jun 23 '15 at 06:53

score 3 · Answer 1 · edited Jun 23 '15 at 09:26

3

Try this

var st = context.myTable.Select(x => x.SomeProperty).ToList();

edited Jun 23 '15 at 09:26

Alireza

answered Jun 23 '15 at 06:53

Mukesh Kalgude

1 Answers1