Linq Sql Int null equal to null. Not returning rows

Question

I have a linq query with a where clause as below

var ExistingGroupDataSource = (from ppatg in dbContext.XXXXXXXXX
                               join pd1 in dbContext.XXXXXXXXXXX on ppatg.ScheduleID equals pd1.ScheduleID 
                               where  pd1.GroupID == null
                               select
                               new 
                               {
                                FinishPDI = pd1.ProductionDateID,
                                FinishingDate = pd1.WorkFlowDate,
                                ppatg.GroupName,
                                ppatg.PNTGroupID
                               });

In the database GroupID is an int that can be null. The linq query returns rows without the filtered where clause but none when I include the where clause. There are null values in the GroupId column in the database.

It is definitely this statement that produces no results. All the literature on the subject online says that this is equivalent to

pd1.GroupID is null // in sql

I am getting results that contradict this

Sql code is

 select pd1.ProductionDateID as FinishPDI, pd1.WorkflowDate as FinishingDate,GroupName ,PNTGroupId 
 from XXXXXXXXXXXX 
 inner join XXXXXXXXXXXX pd1 on 
 XXXXXXXXXXXX.ScheduleId = pd1.ScheduleID
 where pd1.GroupID is null

Is GroupID in your Model a nullable type?

Willy David Jr
– Willy David Jr

2017-12-05 03:40:50 +00:00
Commented Dec 5, 2017 at 3:40 — Willy David Jr
– Willy David Jr, Commented Dec 5, 2017 at 3:40
Yes, in the model GroupID is a int?

Darren Wood
– Darren Wood

2017-12-05 03:42:48 +00:00
Commented Dec 5, 2017 at 3:42 — Darren Wood
– Darren Wood, Commented Dec 5, 2017 at 3:42
It should be int? GroupID.

Willy David Jr
– Willy David Jr

2017-12-05 03:43:38 +00:00
Commented Dec 5, 2017 at 3:43 — Willy David Jr
– Willy David Jr, Commented Dec 5, 2017 at 3:43
Can you show sql code?

Backs
– Backs

2017-12-05 03:47:29 +00:00
Commented Dec 5, 2017 at 3:47 — Backs
– Backs, Commented Dec 5, 2017 at 3:47
@Backs added sql code

Darren Wood
– Darren Wood

2017-12-05 03:56:17 +00:00
Commented Dec 5, 2017 at 3:56 — Darren Wood
– Darren Wood, Commented Dec 5, 2017 at 3:56

ZippyZippedUp · Accepted Answer · 2017-12-05 13:19:32Z

1

You can combine your where with the join, which should give you the expected results:

var ExistingGroupDataSource = (from ppatg in dbContext.XXXXXXXXX
                               join pd1 in dbContext.XXXXXXXXXXX.Where(p => !p.GroupId.HasValue) on ppatg.ScheduleID equals pd1.ScheduleID 
                               select
                               new 
                               {
                                FinishPDI = pd1.ProductionDateID,
                                FinishingDate = pd1.WorkFlowDate,
                                ppatg.GroupName,
                                ppatg.PNTGroupID
                               });

answered Dec 5, 2017 at 13:19

ZippyZippedUp

4545 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

Linq Sql Int null equal to null. Not returning rows

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related