Devart Forums

Code: Select all

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseSqlServer(GetConnectionString("myModelConnectionString"));
        CustomizeConfiguration(ref optionsBuilder);
        base.OnConfiguring(optionsBuilder);
    }

    private static string GetConnectionString(string connectionStringName)
    {
        System.Configuration.ConnectionStringSettings connectionStringSettings = System.Configuration.ConfigurationManager.ConnectionStrings[connectionStringName];
        if (connectionStringSettings == null)
            throw new InvalidOperationException("Connection string \"" + connectionStringName +"\" could not be found in the configuration file.");
        return connectionStringSettings.ConnectionString;
    }

Code: Select all

 // This method gets called by the runtime. Use this method to add services to the container.
public void ConfigureServices(IServiceCollection services)
{
	// Add framework services.

	services.AddDbContext<IQContext>(options =>
		options.UseSqlServer(Configuration.GetConnectionString("IqConnectionString")), ServiceLifetime.Scoped);