NHibernate and SQLite: will an IgnoreCase() query be an indexed lookup or not?
The Foo column is defined as "Foo TEXT 开发者_JS百科unique". Will an Eq().IgnoreCase() query use the index or will it perform a complete column scan?
The query:
string foo = "foo";
IList<T> list = session.CreateCriteria(typeof(T)).
Add(Expression.Eq("Foo", foo).IgnoreCase()).List<T>();
No. What IgnoreCase does is convert the property and parameter to lower case.
精彩评论