Column Names in Square Brackets

Discussion of open issues, suggestions and bugs regarding Entity Developer - ORM modeling and code generation tool
Post Reply
jcal
Posts: 2
Joined: Thu 17 Mar 2016 16:53

Column Names in Square Brackets

Post by jcal » Fri 18 Mar 2016 13:44

Hello All,

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

Thanks,
jcal

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Re: Column Names in Square Brackets

Post by Shalex » Fri 18 Mar 2016 15:42

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
Posts: 2
Joined: Thu 17 Mar 2016 16:53

Re: Column Names in Square Brackets

Post by jcal » Fri 18 Mar 2016 15:47

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
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Re: Column Names in Square Brackets

Post by Shalex » Tue 22 Mar 2016 15:22

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
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Re: Column Names in Square Brackets

Post by Shalex » Mon 28 Mar 2016 17:56

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
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Re: Column Names in Square Brackets

Post by Shalex » Tue 26 Apr 2016 15:21

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.

Post Reply