Comments on Matt on ... Whatever: Null semantics in LINQ to SQL

Usually this happens when your Name field is set u...

2008-03-17T03:54:00.000-07:00

Usually this happens when your Name field is set up as a property. The SQL generator has to be able to translate everything you do in that prop-get to SQL, and it's not terribly smart in that department, so it usually won't try. If you're trying to build partial class behavior on the Name property, you should find another place to hang it.

Hi Matt,

I have a problem with nullable val...

2008-02-12T06:11:00.000-08:00

Hi Matt,

I have a problem with nullable values and LINQ. Take a look at the code below:

var query = from person in db.Persons where person.Name == null
select person;

Here, Person is a class and Name is a string (which can be, of course, null).

This query generates an error:
The member 'Project1.Person.Name' has no supported translation to SQL.

Any ideas?

Thanks.

Comments on Matt on ... Whatever: Null semantics in LINQ to SQL

Usually this happens when your Name field is set u...

Hi Matt,I have a problem with nullable val...

Hi Matt,

I have a problem with nullable val...