Difference between revisions of "Turn Off DB Initializer in Code-First"

Latest revision as of 14:27, 9 May 2016

Turn off DB Initializer in Code-First

You can also turn off DB initializer of your application. Suppose for the production environment you don’t want to lose existing data, then you can turn off initializer as shown in the following:

     
    public class SchoolDBContext: DbContext 
    {
        public SchoolDBContext() : base("SchoolDBConnectionString")
        {            
            //Disable initializer
            Database.SetInitializer<SchoolDBContext>(null);
        }
        public DbSet<Student> Students { get; set; }
        public DbSet<Standard> Standards { get; set; }
    }

You can also turn off the initializer in the configuration file, for example:

    
    <?xml version="1.0" encoding="utf-8" ?>
    <configuration>
      <appSettings>    
        <add key="DatabaseInitializerForType SchoolDataLayer.SchoolDBContext, SchoolDataLayer"
             value="Disabled" />
      </appSettings>
    </configuration>