Hi, you're using Sqlserver syntax for handling reserved words. In MySQL you use backtick` for the same, i.e.
select `t0`.`amount` etc. /Johan Sharique uddin Ahmed Farooqui skrev:
Hi, I'm using VS Express 2008, and trying to use linq with Mysql.What I have done 1. Created a db with a single table name account(fields : acct_num int, amount int) 2. created a Linqto sql file with same model as db table. 3. A page with gridview and code behind is (on page load event): MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["mysqltest"].ConnectionString); MyLinqDataContext db = new MyLinqDataContext(con); var q = from p in db.Accounts p; GridView1.DataSource = q; GridView1.DataBind(); I'm getting 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 '[t0].[amount], [t0].[acct_num] FROM [Account] AS [t0]' at line 1 I run this query in a mysql tool (HeidiSql), it gives same error. Is it due to brackets '[' ? select [t0].[amount], [t0].[acct_num] FROM [Account] AS [t0]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
