search

subsonic / SubSonic-3.0

SubSonic 3.0 for the .NET 3.5 Framework
http://subsonic.github.io/
559 stars 210 forks source link

DateTime? Field is not working in Query #203

Open qanuj opened 14 years ago

qanuj commented 14 years ago

Hello

Following query throws exception

The member 'xxx' is not supported

Data.Client pi = Data.Client.SingleOrDefault(x => x.Birthday == coDate);

Birthday is nullable field. ie. DateTime Null

thanks Anuj Pandey

ianoxley commented 13 years ago

Could this be solved by changing your query slightly? e.g.

Data.Client pi = Data.Client.SingleOrDefault(x => x.Birthday.HasValue && x.Birthday == coDate);