Get data from the database using mvc with foreach

Question

I am trying to retrieve data from the database and write the records out, but i am getting an error:

An exception of type 'System.NullReferenceException' occurred in App_Web_uaarpxja.dll but was not handled in user code

Additional information: Object reference not set to an instance of an object.

Database model PastaModel.cs

public class Item
{
    [Key]
    public int Itemid { get; set; }
    public string Itemname { get; set; }
    public int Itemprice { get; set; }
    public int Currentstock { get; set; }
    public string Itemtype { get; set; }
    public string pictureURL { get; set; }
}

public class PastaContext : DbContext
{

    public PastaContext()
        : base("name=PastaModel")
    {
        Database.CreateIfNotExists();
    }

    public DbSet<Item> Items { get; set; }


    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();
    }

}

Controller ItemController.cs

public class ItemController : Controller
{

    private PastaContext db = new PastaContext();


    public ActionResult Index()
    {
        return View();
    }

    [HttpPost]
    public ActionResult Index()
    {
        return View();
    }

}

View Index.cshtml

@model IEnumerable<Oblig1.Models.Item>

<!DOCTYPE html>

<br />
<br />

<html>
<head>
    <title>Index</title>
</head>
<body>


@foreach (var item in Model)
{

     <p>@item.Itemname</p>

}


</body>
</html>

I am getting this error in this line @foreach (var item in Model) {

Edit: Added DbContext

Neel · Accepted Answer · 2014-10-08 12:11:28Z

3

This is happening because you are not injecting anything in your view from controller from where you are returning view.

and your view expecting IEnumerable<Oblig1.Models.Item> from your controller but as you are not passing model from controller the view gets null in Model.

try below code :-

public ActionResult Index()
    {
        var model = db.Items.ToList(); ////Your model that you want to pass
        return View(model);
    }

edited Oct 8, 2014 at 12:11

answered Oct 8, 2014 at 11:49

Neel

11.7k3 gold badges46 silver badges63 bronze badges

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

9 Comments

mv700 Over a year ago

Then i getting, The model item passed into the dictionary is of type 'System.Data.Entity.DbSet1[Oblig1.Models.Item]', but this dictionary requires a model item of type 'Oblig1.Models.Item'.` when i try it.

mv700 Over a year ago

New error...

The model item passed into the dictionary is of type 'System.Collections.Generic.List``1[Oblig1.Models.Item]', but this dictionary requires a model item of type 'Oblig1.Models.Item'

@Neel

Neel Over a year ago

have you made changes in ur view ? @mv700 your view expecting ienumerable

Neel Over a year ago

is this first line of ur view "@model IEnumerable<Oblig1.Models.Item>" ? @mv700

mv700 Over a year ago

Yes, @model IEnumerable<Oblig1.Models.Item> @Neel

|

Collectives™ on Stack Overflow

Get data from the database using mvc with foreach

1 Answer 1

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related