dotConnect 8.3.146: Count in subquery breaking
Posted: Tue 13 May 2014 17:24
Hi,
I just upgraded to dotConnect 8.3.146(Trial version) from 6.80. (I had to upgrade in order to fix the issue mentioned at http://forums.devart.com/viewtopic.php?f=1&t=29443.)
I am using VS 2010, EF 4.1 and .Net Framework 4
I ran into this breaking change:
The following query, which was working fine in 6.80, is now showing incorrect results.
The "StateLicenses1" property returns "1" for all non-zero counts. It should return the actual count of child rows in the "StateLicenseHistoryEntities" table.
I read the release history but did not find anything regarding this change.
Am I missing something or have I stumbled into another ugly bug?
~Mayank
I just upgraded to dotConnect 8.3.146(Trial version) from 6.80. (I had to upgrade in order to fix the issue mentioned at http://forums.devart.com/viewtopic.php?f=1&t=29443.)
I am using VS 2010, EF 4.1 and .Net Framework 4
I ran into this breaking change:
The following query, which was working fine in 6.80, is now showing incorrect results.
Code: Select all
var lstUsers = (from cu in UserEntities
select new
{
user = cu,
StateLicenses1 = (from sl in StateLicenseHistoryEntities
where cu.UID == sl.UserUID
select sl).Count()
}).ToList();
I read the release history but did not find anything regarding this change.
Am I missing something or have I stumbled into another ugly bug?
~Mayank