Select distinct with anonymous type return error when one value is null

Prev: What does this text mean it's about keyed hash(HMAC)
Next: Need Linq Help

From: Paul on 23 Apr 2010 06:09

---

Hi,
How can i do this query with anonymous types;
SELECT DISTINCT IdTable2, Name
FROM Table1
WHERE idTable2 != null

This query return error if the idTable2 is null:
bindingSource1.DataSource=MyDataSet.Table1.Select(c=> new
{Id=c.IdTable2, Nome=c.Name }.Distinct();

Any idea?

Thanks

 | 
Pages: 1
Prev: What does this text mean it's about keyed hash(HMAC)
Next: Need Linq Help