StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
4801231
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2011-01-26T03:43:12.753
FavoriteCount
0
LastActivityDate
2011-01-26T04:19:07.397
LastEditDate
2011-01-26T04:19:07.397
LastEditorUserId
156755
OwnerUserId
156755
ParentId
4801162
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
You've got a problem in that your calling thread has no idea if the variable has been populated by the <code>LoadData()</code> call In thi case you need to do something like: <ul> <li>Block execution until the load completes</li> <li>Raise an event when the load completes</li> <li>Set a publicly visible field on your loader to indicate load status</li> </ul> One (possible) compromise would be to return a custom object instead of an IEnumerable The custom object could immediately attempt to load the data and keep re-trying until success. If the result set of the custom object is read before a load has occured, block the thread until the load completes, otherwise return the result set In this scenario, you get a benefit if there's a delay between the Load occuring and the data being used - your program can continue on until it needs the data. Whether this i useful or not depends entirely on what you're using it for. More information on blocking execution: It depends a little on how you become aware that the connection is back up but something like: <pre><code>Public Sub LoadData(Of T)(ByVal query As ObjectQuery(Of T), ByRef result As IEnumerable(Of T)) While Not Connection.State = ConnectionState.Open Threading.Thread.Sleep(100) 'Pick a decent value for this delay based on how likely it is the connection will be available quickly End While result = 'Use the connection to get your data End Sub </code></pre> Is there any reason you're doing this as a sub with ByRef parameters as opposed to a function? You're only "returning" one object so I don't quite see the benefit. Not that it would make a huge difference functionally but it would be more readable...
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. PODeferred execution in VB.NET?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USBasic
UserOwnerUserId
1. USBasic
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. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUndeletion
CommentsPostId
1. COcan you elaborate more on part 1 "Block execution"?
 singulars
 PostPostId
 PO
 UserUserId
 USShimmy
2. CO@Shimmy I've edited my answer
 singulars
 PostPostId
 PO
 UserUserId
 USBasic

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.