How can I resolve this exeception

See more:

MySQL

MySQL-Connector

, +

Hello all,

i try to do sum of row of my database.

i have this error :

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'float)

this is my query :

<pre>                System.Nullable<float> totalUnitsOnOrder =
    (from prod in dbcontext.Votes
     where prod.BvId == bureauvote
     select (float)prod.NbrVoix)
    .Sum();

i use mysql from cpanel, and mysql server version is 5.6

What I have tried:

i have try other way to do that , but same error

way 1 :

<pre>                var res = dbcontext.Votes.Where(v => v.BvId == bureauvote);
                var result = res.AsQueryable().Sum(r => r.NbrVoix);

and this :

var res = dbcontext.Votes.Where(v => v.BvId == bureauvote).Sum(v => v.NbrVoix);

but always the same error. can you help me please.

thanks you all