Ok im trying to get my head around this and i could do with some input from someone else, brains about ready to shut up shop!
So im looking at LINQ to try and pull off records where a confirmed field is equal to null. The confirmed field is a bool value (or bit in SQL) so when i insert the record im putting this value in as null and later determining if it should be true or false. so far i have tired
where O.confirmed.Equals(null) where O.confirmed == null
I have tried another couple of ways but i still cannot get LINQ to translate properly....
Yes i could just add another field in the db to split this down i just wanted to go down every road before i did this...
Anyone any ideas?