Entity Framework Core DbContext set DbConnection

Question

In .NET Framework was DbContext in EntityFramework 6 was constructor where I can set DbConnection.

In EF .NET Core can I set DbContext DbConnection? I hit an exception in UseTransaction of DbContext method:

An exception of type 'System.InvalidOperationException' occurred in Microsoft.EntityFrameworkCore.Relational.dll but was not handled in user code: 'The specified transaction is not associated with the current connection. Only transactions associated with the current connection may be used.'

Does any body know how set the DbConnection? Or I have get a wrong way?

You can set the connection string in OnConfiguring override method your DbContext. For more information. docs.microsoft.com/en-us/ef/core/miscellaneous/… — Jaliya Udagedara
See Cross-context transaction topic in the documentation. It covers your question and contains examples of how to provide connection externally. — Ivan Stoev

Wilcko Wilcko · Accepted Answer · 2018-02-12T14:50:26

I have always added the Database Context within the startup file of .Net core apps by adding it to the IServiceCollection and pulling the string from the appsetting file like so:

        private void AddDatabase(IServiceCollection services)
    {
        var databaseConnectionString = Configuration.GetConnectionString("DatabseConnection");

        Check.CanConnectToDatabase(databaseConnectionString);

        services.AddDbContext<DatabaseContext>(
            options =>
            {
                options.ConfigureWarnings(
                    warnings => warnings.Throw(RelationalEventId.QueryClientEvaluationWarning));
                options.UseSqlServer(databaseConnectionString,
                    sqlOptions => sqlOptions.MigrationsHistoryTable(HistoryRepository.DefaultTableName, "SchemaName"));
            });
    }

Entity Framework Core DbContext set DbConnection

1 Answers