模拟SQL替换功能的NHibernate查询 [英] NHibernate Query that simulates SQL Replace Function

问题描述

我有一个电话号码字段，其中可以包含许多不同的字符，例如-". (")"等.我想搜索电话号码，但要排除特定字符.我不确定如何使用NHibernate Criteria或HQL模拟此功能.

I have a phone number field that can have lots of different characters such as "-" "." "(" ")", etc. I want to search for a phone number but I want to exclude specific characters. I'm not sure how to simulate this functionality with NHibernate Criteria or HQL.

推荐答案

我最终使用了带有SQL限制的Criteria查询.就是这样

I ended up using the Criteria query with a SQL Restriction. It was something like this

Session.CreateCriteria<EntityName>()
.Add(Restrictions.Sql(
"Replace('ColumnToSearch','PatternToFind', 'ReplaceWithValue')"))

通过Sql Restriction，您可以运行与给出的语句完全相同的sql语句.

The Sql Restriction lets you run the exact same sql statement as you give it.

这篇关于模拟SQL替换功能的NHibernate查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！