Built in support in Entity Framework for auto update database programmatically? (without any data loss)

Question

Say you send a new app version to customer, and you need to update the local customer database, say its an SQL microsoft database 2008.

For now i do this by a version table in the database, and run, sql scripts. - to match that version, like:

    if (DatabaseVersion < Common_func.ProgramDBFixVersion)
    {
        switch (DatabaseVersion)
        {
            case 0:
                if (Fix0() == false) NoErrorFixFlg = false;
                goto case 1;

            case 1:
                if (Fix1() == false) NoErrorFixFlg = false;
                goto case 2;
                .  
                .
                .

private static bool Fix1()
{

    try
    {
        var conn = new SqlConnection(Utils.ConnectionString);
        conn.Open();
        ExecSql(conn, "ALTER TABLE Customer ADD Is_Deleted [bit] NULL");
        conn.Close();
    }
    catch (Exception ex)
    {
      retrun false;
    }
    return true;
}

This work good, but is there any real built in support to this in the Entity Framework.

without any data loss !

If so - can you give some concrete example how this can be done the right way.

Thank you so much!

Wow, I never knew you could do goto case in C#. Though strangely I don't feel like I've missed out on anything. — Allon Guralnek
– Allon Guralnek, Commented Apr 19, 2013 at 6:59

Macros · Accepted Answer · 2012-02-24 08:43:17Z

5

Check out migrations: http://blogs.msdn.com/b/adonet/archive/2012/02/09/ef-4-3-code-based-migrations-walkthrough.aspx

When using without automatic updating, each migration / change is created in a file with scripted changes and rollbacks

answered Feb 24, 2012 at 8:43

Macros

7,1092 gold badges42 silver badges61 bronze badges

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

Collectives™ on Stack Overflow

Built in support in Entity Framework for auto update database programmatically? (without any data loss)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related