This project is read-only.

UNIQUE Column with multiple NULL values

Jul 11, 2012 at 10:33 AM

Hi,

I have the exact same scenario as described in:
http://www.databasejournal.com/features/mssql/article.php/3711501/UNIQUE-Column-with-multiple-NULL-values.htm

Is it possible to model such a scenario in nHydrate?

Jul 14, 2012 at 1:14 AM

Yes it is possible to do this. You can create a calculated field in the model and do the same thing that the article does with the database. However you cannot import a calculated field with the current version. You can set this up manually and generate; however you cannot import. This has been addressed and will be in the next version. So in summary, you can create an extra calculated column. You can add the formula specified and all should be well.