Monday, August 19, 2013

VB.NET Query to get data when Key ID is Null aka Nothing (vb.net)

Dim Query = From x In ctx.tbl_funding_capitation _ Order By x.start_dt Descending _ Select New With { _ .providerID = If((x.my_id IsNot Nothing), x.tbl_data.DATA_ID, Nothing),
 _ .provider = If((x.my_id IsNot Nothing), x.tbl_data.DATA_NAME, "")
, _ .active = x.active
 }

No comments:

CSS Basics That Make Your Site Look Professional

CSS Basics That Make Your Site Look Professional Understanding the Role of CSS in Web Design What CSS Does for Website Appearance C...