Provide option to disable SQL log in LINQPad?

sdflysha

For some statement, SQL log may very very large:

foreach (var item in data)
{
    item.ProjectId = mapping[item.Project];
}
SubmitChanges();

The data may have millions rows, this will VERY impact the execution performance, so the SQL log window is causing LINQPad useless in this senario.

Is there any option like Util.PreventSQLLog = true; to just prevent the SQL log?

JoeAlbahari

Yes:

ExecutionEngine.SqlTranslationsEnabled = false;

sdflysha

JoeAlbahari It works, thanks.
And I have a question, why it's called SqlTransactionsEnabled?
Sounds like it will disable the SQL Transaction(maybe this is not what I want).
or it's just prevent the SQL logging output window(with a obscure naming)?

JoeAlbahari

It's SqlTranslationsEnabled, not SqlTransactionsEnabled.

The translation of LINQ into SQL.

sdflysha

Sorry, it's my fault😭