Hi, sorry for my late answer. I will try your suggestion. Thanks! Michael
On 4 Mrz., 23:59, Patrick Earl <[email protected]> wrote: > It would be nice if you could file a JIRA issue with a broken unit > test for that string comparison failure. There are instructions for > making unit tests in the intro message in jira.nhforge.org. > > Regarding your subquery with Linq, you can use Any() to do it. You'd > just write something like: > > Query<TextData>().Where(td => td.Type == 1 && > Query<TextData>().Any(td2 => td2.Type == 3 && td2.LocId == td.LocId)) > > This will translate to exists(), which IMHO is a better construct than > IN anyways. > > Patrick Earl > > On Fri, Mar 4, 2011 at 10:59 AM, mbd-team <[email protected]> wrote: > > And by the way, I have to use TextVal.Equals("24808") to have SQL > > String text_val = '24808'. > > TextVal = "24808" throws an error. > > > Michael > > > On 4 Mrz., 18:51, mbd-team <[email protected]> wrote: > >> Hi Patrick, > > >> I mean querys like this: (SQL) > > >> Select text_val from geodb_textdata where text_type=500100000 and > >> loc_id in (select loc_id from geodb_textdata where text_type=500300000 > >> and text_val='24808') > > >> Or is this possible? > > >> Michael > > >> On 4 Mrz., 18:26, Patrick Earl <[email protected]> wrote: > > >> > What do you mean by Linq does not support subqueries? In what manner? > > >> > On Fri, Mar 4, 2011 at 7:17 AM, mbd-team <[email protected]> wrote: > >> > > Hallo, > >> > > is there a chance that NH-2172 (http://216.121.112.228/browse/NH-2172) > >> > > gets fixed in the next release? I would like to use QueryOver or Linq > >> > > from Visual Basic but either have there limitations: > >> > > Linq - no support fpr subquerys > >> > > QueryOver - no support for strings from VB. > > >> > > This is a real show stopper for visual basic users. > > >> > > Best regards > > >> > > Michael > >
