why the sql query is different on that linq query when run on c# and on vb.net?

Question

if I run this under c#

from p in Addresses where p.Address2 == null select p.AddressID

it generate this query

SELECT [t0].[AddressID]
FROM [dbo].[Address] AS [t0]
WHERE [t0].[Address2] IS NULL

if I run this under vb.net

from p in Addresses where p.Address2 = nothing select p.AddressID

it generate this query

SELECT [t0].[AddressID]
FROM [dbo].[Address] AS [t0]
WHERE [t0].[Address2] = ''

p.Address2 is a varchar field that accept null value

why vb.net is "wrong" ?

Untested, but should it not be from p in Addresses where p.Address2 is nothing select p.AddressID — Rowland Shaw
– Rowland Shaw, Commented Aug 26, 2009 at 13:01

Ali Ersöz · Accepted Answer · 2009-08-26 13:00:52Z

8

in VB, null checks are controlled with "is" keyword.

try this;

from p in Addresses where p.Address2 is nothing select p.AddressID

answered Aug 26, 2009 at 13:00

Ali Ersöz

16.1k12 gold badges52 silver badges64 bronze badges

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

1 Answer 1