EF CodeFrist to existing Db

Question

I want learn EF 6 CodeFirst to an Existing Database (SQLServer)

When I trying to run my project i got this error:

Exception

System.ArgumentNullException: Value cannot be null. Parameter name: source

Controller

public ActionResult Index()
{
    var meetings = db.Meetings
        .OrderBy(e => e.StartDate)
        .Where(e => e.IsPublic)
        .Select(e => new MeetingViewModel()
            {
                MeetingId = e.MeetingId,
                MeetingName = e.MeetingName,
                MeetingTypeName = e.MeetingType.Name,
                LocationName = e.MeetingLocation.Name,
                StartDate = e.StartDate,
            });

    var upcomingMeetings = meetings.Where(e => e.StartDate > DateTime.Now);
    var passedMeetings = meetings.Where(e => e.StartDate <= DateTime.Now);
    return View(HomeIndex, new HomePageModel());
}

Page Model

public class HomePageModel
{
    public IEnumerable<MeetingViewModel> UpcommingMeetings { get; set; }
    public IEnumerable<MeetingViewModel> PassedMeetings { get; set; }
}

Cshtml

@model AquaEvent.Common.HomePageModel
<div class="row">
    @if (Model.UpcommingMeetings.Any())
    {
        @Html.DisplayFor(x => x.UpcommingMeetings)
    }
</div>

connectioString is EF AutoGenerator without changing

How about assigning `upcomingMeetings` and `passedMeetings` to the `new HomePageModel()` properties. — Ivan Stoev, Jan 03 '18 at 12:29
Please refer this. https://stackoverflow.com/questions/16281133/value-cannot-be-null-parameter-name-source — Jyothish Bhaskaran, Jan 03 '18 at 12:30
@IvanStoev Yeah I'm missing that, Thank you And dear Rainman — hitasp, Jan 03 '18 at 12:45

score 2 · Accepted Answer · answered Jan 03 '18 at 12:30

2

You are not passing the collections in the model and UpcommingMeetings causes null exception error in the view;

var upcomingMeetings = meetings.Where(e => e.StartDate > DateTime.Now);
var passedMeetings = meetings.Where(e => e.StartDate <= DateTime.Now);
return View(HomeIndex, new HomePageModel()
{
    UpcommingMeetings = upcomingMeetings,
    PassedMeetings = passedMeetings
});

answered Jan 03 '18 at 12:30

lucky

12,734
4
24
46

Thank you, I lost 5h of my time for this, I looking for a error in my Db migration. because all of similar quiz linked me to it. Thank you! – hitasp Jan 03 '18 at 12:41

EF CodeFrist to existing Db

1 Answers1