Maybe, this is an Off-Topic Steve. There is a problem in the new linq
provider within an scenario like this:

invoices.Where(i => i.Date == null)

is failing because it generates a:

select .... from invoice where invoice.Date = null

instead of :

select .... from invoice where invoice.Date is null

2009/10/29 José F. Romaniello <[email protected]>

> Maybe, this is an Off-Topic Steve. There is a problem in the new linq
> provider within an scenario like this:
>
> invoices.Where(i => i.Date == null)
>
> is failing because it generates a:
>
> select .... from invoice where invoice.Date = null
>
> instead of :
>
> select .... from invoice where invoice.Date is null
>
>
>
>
> 2009/10/29 Steve Strong <[email protected]>
>
> I believe this should work just fine in the new Linq provider that's in the
>> trunk.  I assume that you're using the criteria-based provider with the
>> latest release?
>>
>> Steve
>>
>> Twitter <http://twitter.com/srstrong>
>> Blog <http://blogs.imeta.co.uk/sstrong>
>> NHibernate Professional 
>> Support<http://www.imeta.co.uk/professional_nhibernate_support.aspx>
>>
>>
>> On 28 Oct 2009, at 15:42, Fabio Margarito wrote:
>>
>>
>> Some tip?
>>
>> On 27 out, 23:08, Fabio Margarito <[email protected]> wrote:
>>
>> Hi all,
>>
>>
>> I trying to do the follow query using Linq to NHibernate. The question
>>
>> is, is it possible?
>>
>>
>> var client = from query in sessao.Linq<Cliente>() where
>>
>> query.DataVencimento.Day  == DateTime.Now.Day  select query;
>>
>>
>> and i get de error
>>
>>
>>  NHibernate.QueryException: could not resolve property:
>>
>> DataVencimento.Day of: AcionistaNet.AMA.Cobranca.Cliente.
>>
>>
>> I think would be necessary some parser to use a related function in
>>
>> SQL SERVER, and at this moment we don't have implemented. am I
>>
>> correct?
>>
>>
>> []'s
>>
>> Fabio Margarito
>>
>>
>>
>>
>>
>> >>
>>
>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to