UNIQUE Column with multiple NULL values

Jul 11, 2012 at 9: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?

Coordinator
Jul 14, 2012 at 12: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.