{"action":"created","issue":{"url":"https://api.github.com/repos/aspnet/EntityFramework/issues/6482","repository_url":"https://api.github.com/repos/aspnet/EntityFramework","labels_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/6482/labels{/name}","comments_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/6482/comments","events_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/6482/events","html_url":"https://github.com/aspnet/EntityFramework/issues/6482","id":175479177,"number":6482,"title":"Provide a simple way to get SQL statements generated from EF queries","user":{"login":"dotnetjalps","id":5141580,"avatar_url":"https://avatars0.githubusercontent.com/u/5141580?v=3","gravatar_id":"","url":"https://api.github.com/users/dotnetjalps","html_url":"https://github.com/dotnetjalps","followers_url":"https://api.github.com/users/dotnetjalps/followers","following_url":"https://api.github.com/users/dotnetjalps/following{/other_user}","gists_url":"https://api.github.com/users/dotnetjalps/gists{/gist_id}","starred_url":"https://api.github.com/users/dotnetjalps/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dotnetjalps/subscriptions","organizations_url":"https://api.github.com/users/dotnetjalps/orgs","repos_url":"https://api.github.com/users/dotnetjalps/repos","events_url":"https://api.github.com/users/dotnetjalps/events{/privacy}","received_events_url":"https://api.github.com/users/dotnetjalps/received_events","type":"User","site_admin":false},"labels":[{"id":76481854,"url":"https://api.github.com/repos/aspnet/EntityFramework/labels/type-enhancement","name":"type-enhancement","color":"bfe5bf","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/aspnet/EntityFramework/milestones/2","html_url":"https://github.com/aspnet/EntityFramework/milestone/2","labels_url":"https://api.github.com/repos/aspnet/EntityFramework/milestones/2/labels","id":648040,"number":2,"title":"Backlog","description":"Issues that have been approved but are not scheduled a specific release.","creator":{"login":"bricelam","id":1226749,"avatar_url":"https://avatars1.githubusercontent.com/u/1226749?v=3","gravatar_id":"","url":"https://api.github.com/users/bricelam","html_url":"https://github.com/bricelam","followers_url":"https://api.github.com/users/bricelam/followers","following_url":"https://api.github.com/users/bricelam/following{/other_user}","gists_url":"https://api.github.com/users/bricelam/gists{/gist_id}","starred_url":"https://api.github.com/users/bricelam/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bricelam/subscriptions","organizations_url":"https://api.github.com/users/bricelam/orgs","repos_url":"https://api.github.com/users/bricelam/repos","events_url":"https://api.github.com/users/bricelam/events{/privacy}","received_events_url":"https://api.github.com/users/bricelam/received_events","type":"User","site_admin":false},"open_issues":364,"closed_issues":33,"state":"open","created_at":"2014-05-03T18:58:28Z","updated_at":"2017-05-17T22:47:08Z","due_on":null,"closed_at":null},"comments":13,"created_at":"2016-09-07T11:30:17Z","updated_at":"2017-05-21T13:43:00Z","closed_at":null,"body":"Hello Team, \n\nFirst of all congratulations for this awesome product. We are using it in very extensively. I have one question there. Is there any way to get SQL statement generated in Entity Framework Core. We want to see SQL statements generated and based on that optimize the queries that we are using. \n\nI tried searching it on documentation as well online but have not found anything. Please let me know if there is a way to do this. Right now the only way to profile the database. But in some cases it costs us more when we use Azure SQL databases.\n\nThank you for anticipation in advance!\n### Further technical details\n\nEF Core version: 1.0.0\nOperating system: Windows 10 Professional\nVisual Studio version: Visual Studio 2015\n\nOther details about my project setup: ASP.NET Core, Angular js 1.5 and Entity Framework Core 1.0 with Azure SQL database.\n"},"comment":{"url":"https://api.github.com/repos/aspnet/EntityFramework/issues/comments/302937553","html_url":"https://github.com/aspnet/EntityFramework/issues/6482#issuecomment-302937553","issue_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/6482","id":302937553,"user":{"login":"abhishekbdutta","id":16938841,"avatar_url":"https://avatars0.githubusercontent.com/u/16938841?v=3","gravatar_id":"","url":"https://api.github.com/users/abhishekbdutta","html_url":"https://github.com/abhishekbdutta","followers_url":"https://api.github.com/users/abhishekbdutta/followers","following_url":"https://api.github.com/users/abhishekbdutta/following{/other_user}","gists_url":"https://api.github.com/users/abhishekbdutta/gists{/gist_id}","starred_url":"https://api.github.com/users/abhishekbdutta/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/abhishekbdutta/subscriptions","organizations_url":"https://api.github.com/users/abhishekbdutta/orgs","repos_url":"https://api.github.com/users/abhishekbdutta/repos","events_url":"https://api.github.com/users/abhishekbdutta/events{/privacy}","received_events_url":"https://api.github.com/users/abhishekbdutta/received_events","type":"User","site_admin":false},"created_at":"2017-05-21T13:42:59Z","updated_at":"2017-05-21T13:42:59Z","body":"The above solution is not logging the DDL statements"}}
{"actor":{"display_login":"abhishekbdutta"}}