Is there a dynamic way to specify table in Entity Framework Core in .Net 6

Question

Is there a cleaner way to dynamically select a table from a context in Entity Framework? Maybe in a for next loop? If else else then is possible but looks messy and there are about 10 tables that we will need to handle. All the field names are the same in the tables. We are using .Net 6 already and VS 2022. So if there is a newer feature I am up for it.

await using timeFrameContext context = new();

var existsAlready = await context.FiveMin
    .AnyAsync(t => t.ProductName == symbol).ConfigureAwait(false);

var existsAlready = await context.FifteenMin
    .AnyAsync(t => t.ProductName == symbol).ConfigureAwait(false);

var existsAlready = await context.ThirtyMin
    .AnyAsync(t => t.ProductName == symbol).ConfigureAwait(false);

etc ...

DbContext.Set<TEntity>()?

Johnathan Barclay
– Johnathan Barclay

2021-09-30 14:44:33 +00:00
Commented Sep 30, 2021 at 14:44 — Johnathan Barclay
– Johnathan Barclay, Commented Sep 30, 2021 at 14:44

Den · Accepted Answer · 2021-09-30 15:11:43Z

1

Do you need somthing like this.

public async Task<bool> exist<T>(Expression<Func<T, bool>> condition) where T : class
{
    return await _contextDb.Set<T>().AnyAsync(condition);
}

then you can call in this way

var a = await existAsync((FiveMin t) => t.ProductName == symbol);
var b = await existAsync((FifteenMin t) => t.ProductName == symbol);
var c = await existAsync((ThirtyMin t) => t.ProductName == symbol);

answered Sep 30, 2021 at 15:11

Den

7867 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Is there a dynamic way to specify table in Entity Framework Core in .Net 6

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related