/// <summary>
/// Uses the mssql database.
/// </summary>
/// <returns>The builder.</returns>
/// <param name="builder">Builder.</param>
/// <param name="connection">Connection.</param>
/// <typeparam name="TContext">Data context.</typeparam>
public static DataContextOptionsBuilder <TContext> UseMssql <TContext>(this DataContextOptionsBuilder <TContext> builder, string connection) where TContext : DataContext
{
builder.SetDataConfig(connection, (configName, configParams) => {
var database = new MssqlProvider(configName, configParams);
return(database);
});
return(builder);
}
public ActionResult Index()
{
// Add action logic here
try
{
DbProvider provider = new MssqlProvider
{
ConnectionString =
ConfigurationManager.ConnectionStrings["DefaultConnectionString"].
ConnectionString
};
MigrationManager.UpgradeMax(typeof(CreateMovies).Assembly, provider);
}
catch (Exception)
{
ControllerContext.HttpContext.Response.StatusCode = 404;
throw;
}
return new EmptyResult();
}
