How to quote identifiers with LINQPad + IQ Driver + MySQL?

Question

I'm working with a rather horrible schema designed by an external party and it contains a table named order so when I invoke a query that references this table in LINQPad I get a SQL syntax error.

I know how to quote the identifier in MySQL, but I can't see how to do this with LINQPad and the IQ Driver. Looking at this it seems to be up to the driver implementation.

Having the same problem with a table named `keys`. – angularsen Mar 02 '13 at 21:23 — angularsen, Mar 02 '13 at 21:23
Similar problem, but with column names: 'fulltext' – Thomas Materna Mar 06 '13 at 21:45 — Thomas Materna, Mar 06 '13 at 21:45

score 0 · Answer 1 · answered Dec 11 '13 at 20:28

0

Have you tried using the backtick (`) to quote the tablename?

select * from `order`

If that doesn't work you may have to configure quoteIdentifiers as described here.

answered Dec 11 '13 at 20:28

Digital Chris

6,177
1
20
29

How to quote identifiers with LINQPad + IQ Driver + MySQL?

1 Answers1