Page 1 of 1

Column Names in Square Brackets

Posted: Fri 18 Mar 2016 13:44
by jcal
Hello All,

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

Thanks,
jcal

Re: Column Names in Square Brackets

Posted: Fri 18 Mar 2016 15:42
by 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?

Re: Column Names in Square Brackets

Posted: Fri 18 Mar 2016 15:47
by 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.

Re: Column Names in Square Brackets

Posted: Tue 22 Mar 2016 15:22
by 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.

Re: Column Names in Square Brackets

Posted: Mon 28 Mar 2016 17:56
by 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.

Re: Column Names in Square Brackets

Posted: Tue 26 Apr 2016 15:21
by 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.