/// <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(); }