Click to See Complete Forum and Search --> : Linq


blitzkrieg78us
July 8th, 2008, 06:31 AM
hi folks,

Can any1 tell me as to how to check for a null value for a column and replace it with zero in LINQ just like we do in normal SQL statements?

i want to convert this statement in LINQ
select distinct isnull(stockid,0) from stock

how will u put this statement in LINQ?

ive done up2 'distinct' i culdnt continue further..

require ur help in this regard