How to get sql from a efcore sentense?

Question

What I want to do is create a conventor from efcore to sql.

for example.

I have entity:MyStudent

DbSet<MyStudent>MyStudents{get;set;};  

and there is a textblock.

I enter a sentence of efcore.

var query=await _context.MyStudents.AsNoTracking().Where(x=>x.Id==10);  

I can get the sql:

SELECT ID,NAME FROM MyStudent WHERE Id = 10;  

help me please.

Answer 1

I think you are asking how to see the SQL generated by EF Core. Please see the official documentation.

Overview of Logging and Interception