OK, probably a really stupid question, but why is the query being generated by Entity Framework include "SELECT 1 AS C1" at the beginning? What is this for? For example, I have the following being generated:
SELECT
1 AS C1,
"Extent1".MY_ID AS MY_ID
FROM MYTABLE "Extent1"
WHERE 'test1' = "Extent1".MY_ID
If I had written this manually I would have done something like this:
SELECT
MY_ID
FROM MYTABLE
WHERE 'test1' = MY_ID
Thanks