EDMX With lambda expression with MySQL -

I am using EDMX with MySql 5.1. This is working fine when I try to execute the Lambda expression, it shows me the following error: - There is an error in your SQL syntax; To use Pass [[XYZ]], check the manual related to your MySQL server version for the correct syntax. [UserID] AS [UserID], [XZ]. [First name] A 'on line 17

Where [XYZ] is the table name and [UserID], [first name] is the column of the table, the following statement is that I want to execute I - _context.XYZSet.Where (org = & gt; org.ACDID == sbuID ||! (Org.ACDID.HasValue)). ToList ();

Please help ..

Let me know something about EDMX Do not know, but this error looks like it is using the MS SQL Server syntax to avoid table and column names, which is not supported by MySQL MySQL uses brackets for it, not square brackets .

If you can get the EDMX to avoid the names of the table and column, then you may be okay, assuming that there are no reserved words in the table / column names.