c# - 如何在 NHibernate Linq 查询中执行不区分大小写的字符串？

Question

如何在 NHibernate Linq 查询中进行不区分大小写的 where？

例如

//note this one doesn't work if the entry in database has lowercase
q => q.Where(entity => 
    entity.CaseInsensitiveField == DesiredField.Trim().ToUpper())

Answer 1

试试这个:

q => q.Where(entity => entity.CaseInsensitiveField.ToUpper() == DesiredField.Trim().ToUpper())

此外，我建议在查询之外设置参数:

var value = DesiredField.Trim().ToUpper();

...

q => q.Where(entity => entity.CaseInsensitiveField.ToUpper() == value)