Get date diffrence between two DateTime columns in ASP.Net MVC using Entity Framework

Hi smcdevelopmen...,

Refer below example.

Database

For this example I have used of Northwind database that you can download using the link given below.

Download Northwind Database

Model

public class CustomerModel
{
    public int Id { get; set; }
    public string Name { get; set; }
    public DateTime BirthDate { get; set; }
    public DateTime? HireDate { get; set; }
    public int? Day { get; set; }
}

Namespaces

using System.Collections.Generic;
using System.Data.Objects;
using System.Linq;

Controller

public class HomeController : Controller
{
    // GET: Home
    public ActionResult Index()
    {
        NORTHWINDEntities entities = new NORTHWINDEntities();
        List<CustomerModel> employees = (from customer in entities.Employees
                                            select new CustomerModel
                                            {
                                                Id = customer.EmployeeID,
                                                Name = customer.FirstName,
                                                BirthDate = customer.BirthDate.Value,
                                                HireDate = customer.HireDate,
                                                Day = EntityFunctions.DiffDays(customer.BirthDate.Value, customer.HireDate.Value)
                                            }).ToList();
        return View(employees);
    }
}

View

@model  IEnumerable<DifferenceBetween_Column.Models.CustomerModel>
@{
    ViewBag.Title = "Index";
}
<h2>Index</h2>
<table>
    <tr>
        <th>EmployeeID</th>
        <th>Frist Name</th>
        <th>BirthDate</th>
        <th>HireDate</th>
        <th>Days</th>
    </tr>
    @foreach (var item in Model)
    {
        <tr>
            <td>@item.Id</td>
            <td>@item.Name</td>
            <td>@item.BirthDate</td>
            <td>@item.HireDate</td>
            <td>@item.Day</td>
        </tr>
    }
</table>

Screenshot