|
Post by Adam Jackson on Jun 30, 2008 9:20:07 GMT -5
Hi,
This SQL works OK (counts number of instances in a column)
select _1,count(_1) as Num from routes group by _1
but Linqer gives
SQL syntax error: Each GROUP BY expression must contain at least one column reference.
Any thoughts?
Thanks
|
|
|
Post by Mikhail Oumantsev on Jul 2, 2008 0:07:32 GMT -5
Hello Adam, I replaced column "_1" to "employeeid" and table "routes" to "employees" to be able to run your example under Northwind database. The similar SQL conversion works ok. select employeeid,count(employeeid) as Num from employees group by employeeid
It is possible that column "_1" is not found in your *.dbml file. Try to regenerate *.dbml file. If you still have a problem please send me your *.designer.cs and *.dml files and I will debug this situation. My email is admin@sqltolinq.com
Regards, Mikhail.
|
|