StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
10995224
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2012-06-12T10:54:04.673
FavoriteCount
0
LastActivityDate
2012-06-12T12:07:23.500
LastEditDate
2012-06-12T12:07:23.500
LastEditorUserId
3603
OwnerUserId
448144
ParentId
10994426
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
Not sure how you get to compile your code example above. In your <code>myObj</code> object, the <code>received</code> property is an <code>int</code>, yet you are evaluating it against a <code>bool</code> which should cause this line <code>o.received != true</code> to results in an error <code>Cannot apply operator '!=' to operands of type 'int' and 'bool'</code>. To Check the SQL Once the code compiles use <a href="http://weblogs.asp.net/zeeshanhirani/archive/2008/04/18/how-to-use-profiler-with-linq-to-sql-queries.aspx" rel="nofollow">SQL Profiler</a> to see what SQL is generated. That will show you the constructed SQLs Benchmarking The below is a very crude description of only one possible way you can benchmark your code execution. Wrap your code into a method, for example: <pre><code>public void TestingOperationOneWay() { int[] list; /* Populate list with a bunch of id numbers found in myOBjs */ myCont data = new myCont(); myObj ob = data.myObjs.Where(o => o.parent == "number1"); foreach(int i in list) { ob.First(o => o.id == i && o.received != true).received = true; } } </code></pre> And: <pre><code>public void TestingOperationAnotherWay() { int[] list; /* Populate list with a bunch of id numbers found in myOBjs */ myCont data = new myCont(); foreach(int i in list) { data.myObjs.First(o => o.parent == "number1" && o.id == i && o.received != true).received = true; } } </code></pre> Crate a method which iterates x amount of times over each method using the <code>Stopwatch</code> similar to this: <pre><code>private static TimeSpan ExecuteOneWayTest(int iterations) { var stopwatch = Stopwatch.StartNew(); for (var i = 1; i < iterations; i++) { TestingOperationOneWay(); } stopwatch.Stop(); return stopwatch.Elapsed; } </code></pre> Evaluate the results similar to this: <pre><code>static void RunTests() { const int iterations = 100000000; var timespanRun1 = ExecuteOneWayTest(iterations); var timespanRun2 = ExecuteAnotherWayTest(iterations); // Evaluate Results.... } </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POUsing Entity Framework, which method is more efficient?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USRichard Szalay
UserOwnerUserId
1. USNope
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POUsing Entity Framework, which method is more efficient?
 singulars
 PostTypePostTypeId
 PTQuestion
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
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
CommentsPostId
1. COThanks for this, I wasn't aware of the stopwatch object. As for the code not compiling well the above code was not from my project, just a bit of example code to demonstrate what I am trying to do in my application, but thanks for that too.
 singulars
 PostPostId
 PO
 UserUserId
 USJohn C
2. COYou are more than welcome. I'm glad it helped.
 singulars
 PostPostId
 PO
 UserUserId
 USNope

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.