newbie question: how to view the SQL conversion.
Hello,
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)).
Please help.
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)).
Please help.
Comments
i.e. try changing your code to:
var x = cs.GetOperatorCompanies().Where(c => c.CompanyId == 3).Dump();then you will see the SQL that was executed in the SQL tab in the results pane.
Until you iterate over an IQueryable, whether by using a for loop, a ToList() or Dump(), it doesn't execute any SQL and you won't see anything in this tab. This is because they use what is called lazy evaluation.