Hey, I'm trying to find out how you can use the DatabaseSchemaHelper to check if tables exists and create tables In the past you could do it in the following way

namespace MyWebsite
{
    public class RegisterEvents : ApplicationEventHandler
    {
        //This happens everytime the Umbraco Application starts
        protected override void ApplicationStarted(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext)
        {
            //Get the Umbraco Database context
            var db = applicationContext.DatabaseContext.Database;

            //Check if the DB table does NOT exist
            if (!db.TableExist("BlogComments"))
            {
                //Create DB table - and set overwrite to false
                db.CreateTable<BlogComment>(false);
            }


    }
}

}

But those methods are now gone ( TableExist and CreateTable) from the Database object and are moved to the DatabaseSchemaHelper (in recent Umbraco versions)

Now my question is what is the code that works with the DatabaseSchemaHelper instead? I've tried the following but that fails

public class UmbracoEvents : ApplicationEventHandler
{
    private readonly UmbracoDatabase _database = ApplicationContext.Current.DatabaseContext.Database;
    private readonly DatabaseSchemaHelper _schemaHelper;

    public UmbracoEvents(ISqlSyntaxProvider sqlSyntax, ILogger logger)
    {

        _schemaHelper = new DatabaseSchemaHelper(_database, logger, sqlSyntax);
    }

    protected override void ApplicationStarted(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext)
    {
        if (!_schemaHelper.TableExist("sampleContact"))
        {
            //Create DB table - and set overwrite to false
            _schemaHelper.CreateTable<Contact>(false);
        }


    }
}

All tips appreciated. Thanks :)