Show latest three items on index page from database

Question

I've been looking around online for a good long while now and I know how to view all items from database. However what I want to do is show the latest three posts (database items) by date it was added.

Here's my code from the controller which shows all the posts on my index view

   public ActionResult index()
   {
       return View(db.posts.ToList());

   }

How can I change this method to do what I want?

See: http://stackoverflow.com/questions/8532768/how-to-retrieve-last-5-records-using-linq-method-or-query-expression-in-c-sharp — Sefa, Jan 22 '15 at 20:19
`db.posts.OrderBy(p => p.WhateverPropertyHoldsYourDate).Take(3).ToList()`. — Asad Saeeduddin, Jan 22 '15 at 20:26

score 0 · Answer 1 · answered Jan 22 '15 at 20:24

0

Your SQL query that returns the posts should be something like:

SELECT TOP(3) * FROM posts ORDER BY id

id being a primary key.

Then your index() method should display those results.

Hope this is what you're looking for.

answered Jan 22 '15 at 20:24

sk1tt1sh

198
1
2
11

Show latest three items on index page from database

1 Answers1