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] -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) http://safknw.blogspot.com/ "Peace" is the Ultimate thing we want. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
