Adding a new table to existing database in mvc4

Question

I am having some trouble understand how to add a new table to an existing database in my web application mvc 4. I have added the table to the database, then i added the model. When I build the solution, i get this error: The namespace 'MvcFFL.Models' already contains a definition for 'PlayerDBContext' C:\Webs\MvcFFL\MvcFFL\Models\Player.cs 19

Here is my Abbrviations model

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

namespace MvcFFL.Models
{
    public class Abbrivations
    {

        public int ID { get; set; }
        public string Abbrv { get; set; }
        public string Team { get; set; }
    }

    public class PlayerDBContext : DbContext
    {
        public DbSet<Abbrivations> Abbrvs { get; set; }
    }
}

Does the Dbset line need to go into the Player.cs file or is it actually needed? I would like to be able use the table to add data into

do you by any chance have one more class that is also called PlayerDBContext? — SoftwareFactor
– SoftwareFactor, Commented May 20, 2014 at 17:49
Yes I do, I understand that is the error but why when i have it referencing a different part of the DBset? — user3240928
– user3240928, Commented May 20, 2014 at 17:53
Why not just add all DbSets to a single DbContext? Is there any reason why you separated them? — SoftwareFactor
– SoftwareFactor, Commented May 20, 2014 at 17:58

Tim Sneed · Accepted Answer · 2014-05-20 18:09:20Z

1

I would restructure how my EF Context was set up. Have your model classes on their own, with no mention of a context. Then have a context file with your DbContext and DbSet of your models.

I don't usually speak in absolutes, but this is objectively a better way to structure your ef than the way you are currently doing it.

public class PlayerDBContext : DbContext
{
    public DbSet<Abbreviations> Abbrvs { get; set; }
    public DbSet<Team> Teams{ get; set; }
    //and any other context specific information OnModelCreating, SaveChanges, etc
}

Your application context should only be declared once per application, otherwise it will be extermely confusing and more likely, not work.

answered May 20, 2014 at 18:09

Tim Sneed

4903 silver badges10 bronze badges

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

1 Comment

user3240928 Over a year ago

oh ok, I can understand that now, thanks that worked

Collectives™ on Stack Overflow

Adding a new table to existing database in mvc4

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