I am a LinqPad 5 newbie. I'm trying to write a lambda linq query in C# and I'm not sure how to see the conversion to SQL.
I have successfully connected to a database, referenced my dlls, and configured the app.config file properly (at least I'm not getting any errors).
So I'm trying the following script:
ACM.RiskAlive.Core.Services.CompanyService cs = new ACM.RiskAlive.Core.Services.CompanyService(new ACM.RiskAlive.Core.Data.RiskAliveEntities());
var x = cs.GetOperatorCompanies().Where(c => c.CompanyId == 3);
GetOperatorCompanies() returns IQueryable.
But when I run this script, I get no output.
There must be some way of telling LinqPad that I want to see x being converted to SQL (or the expression cs.GetOperatorCompanies().Where(c => c.CompanyId == 3)).