C#•4y ago

❔ EntityFramework async where possible?

So I want to make sure I don't do something stupid here.

I'm trying to convert my DbContext-calls to async calls where possible.
I see EF provides

.FirstOrDefaultAsync()

.FirstOrDefaultAsync()

.FirstOrDefaultAsync()

.FirstOrDefaultAsync() which works nicely for the Get calls I have.
However I need to do stuff like

join

join

join

join and

where

where

which I see has no async overload.

I started doing

Task.Run(async () => await myDbContext.MyDbSet.Join() // etc

Task.Run(async () => await myDbContext.MyDbSet.Join() // etc

Task.Run(async () => await myDbContext.MyDbSet.Join() // etc

Task.Run(async () => await myDbContext.MyDbSet.Join() // etc

but that feels wrong. How do I make this particular call async without doing something explosively stupid?

cumslvt13•11/28/22, 11:06 AM

Can you show the JoinJoin method signature? I don't think that JoinJoin triggers query at all

cumslvt13•11/28/22, 11:07 AM

There are multiple method that trigger the query execution (they have both sync and async variants) and rest of them is are sync since they do not execute query

EsaOP•11/28/22, 11:07 AM

This is the xml docs I get for the method:

cumslvt13•11/28/22, 11:09 AM

so how you await it? in you example?

cumslvt13•11/28/22, 11:09 AM

When it just returns a IQueryableIQueryable

Ccumslvt13 There are multiple method that *trigger* the query execution (they have both syn...

EsaOP•11/28/22, 11:09 AM

This makes sense:)
So my method is Join().Where().Select().ToList()

cumslvt13•11/28/22, 11:09 AM

Yes

cumslvt13•11/28/22, 11:10 AM

The code you've shown is not valid at all

EsaOP•11/28/22, 11:10 AM

Yea so this is the part I don't get, the nature of EF is data transfer between my app and a data source, so there has to be some IO involved. Why can't I find any async overload to obtain the info my method provides?

EsaOP•11/28/22, 11:10 AM

What is not valid at all?

cumslvt13•11/28/22, 11:10 AM

**await** myDbContext.MyDbSet.Join()**await** myDbContext.MyDbSet.Join()

cumslvt13•11/28/22, 11:10 AM

await, since Join doesn't return a Task

cumslvt13•11/28/22, 11:11 AM

so nothing to be awaited

EEsa This makes sense:) So my method is Join().Where().Select().ToList()

cumslvt13•11/28/22, 11:11 AM

ToListAsync()ToListAsync() to be precise

EsaOP•11/28/22, 11:11 AM

Right, which is why I considered wrapping it in a Task

EsaOP•11/28/22, 11:11 AM

Oh.. There is an overload for that, I didn't check. That makes sense

cumslvt13•11/28/22, 11:13 AM

First, Single, Last, Any, Average, Max, Count, Sum, etc - all of this launches a db query

Ccumslvt13 First, Single, Last, Any, Average, Max, Count, Sum, etc - all of this launches a...

cumslvt13•11/28/22, 11:13 AM

and their async variants ofc too

EsaOP•11/28/22, 11:15 AM

okay, that makes sense. I've been using a nuget library for most of my collections, so I don't really use List etc in my application. I didn't think to check if ToList() executes a query, but it makes sense that it does. I'll remember this, thanks

cumslvt13•11/28/22, 11:16 AM

If it returns something otherwise than IQueryableIQueryable

it executes the query

EsaOP•11/28/22, 11:16 AM

That's useful to know, cheers

Accord•11/29/22, 11:18 AM

Looks like nothing has happened here. I will mark this as stale and this post will be archived until there is new activity.

❔ EntityFramework async where possible?

Similar Threads

Similar Threads

Similar Threads