Case-sensitive columns
Hi,
Is there a way to specify that a string-type column in a table should be case-sensitive as part of the Fluent configuration and mapping?
We are autogenerating our DB schema from Fluent NHibernate for our unit tests, and there are two columns in one particular table that need to be case-sensitive. Everything else should be case-insensitive. We are using both SQL Server 2005 and SQLite in-memory.
On SQL Server, this is the code that we need to be included as part of the CREATE TABLE command:
Name nvarchar(255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
Alias nvarchar(255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
Thanks,
Tonya