StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
12438239
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
4
CommunityOwnedDate
CreationDate
2012-09-15T14:34:34.667
FavoriteCount
0
LastActivityDate
2012-09-15T14:34:34.667
LastEditDate
LastEditorUserId
0
OwnerUserId
1437642
ParentId
12437731
PostTypeId
2
Score
9
ViewCount
0
LastEditorDisplayName
text
Body
Yes I wrote that tutorial against Beta. Below is the code updated to RTM version. One advice, if I may, is that this example uses a simple "whitelist" of concrete types for which RSS/Atom feed is build (in this case my <code>Url</code> model). Ideally in more complex scenarios, you'd have the formatter set up against an interface, rather than a concrete type, and have all Models which are supposed to be exposed as RSS to implement that interface. Hope this helps. <pre><code> public class SyndicationFeedFormatter : MediaTypeFormatter { private readonly string atom = "application/atom+xml"; private readonly string rss = "application/rss+xml"; public SyndicationFeedFormatter() { SupportedMediaTypes.Add(new MediaTypeHeaderValue(atom)); SupportedMediaTypes.Add(new MediaTypeHeaderValue(rss)); } Func<Type, bool> SupportedType = (type) => { if (type == typeof(Url) || type == typeof(IEnumerable<Url>)) return true; else return false; }; public override bool CanReadType(Type type) { return SupportedType(type); } public override bool CanWriteType(Type type) { return SupportedType(type); } public override Task WriteToStreamAsync(Type type, object value, Stream writeStream, System.Net.Http.HttpContent content, System.Net.TransportContext transportContext) { return Task.Factory.StartNew(() => { if (type == typeof(Url) || type == typeof(IEnumerable<Url>)) BuildSyndicationFeed(value, writeStream, content.Headers.ContentType.MediaType); }); } private void BuildSyndicationFeed(object models, Stream stream, string contenttype) { List<SyndicationItem> items = new List<SyndicationItem>(); var feed = new SyndicationFeed() { Title = new TextSyndicationContent("My Feed") }; if (models is IEnumerable<Url>) { var enumerator = ((IEnumerable<Url>)models).GetEnumerator(); while (enumerator.MoveNext()) { items.Add(BuildSyndicationItem(enumerator.Current)); } } else { items.Add(BuildSyndicationItem((Url)models)); } feed.Items = items; using (XmlWriter writer = XmlWriter.Create(stream)) { if (string.Equals(contenttype, atom)) { Atom10FeedFormatter atomformatter = new Atom10FeedFormatter(feed); atomformatter.WriteTo(writer); } else { Rss20FeedFormatter rssformatter = new Rss20FeedFormatter(feed); rssformatter.WriteTo(writer); } } } private SyndicationItem BuildSyndicationItem(Url u) { var item = new SyndicationItem() { Title = new TextSyndicationContent(u.Title), BaseUri = new Uri(u.Address), LastUpdatedTime = u.CreatedAt, Content = new TextSyndicationContent(u.Description) }; item.Authors.Add(new SyndicationPerson() { Name = u.CreatedBy }); return item; } } </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POCreate RSS feed in MVC4/WebAPI
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USFilip W
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POCreate RSS feed in MVC4/WebAPI
 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. This table or related slice is empty.

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.