Is there a way I can run a Database.SqlQuery as async?

Question

I have the following:

var sql = @"Select 
                case when Test.TestTypeId = 1 then Exam.Name
                     when Test.TestTypeId = 2 then Topic.Name
                end as Name,
                Test.Title,
                Test.TestId,
                Test.QuestionsCount
            FROM Test
            LEFT JOIN Exam ON Test.ExamId = Exam.ExamId
            LEFT JOIN Topic ON Test.TopicId = Topic.TopicId
            WHERE Test.TestStatusId = 1 -- Current";
var tests = db.Database.SqlQuery<TestDTO>(sql).ToList();

I was looking for an async method for this but it does not seem to exist. Is there a way that I can run this async?

Kirill Shlenskiy · Accepted Answer · 2014-06-27 14:14:30Z

56

If you're using Entity Framework 6 you just need to specify

using System.Data.Entity;

at the top of your file.

ToListAsync is an extension method on IQueryable<T> declared in System.Data.Entity.QueryableExtensions

answered Jun 27, 2014 at 14:14

Kirill Shlenskiy

9,60730 silver badges41 bronze badges

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

2 Comments

Jean Carlos Over a year ago

As you said, ToListAsync is only to IQueryable, SqlQuery returns IEnumerable<T>

Roman Starkov Over a year ago

@JeanCarlos No, it returns DbRawSqlQuery<T>, which implements IDbAsyncEnumerable<T> as well as methods such as ToListAsync<T> directly.

Collectives™ on Stack Overflow

Is there a way I can run a Database.SqlQuery as async?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related