c# - Fluent NHibernate - How to create a unique index on Upper(column)? -


i'm working oracle 12.1 db.

i need column case insensitive. e.g. if may table contain 'name' column, , inserted row containing "test1" value, when trying insert "test1" fail.

the following sql command trick:

create unique index name_idx on mytable ( upper(name));

the question - how accomplish using fluentnhibernate (c#) ?

map(x => x.name).unique(); // create unique constraint, case sensitive...

also - i'd appreciate input performanece of such index thanks


Comments

Popular posts from this blog

qt - QML MouseArea onWheel event not working properly when inside QML Scrollview -

java - is not an enclosing class / new Intent Cannot Resolve Constructor -

python - Error importing VideoFileClip from moviepy : AttributeError: 'PermissionError' object has no attribute 'message' -