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:

How VPNs Protect Your Privacy Online

How VPNs Protect Your Privacy Online Understanding VPN Technology What is a VPN? A Virtual Private Network (VPN) is a technology th...