Fluent NHibernate Column Mapping with Reserved Word

Question

I've read that using a back tick ` should allow for using of reserved words. I'm using SQL Server and Fluent NHibernate and have a column name "File". If I map it with

"`File"

it tries using

[Fil]

so it's adding the brackets correctly, but dropping the "e" from the end. If I map it as

"`Filee"

it uses

[File]

correctly.

Am I doing something wrong or is this a bug in NHibernate or Fluent Nhibernate?

Have you tried with out doing any thing with the fluentNHibernate. If you export the hbm file fluentNHibernate will write table="`File`" for you. — Aaron Fischer, Oct 09 '09 at 23:06

Matthew Talbert · Accepted Answer · 2015-07-06T21:56:38.090

24

You need to put ` on both sides, like this:

"`File`"

As @Astaar says, the full syntax is:

Map(x => x.File).Column("`File`");

edited Jul 06 '15 at 21:56

answered May 21 '10 at 04:44

Matthew Talbert

5,998
35
38

Oh my that took a long time for an answer. Thank you! – Josh Close May 21 '10 at 13:14
Square brackets also work: Map(x => x.File).Column("[File]"); – Chronozoa May 27 '15 at 18:55
@Chronozoa do you know if that's a recent addition? I swear I tried that way back in 2010 when I answered this question and it didn't work. – Matthew Talbert Jul 06 '15 at 21:55
@MatthewTalbert I do not know. I am still very new to nHibernate. – Chronozoa Jul 24 '15 at 19:05
Square brackets did not work, backticks _did_ work for us. NHibernate 5.2.6, FluentNHibernate 2.1.2. These posts are gold when working with old stuff. – Arve Systad Aug 08 '23 at 08:45

score 5 · Answer 2 · answered Mar 28 '13 at 18:55

5

To be perfectly clear, the exact syntax would be

Map(x => x.File).Column("`File`");

answered Mar 28 '13 at 18:55

Astaar

5,858
8
40
57

score 5 · Answer 3 · edited May 23 '17 at 12:02

5

There are non manual configuration options for this as covered here: NHibernate: forcing square brackets in schema export?

as well as an alternative: Fluent NHibernate and PostgreSQL, SchemaMetadataUpdater.QuoteTableAndColumns - System.NotSupportedException: Specified method is not supported

E.g. SchemaMetadataUpdater.QuoteTableAndColumns(cfg) which in FluentNhibernate would look something like

var config = Fluently.Configure()
   ...
   ...
   .ExposeConfiguration(cfg => SchemaMetadataUpdater.QuoteTableAndColumns);

edited May 23 '17 at 12:02

Community

1
1

answered Mar 02 '15 at 10:26

Daniel

8,133
5
36
51

1

I think this solution is better because it's a one time setting instead of adding all new column names being reserverd words specifically in each map. – Sebastian Ballarati Oct 05 '17 at 20:56

Fluent NHibernate Column Mapping with Reserved Word

3 Answers3

Linked