Re: linq with mysql

2008-11-27 Thread Andy Shellam
Hi, For those not familiar with LINQ, it's a new Microsoft feature in it's .NET languages that is supposed to allow developers to write querying language (i.e. SQL) code in the same format as the .NET language (e.g. C#.) The .NET compiler will convert the code into a SQL statement - e.g. I c

Re: linq with mysql

2008-11-25 Thread Johan Höök
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 s

linq with mysql

2008-11-25 Thread Sharique uddin Ahmed Farooqui
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)