Hi Fabio,
SELECT
this_.Id as Id37_1_,
this_.FromDate as FromDate37_1_,
this_.ToDate as ToDate37_1_,
this_.Comment as Comment37_1_,
this_.CustomerInfo as Customer5_37_1_,
externalsy1_.Id as Id12_0_,
externalsy1_.Code as Code12_0_,
externalsy1_.Description as Descript3_12_0_
FROM AuditLogDb.dbo.ExternalSystemStatusInfo this_
left outer join AuditLogDb.dbo.ExternalSystem externalsy1_
on this_.Id=externalsy1_.Id
WHERE
((this_.FromDate > '27.04.2009 15:06:21'
and (this_.ToDate < '27.06.2009 15:06:21' or this_.ToDate is null))
and externalsy1_.Code = 'TrustIdent')
ORDER BY this_.FromDate asc;
Both dates comes from properties on the entity.
Thanks for helping out,
-Mark
On Thu, May 28, 2009 at 8:23 PM, Fabio Maulo <[email protected]> wrote:
> 2009/5/28 Mark Nijhof <[email protected]>
>>
>> Sorry that only applies to the mappings of course. We are using Linq
>> to access the data and regular save for saving.
>
> can you send the SQL log ?
> --
> Fabio Maulo
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
