Is there a way to increase the sql timeout in subsonic 3 when using LINQ?
Example code
var db = new Edumatic3DB();
var treeNodes = from tn in db.TreeNodes
join ts in db.TreeStructures
on tn.TreeStructureId equals ts.TreeStructureId
where ts.LeftValue > treeStructure.LeftValue &&
ts.RightValue < treeStructure.RightValue &&
ts.TreeId == treeStructure.TreeId
select tn;
_log.Info("Found " + treeNodes.Count() + " treenodes to check.");
foreach (var node in treeNodes)
{
... //sqltimeout