search

fsprojects / SQLProvider

A general F# SQL database erasing type provider, supporting LINQ queries, schema exploration, individuals, CRUD operations and much more besides.
https://fsprojects.github.io/SQLProvider
Other
581 stars 146 forks source link

MSAccess does not like SQL generated for table names with spaces #276

Closed fwaris closed 8 years ago

fwaris commented 8 years ago

There is a table named: Order Lead Time in an Access database.

SQLProvider generates the following query: SELECT DISTINCT [t].[Brand] as [Brand] FROM ["Order Lead Time"] as [t]

Note table name has quotes.Access does not like it but likes the same query without the quotes.

Thorium commented 8 years ago

Select fixed.