LINQ - Not returning the same value as SQL Server

Question

I have a really weird issue.

I have this query:

var systemAppEntityViewModelFieldCustom_SecurityByUserList = (from t in coreEntityModel.SystemAppEntityViewModelFieldCustom_SecurityByUser
                where (t.SystemAppUserID == CurrentSystemAppUser.SystemAppUserID)
                    && (t.SystemCultureID == CurrentSystemAppUser.SystemCultureID)
                select t).ToList();

Producing these values for the field "CustomFilterID":

enter image description here

As you can see, "CustomFilterID" = 1 for all 4 items, but when i check SQLProfiler and a run the result query in SQLServer, i get this:

enter image description here

A variation of "CustomFilterID" = 1 AND 2.

Any idea why LINQ will produce all 4 items with a "CustomFilterID" = 1?

I have had this problem when the primary key on the model is not setup correctly, check that first. — Richard Friend
– Richard Friend, Commented May 21, 2013 at 8:33
Can you list the values of coreEntityModel.SystemAppEntityViewModelFieldCustom_SecurityByUser? It looks weird. — Francesco De Lisi
– Francesco De Lisi, Commented May 21, 2013 at 8:36

Willem · Accepted Answer · 2013-05-21 10:27:35Z

2

Found the issue. My View was not selecting the PK column of the table and by adding the PK column of the table to the select list of the View, it produced the correct results.

answered May 21, 2013 at 10:27

Willem

9,52617 gold badges72 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

marc_s Over a year ago

That's exactly one of the "thorny" issues with selecting from views - even if you don't want to display it, you need to include the underlying table's PK to make EF work properly with views

Collectives™ on Stack Overflow

LINQ - Not returning the same value as SQL Server

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related