LinqPad 6.7.5 x64 not displaying SQL translation in SQL window?
For some reason my installation of LinqPad 6 has stopped displaying the SQL from a Linq to Entities query. The results show as expected but clicking on the SQL tab shows a blank window.
Results, IL and Tree show the expected information but the lambda and SQL are both blank.
The query is a simple MyTable.Select(a=>new {Id=a.Id,Name=a.Name }).ToList()
What has happened do my installation to prevent this from displaying the SQL or Lambda translation?
Comments
The call to .ToList() will prevent the lambda translation from showing, because the end-result is an IEnumerable, not an IQueryable. Remove that call and the lambda window should populate.
Regarding the SQL translation, can you provide a screenshot of your connection dialog?