question

01107111 avatar image
0 Votes"
01107111 asked 01107111 commented

Entity framework code convert to sql

Hi,

I have to convert my ef code to sql, but i have some problems to accomplish this task,
What can be the best ways to retrieve a query from entity framework ?

Thanks

dotnet-entity-framework-core
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Yes, I do, but cant able to capture the query, i run profiler with my user name filter and i dont see the query, probably isnt in real time o something also happen.

0 Votes 0 ·
chbernard avatar image
0 Votes"
chbernard answered

Hello,
with sql server profile you can intercept the query who is send to the database

https://docs.microsoft.com/en-us/sql/tools/sql-server-profiler/sql-server-profiler?view=sql-server-ver15

hope this help

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

chbernard avatar image
0 Votes"
chbernard answered
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DanielZhang-MSFT avatar image
0 Votes"
DanielZhang-MSFT answered

Hi 01107111,
For this question, Oleksii Aza has provided some suggestions in this thread and hope helpful to you.
Best Regards,
Daniel Zhang


If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.