why LINQ 2 SQL sometime add a field like select 1 as test, others valid fields....

Posted by Fredou on Stack Overflow See other posts from Stack Overflow or by Fredou
Published on 2010-04-21T18:46:54Z Indexed on 2010/04/21 19:43 UTC
Read the original article Hit count: 195

Filed under:

I have to concat 2 linq2sql query and I have an issue since the 2 query doesn't return the same number of columns, what is weird is after a .ToList() on the queries, they can concat without problem.

The reason is, for some linq2sql reason, I have 2 more column named test and test2 which come from 2 left outer join that linq2sql automatically create, something like "select 1 as test, tablefields"

Is there any good reason for that? how to remove this extra "1 as test" field?

here a few of examples of what it look like: google result for linq 2 sql "select 1 as test"

© Stack Overflow or respective owner

Related posts about linq-to-sql