|
question regarding to the anonymous type |
Post Reply 
|
| Author |
 Share Topic Printable Version Delicious Digg Facebook Furl Google Boomarks Google Buzz MySpace Newsvine reddit StumbleUpon Translate Twitter Windows Live Yahoo Bookmarks Topic Search  Topic Options
|
monkeyking 
Groupie 
Joined: 04-Mar-2009 Location: brisbane Posts: 68 |
 Post Options
 Quote Reply
 Topic: question regarding to the anonymous typePosted: 27-Sep-2009 at 9:49pm |
|
the red squared section can crash the program when it's a null, what i want to
do is converting the value (of debtorSales, cashSales or grossTotal)
into 0 when it's a null, but in anonymous type, I don't think i can put
any logic statment inside, such as if statement. so is there any way to
resolve it?
Regards, John  |
|
 |
|
|
kimj
IdeaBlade 
Joined: 09-May-2007 Posts: 1391 |
Post Options
Quote Reply
Posted: 28-Sep-2009 at 3:16pm |
|
You can check for nulls when summing -
... .Sum(o => o.SALES_PRICE == null ? 0 : o.SALES_PRICE)
|
|
|
|
|
monkeyking
Groupie
Joined: 04-Mar-2009 Location: brisbane Posts: 68 |
Post Options
Quote Reply
Posted: 28-Sep-2009 at 5:56pm |
|
Thanks, I think your way should work logically, but unfortunately the same error occurs.
 all other properties doesn't have any problems, the problem only occur on 'cashSales' (even not in debtorSales), i'm sure for that. |
|
|
|
|
kimj
IdeaBlade
Joined: 09-May-2007 Posts: 1391 |
Post Options
Quote Reply
Posted: 29-Sep-2009 at 7:51pm |
|
Oh sorry. This has already been fixed in current bits (for a separate problem) and that's what I tested against when answering previously. So that's the good news - it will be fixed in the mid-October release. The bad news, I don't have a workaround for you to use right now.
|
|
|
|
|
Post Reply
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |