Spaces in Table/Column names

RusselDirks

I'm trying to use the IQ driver to connect to a MySql database. Some of the tables and column names have spaces, and the SQL code generated by the driver is not delimiting them properly. Is that a limitation of the driver, or LINQ, or do I just not have things configured properly? I'm very new to Linqpad.

JoeAlbahari

I'm fairly sure that's a limitation. I'll see whether it's easy to fix at this end.

RusselDirks

Thanks.

llambert

I was wondering if there has been any progress on this? Thanks.

cmd

I know it's been nearly six years since this post, but this is what came up when I googled...

Any chance of a fix or workaround for this? I've recently been working with a DB that's got spaces in tables/columns as well, and would love to be able to use LINQPad with it! (Besides manually writing the queries, of course )

Dluk

You can try linq2db driver

cmd

Unfortunately, linq2db is even less usable. It throws null exceptions just when it starts to build the schema.

Dluk

I see. Will appreciate if you will fill issue with details here https://github.com/linq2db/linq2db.LINQPad/issues