Database Issue - An error occurred while executing the command definition. See the inner exception for details

Question

Trying to populate lists from my database as follows, here is the controller:

namespace TimetableSystem.Controllers
{
public class AvailabilityController : Controller
{
    TimetableSystemEntities systemDB = new TimetableSystemEntities();

    public ActionResult Index()
    {

        var parkList = new List<String>();
        var parkQry = from p in systemDB.Parks
                      orderby p.ParkID
                      select p.ParkName;
        parkList.AddRange(parkQry);
        ViewBag.Park = parkList;

here is the park model:

using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.ComponentModel.DataAnnotations;

namespace TimetableSystem.Models
{
    public class ParkModel
    {
        [Key]
        public int ParkID { get; set; }
        public string ParkName { get; set; }
    }
}

and here is the TimetableSystemEntities model:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.Entity;

namespace TimetableSystem.Models
{
    public class TimetableSystemEntities : DbContext
    {
        public TimetableSystemEntities() : base("DefaultConnection") { }

        public DbSet<Department> Departments { get; set; }
        public DbSet<Module> Modules { get; set; }
        public DbSet<Request> Requests { get; set; }
        public DbSet<Round> Rounds { get; set; }
        public DbSet<User> Users { get; set; }
        public DbSet<ParkModel> Parks { get; set; }
        public DbSet<BuildingModel> Buildings { get; set; }
        public DbSet<RoomModel> Rooms { get; set; }
    }
}

But when I debug and move to the Availability page, I am given this error:

[System.Data.SqlClient.SqlException] {"Invalid object name 'dbo.ParkModels'."}

Not sure what is happening here as I can't find 'ParkModels' anywhere in the project or the database, the model is ParkModel, the database table is Park.

Thank you but that just changes the error to {"Invalid object name 'dbo.Parks'."} — bd99
– bd99, Commented Mar 27, 2014 at 15:59
This is one of those questions that would benefit from accepting an answer by the community. — Gert Arnold
– Gert Arnold, Commented Sep 30, 2017 at 10:21
I think, you will need add migration for your Context and update database. If you are using EF6 for connection database, this link help you — Sarvarbek Matvapayev
– Sarvarbek Matvapayev, Commented Sep 7, 2020 at 5:35

Craig W. · Accepted Answer · 2014-03-29 16:09:52Z

1

My understanding of code-first is that by convention the model and table names need to match. In your case they don't so you need to specify the mapping.

[Table("Park")]
public class ParkModel
{
    [Key]
    public int ParkID { get; set; }
    public string ParkName { get; set; }
}

Then your context should be:

DbSet<ParkModel> Parks { get; set; }

answered Mar 29, 2014 at 16:09

Craig W.

18.2k6 gold badges52 silver badges83 bronze badges

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

1 Comment

adimauro Over a year ago

This post is fairly old, so don't know if someone will even see this, but...actually, the code-first convention is not that the model and table names match. It's that the model is the singular of the table name. i.e., model = 'Park' and table = 'Parks'. But, yes, you are correct that when the convention is not followed, you have to specify the table name.

Collectives™ on Stack Overflow

Database Issue - An error occurred while executing the command definition. See the inner exception for details

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related