UPDATE. Found a solution although I don't like it too much.

UPDATE 2. I'm going to just try NotMapped attribute instead - it worked.

Hi everybody,

I described my problem in details here

https://social.msdn.microsoft.com/Forums/en-US/196a3fd8-446a-4140-b95d-0a3f349c36b7/query-can-not-be-contsructed?forum=adodotnetentityframework

I have a model based on SQL view. This view only returns columns from the table. I extended the model with 3 extra properties. I seem to be having problems with them and EF can not generate a query.

Can you please suggest a workaround? I can only think of adding these extra properties to the view as extra empty columns, but I don't like this solution much. I'm also not 100% that '' as NewFieldName will work or I should use cast to varchar(max).