I've got this example code...
Result = session.QueryOver<Lfee_Exc>().WhereRestrictionOn(x => x.FirstName)
.IsIn(ListOfFirstNames).List();
Is there any way to make this case insenstive or upper case x.ArNumber for my case sensitive Oracle server?
Convert ListOfFirstNames to upercase and then:
session.QueryOver<Lfee_Exc>()
.Where(Restrictions.In(Projections.SqlFunction(
"upper", NHibernateUtil.String,
Projections.Property<Lfee_Exc>(x => x.FirstName)),
ListOfFirstNames))
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With