What is the right way of constructing an LINQ to entities query

See more:

C#

LINQ

Hi,

I am trying to get part of column 'code' and another column 'resnum' from my model named 'tabl' into a list of type 'tabl'. So I did this :

List<tabl> lsttablmaster = null;

lsttablmaster = Context.tabls.Select(r => new tabl { code = r.code.Remove(r.code.Length - 1), resnum = r.resnum }).ToList();

The above results in an Error :
"The entity or complex type cannot be constructed in a LINQ to Entities query"

If AsEnumerable() is added :

lsttablmaster = Context.tabls.AsEnumerable().Select(r => new tabl { code = r.code.Remove(r.code.Length - 1), resnum = r.resnum }).ToList();

No Error.

Here Im concerned, after reading online that if AsEnumerable() is used entire table is pulled into memory before applying the condition. Hence I want to ask what is the right way to go about this.

In what way the AsEnumerable() changes the scenario. Please suggest or point to right direction to read more. Thanks in advance.

What I have tried:

Though several links on Google points to the same error :

The entity or complex type  cannot be constructed in a LINQ to Entities query

nothing seemed more understandable to a newbie like me or I have not come across any such link.