C# - How to Display a specific record from a database to a view in ASP.NET MVC
<p>Ok so i have created my database which consist of 6 rows which are:</p>

<ul>
<li>ID</li>
<li>DisplayName</li>
<li>Date</li>
<li>Amount</li>
<li>TaxBonus</li>
<li>Comment</li>
</ul>

<p>Now this is working and i use partial view to dislay it on to my view. The part i am stuck on is displaying a specific record. What i would like to do is display three record from my database on the the same view as my enitre records from database. At the top will be these three records then a seperate table will have all the records. Reason for this is because i want display the highest donation(amount) on to the view. I firstly have no idea how to display a specific record even after hours of research and secondly displaying the highes record.</p>

<p>Below is the code which will help you guys understand more:</p>

<p><strong>Controller</strong></p>

<pre><code>using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Entity;
using System.Linq;
using System.Net;
using System.Web;
using System.Web.Mvc;
using CharitySite.Models;

namespace CharitySite.Controllers
{
    public class CharitiesController : Controller
    {
        private CharityDBContext db = new CharityDBContext();

        // GET: Charities
        public ActionResult Index()
        {
            return View(db.Donations.ToList());
        }
</code></pre>

<p><strong>Model</strong> </p>

<pre><code>using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Web;

namespace CharitySite.Models
{
    public class Charity
    {
        public int ID { get; set; }
        public string DisplayName { get; set; }
        public DateTime Date { get; set; }
        public Double Amount { get; set; }
        public Double TaxBonus { get; set; }
        public String Comment { get; set; }
    }

    public class CharityDBContext : DbContext //controls information in database 
    {
        public DbSet&lt;Charity&gt; Donations { get; set; } //creates a donation database
    }
}
</code></pre>

<p><strong>View</strong></p>

<pre><code>@model IEnumerable&lt;CharitySite.Models.Charity&gt;

@{
    ViewBag.Title = "Index";

}


&lt;link href="@Url.Content("~/Content/Site.css")" rel="stylesheet" type="text/css" /&gt;
&lt;link href="@Url.Content("~/Content/bootstrap.css")" rel="stylesheet" type="text/css" /&gt;
&lt;div id="header"&gt;

    &lt;h1&gt;Syria&lt;/h1&gt;
    &lt;h4&gt;DONATIONS&lt;/h4&gt;

&lt;/div&gt;

&lt;div class="half-col"&gt;
   @Html.Partial("_Database", Model);

&lt;/div&gt;
</code></pre>

<p>So in simple terms what i need is to:</p>

<ol>
<li>Display a specific record in a view</li>
<li>Display the highest donations (amount) - with their name and comment in a view</li>
</ol>

<p>Researched everywhere to do this but i could not find anything, reason why i have come here to ask if any of you guys know the solution to make this work.</p>

<p>P.S - I am using Visual Studio Community 2015 with ASP.NET and the MVC template(C#) </p>