code_junkie

How to deal gracefully with null foreign keys in Linq to SQL?

Nov 11th, 2011
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.89 KB | None | 0 0
  1. From c as Concession in Db.Concessions _
  2. Select _
  3. c.ConcessionID, _
  4. c.Title, _
  5. c.Firm.Title
  6.  
  7. From c As Concession In Db.Concessions _
  8. Join f As Firm In Db.Firms On f.FirmID Equals c.FirmID _
  9. Select _
  10. c.ConcessionID, _
  11. c.Title, _
  12. Firm_Title = f.Title
  13.  
  14. from c in Db.Concessions
  15. select
  16. {
  17. c.ConcessionID,
  18. c.Title,
  19. Title = c.Firm.Title ?? ""
  20. }
  21.  
  22. From c As Concession In db.Concessions _
  23. Select _
  24. c.ConcessionID, _
  25. c.Title, _
  26. Firm_Title = If(c.Firm IsNot Nothing, c.Firm.Title, String.Empty) _
  27.  
  28. Public Property office() As String
  29. Get
  30. Return _office
  31. End Get
  32. Set(ByVal value As String)
  33. If value IsNot Nothing Then
  34. _office = value
  35. Else
  36. _office = String.Empty
  37. End If
  38. End Set
  39. End Property
Add Comment
Please, Sign In to add comment