How to see the generated SQL statement in Visual Studio?

[raysefo]

Hello,

I am trying to get the generated SQL statement in order to see the execution plan in SQL Server. Is there a way to get the SQL statement?

//Query GameBank database
var gameBankResult = await _unitOfWork.GameBankRepository.GetGamesAsync(g =>
                     g.productCode == requestDto.productCode && g.referenceId == Guid.Empty);

 

[JohnH]

Try this: Entity Framework View Generated SQL | Entity Framework 6 Tutorial and Documentation

 

[raysefo]

Thank you.