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
>>
>>
>
