Filtering more than one value using Nhibernate criterian in C#

Question

I am using criterion Restrictions of nHibernate in my c# code to filter based on specific values. At the moment I am not able to filter more than one. I have tried a couple of options but they don't work. I basically want to filter both LiquidityCoverageRatio and Basel. How do I do that

 public IList<AldbReport> FindAllByReportSet(AlEtlRunContext runContext, string reportSet)
        {

            reportSet = reportSet == "LiquidityCoverageRatio" ? "LiquidityCoverageRatio || Basel" : "";
            //reportSet1 = reportSet == "Basel" ? "LiquidityCoverageRatio" : "";

            var criteria = CreateCriteria(runContext)
                .Add(Restrictions.Eq("ReportSet",  reportSet))
                //.Add(Restrictions.Eq("ReportSet", reportSet1))
                .AddOrder(Order.Asc("Name"));

            return criteria.List<AldbReport>();
        }

I have tried the following options

  reportSet = reportSet == "LiquidityCoverageRatio" ? "LiquidityCoverageRatio || Basel" : "";
  reportSet = reportSet == "LiquidityCoverageRatio" ? "LiquidityCoverageRati,Basel" : "";

and also two restrictions where reportSet1 would be the second value

.Add(Restrictions.Eq("ReportSet",  reportSet))
.Add(Restrictions.Eq("ReportSet", reportSet1))

question from:https://stackoverflow.com/questions/65647825/filtering-more-than-one-value-using-nhibernate-criterian-in-c-sharp

Answer 1

string reportSet1 = reportSet == "Basel" ? "LiquidityCoverageRatio" : "";

            var criteria = CreateCriteria(runContext)
                .Add(Restrictions.Or(
                    Restrictions.Eq("ReportSet",  reportSet),
                    Restrictions.Eq("ReportSet", reportSet1)
                    ))
                .AddOrder(Order.Asc("Name"));

            return criteria.List<AldbReport>();