consider this statement:
Code: Select all
var query = DB.CompStyles
.Where( q => q.DealNumber == dealNum &&
q.JobNumber == jobNum &&
q.CycleNumber == cycleNum);
When I update entity definition and mark CounterID as NOT Primary Key, and I run the same query above and get the 3 records back, but they all point to the first record. Basically the set of 3 rows are all the same row with a same CounterID. As you can see my query is not even using the CounterID property.
The reason I tried to mark CounterID as NOT PK is to go around some other problem.
(reported here: http://www.devart.com/forums/viewtopic. ... 9997#79997)
PK for the table is: DealNumber, JobNumber, CycleNumber and CounterID
Don't you find this very strange? Thanks.