alexandis commented on "Working Around Performance Issues in LINQ to SQL and SQL CE 3.5"

alexandis — Mon, 21 Sep 2015 11:58:37 GMT

Good point, but i've got problem with more complex query. Column names do not match and I cannot get rid of singlerowtable part, which causes SQL exception:

CASE WHEN (0 = "Join4"."OBJECT_ID") THEN 0 ELSE "Join4"."OBJECT_ID" END AS "C1"

even though i write:

select new
{
secureObject,
SecureId = pr.RelatedObjectId == 0 ? 0 : pr.RelatedObjectId
};

Actually SecureId is property for secureObject, that is bound to "SEC_ID" column. I don't have idea, how to point this out for LINQ...

Comments on "Working Around Performance Issues in LINQ to SQL and SQL CE 3.5"

alexandis commented on "Working Around Performance Issues in LINQ to SQL and SQL CE 3.5"