tags:

views:

20

answers:

0

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