Comparing with NULL in where clause using Linq to SQL(smsohan.blogspot.com)

submitted by smsohansmsohan(60) 3 years, 9 months ago

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.

add a comment |category: |Views: 321

tags: another

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
Comments:

No comments so far

information Login or create an account to comment on this story