StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
7375112
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
2011-09-10T22:32:09.993
CreationDate
2011-09-10T22:32:09.993
FavoriteCount
0
LastActivityDate
2011-09-10T22:32:09.993
LastEditDate
LastEditorUserId
0
OwnerUserId
272072
ParentId
7374101
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
Since you're coming from PHP, perhaps it would be more helpful to give you an overview of CSharp's syntax shortcuts! They're really confusing at first glance because the syntax is SO similar. But after a quick intro, you'll learn to love them. <h2>Collection Initializers</h2> A Collection Initializer adds items to a collection. The syntax is <code>new SOMECOLLECTION { value, value, value }</code> The traditional way to populate a collection: <pre><code>var items = new List<int>(); items.Add(1); items.Add(2); items.Add(3); </code></pre> The Collection Initializer way - this compiles to nearly identical code: <pre><code>var items = new List<int>(){ 1, 2, 3 }; </code></pre> Side note: Array vs List - I'd say <code>List</code> is more commonly used because its size can change. But it's mostly personal preference. The short-hand way to create an array is: <code>var items = new int[]{ 1, 2, 3 };</code>, but you can also omit the type and the compiler will figure it out (aka implicitly-typed array): <code>var items = new []{ 1, 2, 3 };</code> <h2>Object Initializers</h2> An Object Initializer sets the properties of a new object. The syntax is <code>new SOMEOBJECT { Property = value, Property = value }</code> The traditional way to populate the properties of an object: <pre><code>var item = new Item(); item.First = "Chuck"; item.Last = "Norris"; </code></pre> The Object Initializer way: <pre><code>var item = new Item(){ First = "Chuck", Last = "Norris" }; </code></pre> <h2>Anonymous Objects</h2> I'm only mentioning this because the syntax for an anonymous object is extremely similar to the others, but does something much, much different. They are extremely confusing if you aren't aware of them! The syntax looks like a combination of the Collection and Object Initializers: <code>new { AnyPropertyName = value, anyVariableNameBecomesAProperty, someOtherObject.SomeProperty }</code> Let me explain! The compiler will create an "anonymous object" that has 3 properties, <code>AnyPropertyName</code>, <code>anyVariableNameBecomesAProperty</code>, and <code>SomeProperty</code>, and initializes the values the same way as the Object Initializer does. If you don't specify a property name, the name is inferred from the source. I hope this helps you understand why <code>new { h1, h2 }</code> (new anonymous object) is WAY different from <code>new []{ h1, h2 }</code> (new array).
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. PONullReferenceException in MVC3 Controller
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USScott Rippey
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. COThanks so much Scott for your very clear explanation of this. It is very useful. The problem with C#, like so many other things, is that it seems so clear when you're just reading about it, but applying it is what really shows whether you know it or not. I'm still a StackOverflow newbie, but I can't tell you how helpful everyone on this site has been.
 singulars
 PostPostId
 PO
 UserUserId
 USChemProfMatt

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.