NHibernate Naming Conventions - Eliminate Keyword Conficts

Question

How do I escape keyword conflicts when NHibernate generates my column names using FluentNHibernate?

NHibernate generated this for me and "Key" is a conflict.

create table Setting (
       Key NVARCHAR(MAX) not null,
       Value NVARCHAR(MAX) null,
       primary key (Key)
)

Answer 1

Try this:

create table Setting (
       [Key] NVARCHAR(MAX) not null,
       Value NVARCHAR(MAX) null,
       primary key (Key)
)

SQL Server allows you to escape reserved words by putting square brackets around the text.

Answer 2

I was able to create conventions.