Column Names in Square Brackets

[jcal]

Hello All,

Is there a way to put all column names in square brackets by default?

Thanks,
jcal

[Shalex]

Please specify:
1) the ORM framework (Entity Framework / NHibernate / LinqConnect) you are working with
2) your target database server (e.g., SQL Server)
3) have you encountered any case when Entity Developer doesn't quote some table/column name and this leads to error or incorrect behaviour?

[jcal]

1. NHibernate
2. SQL Server 2014
3. Yes, when a column was named Order. We got a "primary key violation
id 1 already exists" error. Any name with a space or that is a reserved word will break the FluentMappings.

[Shalex]

We cannot reproduce the issue ([Order] is quoted by Entity Developer in our test).

Could you please send us a test model for reproducing? Also specify the steps we should follow using it in our environment.

[Shalex]

Thank you for the test project. The bug with quoting column names which contain a space or that are reserved words by the Fluent NHibernate template is fixed. We will notify you when the corresponding build of Entity Developer is available for download.

[Shalex]

The bug with quoting column names which contain a space or that are reserved words by the Fluent NHibernate template is fixed in the newest (5.8.841) build of Entity Developer: http://forums.devart.com/viewtopic.php?f=32&t=33578.