Using " Is NULL/not NULL" in LINQ To SQL

Question

i would like to translate this request in LINQ to SQL:

SELECT * from Agir where NouvelIncident='1' AND facturable is null

My try:

 public static List<Agir> GetINDEFAgir()
 {
     DataClassesActilogDataContext db = ContextSingleton.GetDataContext();

     List<Agir> list;

     var v = from i in db.Agir
             where i.facturable is null && i.NouvelIncident == true
             select i;

     list = v.ToList();
     return list;

 }

Looks like "is null" is not allowed in LINQ to SQL... i have a mistake.

Thanks in advance for your help

Ben · Accepted Answer · 2014-12-30 23:46:19Z

13

Use ==, 'is' is to check types

public static List<Agir> GetINDEFAgir()
 {

 DataClassesActilogDataContext db = ContextSingleton.GetDataContext();

 List<Agir> list;

 var v = from i in db.Agir
         where i.facturable == null && i.NouvelIncident == true
         select i;

 list = v.ToList();
 return list;

 }

edited Dec 30, 2014 at 23:46

Ben

57.6k50 gold badges187 silver badges229 bronze badges

answered Feb 29, 2012 at 11:32

Mario Corchero

5,6256 gold badges40 silver badges62 bronze badges

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

Comments

Mike Mooney · Accepted Answer · 2012-02-29 11:32:30Z

1

Doesn't this work?

var v = from i in db.Agir
             where i.facturable == null && i.NouvelIncident == true
             select i;

Linq-to-SQL should translate that to the proper SQL.

answered Feb 29, 2012 at 11:32

Mike Mooney

12k3 gold badges39 silver badges43 bronze badges

Collectives™ on Stack Overflow

Using " Is NULL/not NULL" in LINQ To SQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related