wp-how-to-use-petapoco-with-umbraco-05.cs

public class DataHandler : ApplicationEventHandler
{
    protected override void ApplicationStarted(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext)
    {
        var dbContext = ApplicationContext.Current.DatabaseContext;
        var dbs = new DatabaseSchemaHelper(dbContext.Database, ApplicationContext.Current.ProfilingLogger.Logger, dbContext.SqlSyntax);

        dbs.DropTable<ActorMovie>();
        dbs.DropTable<Actor>();
        dbs.DropTable<Movie>();
        dbs.DropTable<Director>();

        if (!dbs.TableExist<ActorMovie>)
        {
            dbs.CreateTable<Director>();
            dbs.CreateTable<Movie>();
            dbs.CreateTable<Actor>();
            dbs.CreateTable<ActorMovie>();
        }
    }
}