开发者

NHibernate 3 full-text searching with table-per-subclass setup

I'm using FluentNHibernate and I have just moved to NHibernate 3.0. I have also changed my d开发者_Go百科atabase schema to a table-per-subclass configuration which I really like. We used full-text search before using MS SQL 2005's built in full-text search which worked fine because all of our content was of one class and one table. Now that our data is spread out among different subclasses/tables with different fields to be indexed on each class we will typically want one search against all subclasses. What is the best way to accomplish this and how would I query it?

We have been using Linq more lately but I would be OK with HQL.


I eventually solved this by chaining by HQL queries like this...

string selectCat = @"from Cat c where freetext((c.Name),:keyword)";
string selectDog = @"from Dog d where freetext((d.Name,d.OwnerName),:keyword)";

var animals = session.CreateQuery(selectCat).SetString("keyword", keyword).List<BaseAnimal>().Concat<BaseAnimal>(session.CreateQuery(selectDog).SetString("keyword", keyword).List<BaseAnimal>()).ToList<BaseAnimal();
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜