cannot await 'system.data.entity.infrastructure.dbsqlquery

Question

I'm using Entity Framework 6.1 and am getting the above subject line error. The design time compile error is on the second line starting with the await.

How come I cannot await the SqlQuery? If I remove the await, the clause is fine.

I have the below code snippets:

public async Task<IEnumerable<HH_FuelTkt_Output>> GetFilteredFuelTicketsAsync(HH_FuelTkt_Input value)

var fto = await DbContext.HH_FuelTkt.SqlQuery("SELECT * from HH");

How do you consume fto? (that's where you'd be applying the async mechanics) — Kirk Woll
– Kirk Woll, Commented Apr 29, 2014 at 17:22

Jason P · Accepted Answer · 2014-04-29 17:30:15Z

1

SqlQuery() doesn't return a Task, so you can't await it.

SqlQuery.ToListAsync(), however, does return a Task and can be awaited.

answered Apr 29, 2014 at 17:30

Jason P

27k3 gold badges34 silver badges45 bronze badges

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

2 Comments

sagesky36 Over a year ago

If I include SQL inside the SqlQuery, is it pre-compiled after it executes once like a stored procedure?

Jason P Over a year ago

I don't know the answer to that one, sorry.

Tim · Accepted Answer · 2014-04-29 17:27:36Z

1

DbSet.SqlQuery does not return a Task and is thus not awaitable.

answered Apr 29, 2014 at 17:27

Tim

15.3k1 gold badge49 silver badges71 bronze badges

Collectives™ on Stack Overflow

cannot await 'system.data.entity.infrastructure.dbsqlquery

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related