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

Question

I would like to translate this query in LINQ to SQL:

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

My attempt:

  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; } 

It seems that "null" is not allowed in LINQ to SQL ... I have an error.

Thank you in advance for your help.

Answer 1

Use == , 'is' for type checking

 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; } 

Answer 2

Does this work?

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

Linq-to-SQL should translate this to the correct SQL.