0
kicks
Comparing with NULL in where clause using Linq to SQL
In Linq to SQL, there is no 'IS' operator as SQL. And this IS operator is used for comparing a field's value to NULL in SQL where clause since two NULLs are not equal and using the regular '=' operator between two nulls evaluates to false. In this article, I have shown you the problem that you must know before you write Linq to SQL code in your application and also a work around to this problem.