Databases
StackOverflow2013
Postsdbo
PONHibernate: Querying with OR operator
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PONHibernate: Querying with OR operator
    primarykey
    data
    text
    <p>I am looking for a way to build an OR operator into a query to look for a particular value in one field of a table as well as in another field of a joined table. This is pretty basic in SQL, but I can't for the world figure out how to do this in NHibernate. I have been searching the web, but the examples I find are pretty nebulous to me and I find them hard to apply to my particular implementation. </p> <p>I have an class called Party, with a string-field called reference, which is the main reference. New requirements demanded the option to also being able to add a lot of side-references to a party. So I had to add another class called PartyReference that has a many-to-one relationship to Party. </p> <p>Now with a given reference I have to look its value up in both this main reference field as well as among the side references. But as long as I cannot figure out to say to NHibernate that EITHER this field must correspond to the value OR one of the others, I cannot make it work. </p> <p>I have made a workaround that looks like this, but it is inelegant and stupid, as there has to be way to say "OR": </p> <pre><code> public Party GetPartyOnAnyReference(string reference) { Party party; ISession session = Factory.OpenSession(); ITransaction tx = session.BeginTransaction(); try { //first search on main reference ICriteria criteria1 = session.CreateCriteria(typeof(Party)); criteria1.Add(Restrictions.Eq("Reference", reference)); IList&lt;Party&gt; parties1 = criteria1.List&lt;Party&gt;(); party = parties1.Count &gt; 0 ? parties1[0] : null; //then try with side-references if (party == null) { ICriteria criteria2 = session.CreateCriteria(typeof(Party)); criteria2 .SetFetchMode("References", FetchMode.Eager) .CreateCriteria("References") .Add(Expression.Eq("Reference", reference)); IList&lt;Party&gt; parties2 = criteria2.List&lt;Party&gt;(); party = parties2.Count &gt; 0 ? parties2[0] : null; } session.Close(); } catch (Exception e) { tx.Rollback(); session.Close(); if (e.GetType().ToString() == "NHibernate.ObjectNotFoundException") party = null; else throw; } return party; } </code></pre> <p>I of course realize I can also solve this issue by simply removing the main reference from the Party class alltogether and treat it on par with the other references, as a PartyReference. But at some stage I will have to use an OR query with NHibernate anyway, so I might just as well solve it now with this particular case. </p> <p>Any ideas? </p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USFedor Steeman
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PONHibernate: Querying with OR operator
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PONHibernate: Querying with OR operator
      1. USFedor Steeman
      1. VTFavorite
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload