Order by column named Count of size Int64 fails

[GoogleCodeExporter]

What steps will reproduce the problem?
class Foo
{
  public long Count;
}

db.Foo.OrderBy(f=>f.Count);

What is the expected output? What do you see instead?
Valid query is generated. MySql throws syntax error

What version of the product are you using? On what operating system?
DbLinq 0.20.0.0
MySql.Data 6.4.4.0

Please provide any additional information below.
stack provided.

Original issue reported on code.google.com by itsnatet...@gmail.com on 19 Feb 2012 at 9:51

Attachments:

• mysql-stack.txt

[GoogleCodeExporter]

This is targeting MySql 5.1 though will likely repro on other versions.

Original comment by itsnatet...@gmail.com on 19 Feb 2012 at 9:59

[GoogleCodeExporter]

Also, I have not tried; but you might want to regression test against the other 
built-in names:

http://dev.mysql.com/doc/refman/5.0/en/func-op-summary-ref.html such as 

Original comment by itsnatet...@gmail.com on 19 Feb 2012 at 9:59

[GoogleCodeExporter]

Let me know if they when these get fixed

Great project :)

http://wasntnate.com/2012/02/mysql-to-linq-dblinq-bug

Original comment by itsnatet...@gmail.com on 19 Feb 2012 at 11:20