不区分大小写QueryExpression [英] Case insensitive QueryExpression
本文介绍了不区分大小写QueryExpression的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
是否有可能建立一个ConditionExpression的查询是不区分大小写?
Is it possible to build a query with a ConditionExpression which is not case sensitive ?
ConditionExpression condition = new ConditionExpression()
{
AttributeName = "lastname",
Operator = ConditionOperator.BeginsWith,
Values = new ObservableCollection<object>() { searchName }
};
在这个例子中,我想与searchName搜索是不区分大小写。
In this example I would like the search with searchName to be case insensitive.
推荐答案
我认为,这是被选定在安装CRM,而不是QueryExpression的一个特征数据库排序规则的一个因素。
I believe that this is a factor of the database collation that was chosen during install of CRM rather than a feature of QueryExpression.
在一个干净的默认安装的是 Latin1_General_CI_AS
。
The default during a clean install is Latin1_General_CI_AS
. You can check yours by executing the following sql statement:
SELECT DATABASEPROPERTYEX('OrganisationName_MSCRM', 'Collation')
这篇关于不区分大小写QueryExpression的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文