How to use with async

[SharpNoiZy]

Hi jkodroff,

I followed your tutorial and everything is awesome!
Except the fact that I don't know how to use it with async and await.
Can you advise how to do that?

var dbResult = await from user in _dataSession.Set<User>()
                           join role in _dataSession.Set<UserRole>() on user.UserRoleId equals role.Id
                           where user.UserName == query.Username && user.PasswordHash == hashedPassword
                           select new { User = user, Role = role };

The only thing I changed of your code is that .Set<> returns IQuerable<> instead of DbSet<> because I want to use the same code later on with EF7.

Kind regards

[jkodroff]

@SharpNoiZy Check out #3 for async support and let me know what you think. I'll take on EF 7 in another branch/PR.

[jkodroff]

@SharpNoiZy I tried updating to EF 7 and it doesn't look like this code applies. See here for the deets.

[SharpNoiZy]

@jkodroff
Hi, thanks for all your work at this topic!
I know your articles focus was on Testing EF, but for me also the fact that I can use an interface IDataSession with DI was an important part of you article.
And I have the situation that I will use now EF 6 with MySQL, but if EF 7 final 1.0 is released and the Oracle Provider for EF supports EF 7, I will switch to Oracle and EF7.
But I don't wanna change my hole code (For that reason I use DI), so you article solved also this issue for me!
The only thing I changed, like I already set was:
.Set<> returns IQuerable<> instead of DbSet<> for being ready for EF7.

So, I'm interested in using IDataSession also with EF7, and on both framework versions with async without changing the code, can you help me on this, too?