Run custom SQL script on app start

If you are using code first with entity, you can try execute your sql scripts in migration:

First you need to create a migration:

Add-Migration RunMySqlScripts

Then in the generated migration file you can write your SQL:

// PLAIN SQL
Sql("Your sql code here");

// OR FROM FILE
var sqlFile = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, @"scripts.sql"); 
Sql(File.ReadAllText(sqlFile));

Then you run:

Update-Database

This will be executed only once.