StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PONull values In Return Results
primarykey
Id
3657101
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2010-09-07T08:41:15.263
FavoriteCount
0
LastActivityDate
2017-12-08T18:35:49.020
LastEditDate
2017-12-08T18:35:49.020
LastEditorUserId
314488
OwnerUserId
423783
ParentId
0
PostTypeId
1
Score
0
ViewCount
250
LastEditorDisplayName
text
Body
here's My Code: <pre><code>Dim QSD = From VM In cntxtVessel.VesselMasters _ Group Join cnt In cntxtVessel.CountryMasters On VM.CountryCode Equals cnt.CountryCode Into Cntry = Group _ From CM In Cntry.DefaultIfEmpty _ Group Join D In cntxtVessel.DestinationMasters On VM.DestinationCode Equals D.DestinationCode Into Dest = Group _ From DM In Dest.DefaultIfEmpty _ Group Join Car In cntxtVessel.CarrierMasters On VM.ClientCode Equals Car.CarrierCode Into Cr = Group _ From CS In Cr.DefaultIfEmpty _ Where VM.VesselCode <> 0 _ Order By VM.VesselName Ascending _ Select VesselCode = VM.VesselCode, VesselID = VM.VesselID, VesselName = VM.VesselName, ServiceType = VM.ServiceType, ClientCode = CType(CS.CarrierCode, Int32), Agent = CS.CompanyName, RefNo = VM.RefNo, VesselType = VM.VesselType, Length = VM.Lenght, Width = VM.Weight, Height = VM.Height, VesselBuiltDate = VM.VesselBuiltDate, AgeOfShip = VM.AgeOfShip, ShipBuilder = VM.ShipBuilder, CountryCode = CType(CM.CountryCode, Int32?), CountryName = CType(CM.CountryName, String), DestinationCode = CType(VM.DestinationCode, Int32?), DestinationName = DM.DestinationName, Flag = VM.Flag, CallSign = VM.CallSign, IMONo = VM.IMONo, NRT = VM.NRT, ContactPerson = VM.ContactPerson, MobileNo = VM.MobileNo, TPNo = VM.TPNo, Fax = VM.Fax, Email = VM.Email, Web = VM.Web, Remarks = VM.Remarks, InActive = VM.InActive ugrdVessel.DataSource = QSD </code></pre> the above (left outer Join) code return the null value in some column (ex. <code>Country Code=Null, DestinationCode=null,Agent=Null</code>) how do i prenevt this null return values
Tags
<vb.net><linq><linq-to-sql>
Title
Null values In Return Results
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USPranay Rana
UserOwnerUserId
1. USSuhaibnm
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. CODont forget to upvote and mark answer as accepted if it works for you...
 singulars
 PostPostId
 PONull values In Return Results
 UserUserId
 USPranay Rana

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.