使用 HqlBasedQuery 参数化 HQL IN 子句？

Question

如何在 Nhibernate HQL 中传递“in”子句的内容列表？

例如

// data input from the user interface, not known at compile time
object[] productIds = {1, 17, 36, ... }; 
string hqlQuery = @"
                from Product as prod
                where prod.Id in ( ? )";
HqlBasedQuery query = new HqlBasedQuery(typeof(Product), hqlQuery, productIds)
ActiveRecordMediator.ExecuteQuery(query);

，现在，这行不通了，尽管我希望如此！我真的坚持做这样的事情吗：

// data input from the user interface, not known at compile time
object[] productIds = {1, 17, 36, ... }; 
string hqlQuery = @"
                from Product as prod
                where prod.Id in ( {0} )";

// build string array of the right number of '?' characters
string[] paramStringArray = new String('?', productIds.Length).ToCharArray().Select(item => item.ToString()).ToArray();
// join to make '?, ?, ?, ?, ?'
string parameterString = string.Join(", ", paramStringArray);
hqlQuery = string.Format(hqlQuery , parameterString);

HqlBasedQuery query = new HqlBasedQuery(typeof(Product), hqlQuery, productIds)
ActiveRecordMediator.ExecuteQuery(query);

这太丑了，我已经尽力让它不丑陋和短。如果有人有完成此任务的好方法，请告诉我。

我还看到 Jeff 问了一个关于如何在 SQL 上执行此操作的类似问题：参数化 SQL IN 子句< /a> 这基本上是同一个问题，我只是想知道如何从 HQL 中做到这一点。这就是为什么我让标题如此相似。

Answer 1

使用SetParameterList()。

来自 billsternberger 的代码片段.net：

ArrayList stateslist = new ArrayList();
stateslist.Add("TX");
stateslist.Add("VA");

string hql = String.Format("FROM Contact c where State in (:states)");
SimpleQuery<Contact> q = new SimpleQuery<Contact>(hql);
q.SetParameterList("states", stateslist);

Contact[] result = q.Execute();