HQL select where object1.list<object2>[0...n].Id = giv

本文关键字：giv Id object2 where select object1 list HQL lt gt | 更新日期: 2023-09-27 18:18:58

我有一个类Transaction，它的参数之一是List of Tag Tags

我想按TagId选择交易列表?

类似这样的东西(我的查询显然是错误的在WHERE子句…:

transactionList = session.CreateQuery("FROM Transaction TR WHERE TR.Tags.TagId =: id")
.SetInt32("id", tId)
.List<Transaction>();

HQL select where object1.list<object2>[0...n].Id = giv

试试这个:

transactionList = session.CreateQuery(
    @"SELECT TR 
      FROM Transaction TR 
      JOIN TR.Tags T 
      WHERE T.TagId = :id")
.SetInt32("id", tId)
.List<Transaction>();