StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
19678037
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2013-10-30T09:11:20.767
FavoriteCount
0
LastActivityDate
2013-10-30T09:11:20.767
LastEditDate
LastEditorUserId
0
OwnerUserId
449696
ParentId
19660176
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
<p>This isn't answering my question directly and so I haven't marked it as such but I thought it was worth showing the alternative of having a single connection per object as this seems to circumvent the issue...</p> <pre><code> private static void DoQuery(object state) { try { lock (DbRequestLock) { var builder = new SqlConnectionStringBuilder(ConnectionsString) { AsynchronousProcessing = true, }; DatabaseRequestsComplete.Reset(); _databaseRequestsLeft = BusinessObjects.Count; foreach (var businessObject in BusinessObjects) { var newConnection = new SqlConnection(builder.ConnectionString); newConnection.Open(); var command = new SqlCommand(SpName, newConnection) { CommandType = CommandType.StoredProcedure }; command.BeginExecuteReader(Callback, new Tuple<SqlCommand, BusinessObject>(command, businessObject),CommandBehavior.CloseConnection); } // need to wait for all to complete DatabaseRequestsComplete.WaitOne(10000); } } catch (Exception ex) { Console.WriteLine("Following error occurred while attempting to update objects: " + ex); } } private static void Callback(IAsyncResult result) { var tuple = (Tuple<SqlCommand, BusinessObject>)result.AsyncState; var businessObject = tuple.Item2; SqlCommand command = tuple.Item1; try { using (SqlDataReader reader = command.EndExecuteReader(result)) { using (var table = new DataTable(businessObject.Name)) { table.Load(reader); businessObject.UpdateData(table); } } } catch (Exception ex) { Console.WriteLine(ex); } finally { // decrement the number of database requests remaining and, if there are 0 fire the mre if (Interlocked.Decrement(ref _databaseRequestsLeft) == 0) { DatabaseRequestsComplete.Set(); } try { command.Dispose(); command.Connection.Dispose(); } catch (Exception ex) { Console.WriteLine(ex); } } } </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POSQLException on ADO.Net SqlCommand.EndExecuteReader
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USgouldos
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
  VTUpMod
CommentsPostId
1. COI think it's a perfectly reasonable solution provided that you don't have too many objects and hence connections.
  singulars
  PostPostId
  PO
  UserUserId
  USSzymon

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.