Most convenient way to alter table (add column) using Entity Framework Code First?

Question

I use Code First Entity Framework 6.0 approach and have BaseClass and some of DerivedClasses. I used to manually update database (all tables derived from BaseClass).

I want to update (doesn't matter where) data 1 time.

Classes:

public class IItem {

    public int Id {
        get;
        set;
    }

    public string Model {
        get;
        set;
    }

    public int Cost {
        get;
        set;
    }

    //other properties

}


public class MotherBoard : IItem {

    public string Manufacturer {
        get;
        set;
    }

    public string FormFactor {
        get;
        set;
    }

    public string CPUManufacturer {
        get;
        set;
    }

    public string Socket {
        get;
        set;
    }

    public int SocketCount {
        get;
        set;
    }

    //other properties

}

//there are 3 more classes

Ef context:

public class EFDbContext : DbContext {

    public IDbSet<MotherBoard> MotherBoards {
        get;
        set;
    }


    public IDbSet<Processor> Processors {
        get;
        set;
    }


    public IDbSet<VideoCard> VideoCards {
        get;
        set;
    }


    //other

}

tuppers · Accepted Answer · 2015-07-03 18:38:01Z

1

Hi could you post your code for your classes and context class?

What versions are you using of EF and in what context?

Do you have just the one context? If so try in PowerShell whilst targeting the project with your context

enable-migrations
add-migration Initial
update-database

edited Jul 3, 2015 at 18:38

answered Jul 3, 2015 at 18:14

tuppers

1181 gold badge2 silver badges8 bronze badges

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

2 Comments

thedriveee Over a year ago

Thanks tuppers for reply. I have added what you asked.

tuppers Over a year ago

no worries hope you get it sorted - try looking at stuff from Julie Lerman excellent tutorials etc

Collectives™ on Stack Overflow

Most convenient way to alter table (add column) using Entity Framework Code First?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related