DevForce Community Forum : Incorrect record count on query

Incorrect record count on query : I found the problem but I don't...

Mon, 04 Oct 2010 10:48:06 -700

Author: rclarke
Subject: 2212
Posted: 04-Oct-2010 at 10:48am

I found the problem but I don't know if this is a bug or not. I noticed that when the table was imported, there is no primary key assigned even though Access had one defined. Once I updated the imported table to have a primary key the query works. I know that every table should have a primary key but is it an absolute requirement? Is this a possible EF or DevForce issue

Incorrect record count on query : Have you tried querying the Table...

Mon, 04 Oct 2010 09:26:03 -700

Author: midnit
Subject: 2212
Posted: 04-Oct-2010 at 9:26am

Have you tried querying the Table directly through EF? Or use the model editor to query. Does the table have any joins [associations] in the model? Perhaps it joined incorrectly. I would test the results of just using EF, if those are correct then move to DevForce. Querying the database yourself means you are creating the query and thereby doesn't necessarily use the query that EF will.

I would also turn detailed logging on in devforce that way you can see the query string its [EF] using.

Edited by midnit - 04-Oct-2010 at 9:28am

Incorrect record count on query : I have a wierd problem with one...

Mon, 04 Oct 2010 08:24:08 -700

Author: rclarke
Subject: 2212
Posted: 04-Oct-2010 at 8:24am

I have a wierd problem with one table in my database. The table was created within SQL Server Management Studio by importing data from an Access database. A query from within Management Studio show 48645 records in the table. After updating my model from the database the new table is added and I save and build. When I access this table through DevForce I only get 4 records retruned. Using SQL Server Express 2008 R2 and Devforce 6.0.4.0 The code I use is as follows:

'Dim ticketsQuery = _mgr.EntityMgr.Tickets
'Dim ticketsCollection As New ObservableCollection(Of Ticket)
'ticketsQuery.ForEach(Sub(t) ticketsCollection.Add(t))
' Dim accessTicketsQuery = _mgr.EntityMgr.AccessTickets.Where((Function(t) t.TicketDate >= BeginDate And t.TicketDate <= EndDate))
Dim accessTicketsQuery = _mgr.EntityMgr.AccessTickets
 _ticketsFromAccess.Clear()
accessTicketsQuery.ForEach(Sub(t) _ticketsFromAccess.Add(t))
AccessTicketCount = _ticketsFromAccess.Count

Note that the commented code was a test I did to see if this problem exists for another table and when executed that code produced

the proper number of records.

I've looked at logs and SQL Profiler and everything seems OK so how do I debug this issue?