Case-sensitive columns

Original Post Tonya's Avatar

Tonya

29 Mar, 2010 08:42 PM via web

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

    Reply to this discussion

    Preview Comments are parsed with Markdown. Help with syntax

    Attached Files

      You can attach files up to 10MB

      What is the opposite of bad?

      Recent Discussions

      05 Jul, 2010 10:29 PM
      05 Jul, 2010 12:45 PM
      05 Jul, 2010 12:42 PM
      05 Jul, 2010 12:17 PM
      05 Jul, 2010 12:12 PM

       

      03 Jul, 2010 12:26 AM
      02 Jul, 2010 02:17 PM
      02 Jul, 2010 08:18 AM
      02 Jul, 2010 12:20 AM
      01 Jul, 2010 10:14 PM