when using linq to entities the linq expression is converted to a sql query to be sent to the database. this is so that the whole table is not pulled into memory.

your problem is that because active is not mapped the database knows nothing about it and therefore cannot make the calculation.

you will either need to move active into your db or change the linq statement to only query on columns that are in your db

Related Query

More Query from same tag