调用线程无法访问此对象

Question

此代码“var results ..”抛出异常“调用线程无法访问此对象，因为不同的线程拥有它”。 LINQ查询不错。

请问我做错了什么？

DataClassesDataContext db = new DataClassesDataContext(); 

    bool doStg() 
    { 
     try 
     { 
      var results = from t in db.table 
          select t; 

      //doing some things.. 

      return true; 
     } 
     catch (Exception Exception) 
     { 
      MessageBox.Show(Exception.Message); 
      return false; 
     } 
    } 

    bool stepByStep() 
    { 
     Dispatcher.BeginInvoke(new Action(() => info.Text = "Step 1"), null); 
     if (!doStg()) { return false; } 
     Dispatcher.BeginInvoke(new Action(() => progressBar.Value = 33), null); 

     Dispatcher.BeginInvoke(new Action(() => info.Text = "Step 2"), null); 
     if (!doStg()) { return false; } 
     Dispatcher.BeginInvoke(new Action(() => progressBar.Value = 66), null); 

     Dispatcher.BeginInvoke(new Action(() => info.Text = "Step 3"), null); 
     if (!doStg()) { return false; } 
     Dispatcher.BeginInvoke(new Action(() => progressBar.Value = 100), null); 

     return true; 
    } 

    private void button_Click(object sender, RoutedEventArgs e) 
    { 
     BackgroundWorker worker = new BackgroundWorker(); 

     worker.DoWork += delegate(object s, DoWorkEventArgs args) 
     { 
      args.Result = stepByStep(); 
     }; 

     worker.RunWorkerCompleted += delegate(object s, RunWorkerCompletedEventArgs args) 
     { 
      object result = args.Result; 
      if ((bool)result) { MessageBox.Show("Done"); } 
      else { MessageBox.Show("Processing stopped."); } 
     }; 

     worker.RunWorkerAsync(); 
    } 

编辑：

异常源： “将System.Data.Linq”

TargetSite：{System.Data.Linq.SqlClient.SqlNode VisitInvocation（System.Linq.Expressions.InvocationExpression ）}

Answer 1

移动下面的代码行：

DataClassesDataContext db = new DataClassesDataContext(); 

放入您的stepByStep()方法体中，然后将db作为参数传递给您的doStg()方法。

bool doStg(DataClassesDataContext db) 
    { 
     try 
     { 
      var results = from t in db.table 
          select t; 

      //doing some things.. 

      return true; 
     } 
     catch (Exception Exception) 
     { 
      MessageBox.Show(Exception.Message); 
      return false; 
     } 
    } 

    bool stepByStep() 
    { 
     DataClassesDataContext db = new DataClassesDataContext(); 

     Dispatcher.BeginInvoke(new Action(() => info.Text = "Step 1"), null); 
     if (!doStg(db)) { return false; } 
     Dispatcher.BeginInvoke(new Action(() => progressBar.Value = 33), null); 

     Dispatcher.BeginInvoke(new Action(() => info.Text = "Step 2"), null); 
     if (!doStg(db)) { return false; } 
     Dispatcher.BeginInvoke(new Action(() => progressBar.Value = 66), null); 

     Dispatcher.BeginInvoke(new Action(() => info.Text = "Step 3"), null); 
     if (!doStg(db)) { return false; } 
     Dispatcher.BeginInvoke(new Action(() => progressBar.Value = 100), null); 

     return true; 
    }