不区分大小写QueryExpression [英] Case insensitive QueryExpression

查看:463
本文介绍了不区分大小写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屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆