Select vs Select new in linq

Question

What's the difference b/w select and select new in linq.

var SelectNew = from L1 in liStudent select new { L1.Name, L1.ID };

var SelectNew2 = from L2 in liStudent select L2;

Answer 1

Your first one, SelectNew is returning an enumerable of anonymous types with two properties, Name and ID, whereas SelectNew2 is returning an enumerable of iiStudent entities. You'd use the first instance when you need to return a subset of the data available in the entity/model.