Good job, thanks Pablo; I agree with your changes.
I think we may release the version 0.18 this week-end (if no one disagrees).
On Fri, Sep 12, 2008 at 20:50, Pablo Iñigo Blasco <[EMAIL PROTECTED]> wrote:
> I also would want to say that the following problem was solved by revision
> 863:
>
> from c in db.Customers
> select new { c.CustomerID, HasUSAOrders = c.Orders.Count(o => o.ShipCountry
> == "USA") }
>
> before the commit it was translated to sql as:
> SELECT c$.[CustomerID], SELECT COUNT(*)
> FROM [dbo].[Orders] o$
> WHERE c$.[CustomerID] = o$.[CustomerID] AND o$.[ShipCountry] = 'USA'
> FROM [dbo].[Customers] c$
>
> It failed because parentheses were needed
> After the commit, the query is translated as:
>
> SELECT c$.[CustomerID], (SELECT COUNT(*)
> FROM [dbo].[Orders] o$
> WHERE c$.[CustomerID] = o$.[CustomerID] AND o$.[ShipCountry] = 'USA')
> FROM [dbo].[Customers] c$
>
> A set of test with this problem can be found in Read_AnyCount.cs file in
> test projects.
>
> Regards.
>
> >
>
--
Pascal.
jabber/gtalk: [EMAIL PROTECTED]
msn: [EMAIL PROTECTED]
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"DbLinq" 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/dblinq?hl=en
-~----------~----~----~----~------~----~------~--~---
