R – Fluent NHibernate Column Mapping with Reserved Word

fluent-nhibernatenhibernate

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?

Best Answer

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

"`File`"

As @Astaar says, the full syntax is:

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