ASP.Net MVC Pass EF Data to a Model

Question

I am new to MVC and Entity Framework, and would like some assistance in passing data to a model so that I can make my view a strongly typed view and get the information out as I need.

In the about action in the home controller i want to pull out data from my SiteContent table that is for the About Page

        var sc = db.siteContents.Where( x => x.Page == "About").ToList();
        return View(sc);

A couple of questions I have around this, is first, how do I get this into my Model SiteContent

    public class SiteContent
{
    public int ContentId { get; set; }
    public string ContentType { get; set; }
    public string Page { get; set; }
    public string ContentHeader { get; set; }
    public string Content { get; set; }
    public DateTime OriginalPostDate { get; set; }
    public DateTime UpdatePostDate { get; set; }
    public string ImageFileName { get; set; }
    public bool ContentReleased { get; set; }
}

I am uncertain on how I should proceed from here.

The from here I would like to use a strongly typed view to get the data by using my model.

Any and all help very much appreciated.

Thanks

Simon

Are you wanting a collection of SiteContent (which is what you currently have) of a single SiteContent object? — user3559349
– user3559349, Commented Aug 20, 2015 at 21:51
Is SiteContent the model used in your DbContext or is this a POCO? Also, you're pulling a list (.ToList); did you mean to grab SingleOrDefault()? — Brad Christie
– Brad Christie, Commented Aug 20, 2015 at 21:51
So you can easily do that by using IEnumerable<SiteContent> as a model for your view. — Sirwan Afifi
– Sirwan Afifi, Commented Aug 20, 2015 at 21:53
@BradChristie yes, siteContext is used in my DbContext ` public virtual DbSet<siteContent> siteContents { get; set; }` — Simon Price
– Simon Price, Commented Aug 20, 2015 at 22:13
@SirwanAfifi i thought i would want an IEnumerable, but dont know how I should implement it — Simon Price
– Simon Price, Commented Aug 20, 2015 at 22:14

Sirwan Afifi · Accepted Answer · 2015-08-20 22:20:01Z

1

Define your view like this:

@model IEnumerable<SiteContent>
<table>
   <tr>
      <td>ContentType</td>
      // other data
   </tr>
   @foreach(var item in Model)
   {
        <tr>
            <td>@item.ContentType</td>
            // other data
        <tr>
   }
</table>

answered Aug 20, 2015 at 22:20

Sirwan Afifi

10.8k14 gold badges67 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Simon Price Over a year ago

using this example i get this error back "The model item passed into the dictionary is of type 'System.Collections.Generic.List

1[InspireFitnessForAll.WebSite.DataModel.siteContent]', but this dictionary requires a model item of type 'System.Collections.Generic.IEnumerable

1[InspireFitnessForAll.WebSite.Models.SiteContent]'."

Sirwan Afifi Over a year ago

Check your namespace for SiteContent, It seems that your are accessing SiteContent in your DataModel folder not Models

Simon Price Over a year ago

ive just renamed the model to PageContent and have the same issue.

Simon Price Over a year ago

think i may have just spotted my mistake

Simon Price Over a year ago

Thank you for your help.

Collectives™ on Stack Overflow

ASP.Net MVC Pass EF Data to a Model

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related