Повторное использование IDbContextFactory в консольном приложении ⇐ C#

[Гость]

I'm hoping someone can help a fairly new programmer.

I have a Blazor app I have a Console app I have a Class library

The class library contains all of the models and services for both the Blazor app and console app to access. The Blazor app works fine, by creating the service on startup, i.e.

Код: Выделить всё

builder.Services.AddDbContextFactory(options => options.UseSqlServer(builder.Configuration.GetConnectionString("DefaultConnection"))); 

The blazor app uses IDbContextFactory to access the database. The services within the shared library all use this IDbContextFactory.

For example, in the shared library, I have the following method:

Код: Выделить всё

        public async Task GetReceiptHeadersAsync(int id)         {             using var context = factory.CreateDbContext();             return await context.ReceiptHeaders.Where(p => p.Superseeded == false).FirstOrDefaultAsync(p => p.Id == id);         } 

The Blazor app does this fine, as DI has populated IDbContextFactory,however I cant use IDbContextFactory from the console app as far as I can tell.

Is there a way round this, or a way to create a new dbcontext and create a DbContextFactory off of this?

I've tried to create the IDbContextFactory manually, however I get a casting issue between myDbContext and IDBContextFactory


Источник: https://stackoverflow.com/questions/755 ... onsole-app