Devart Forums

Code: Select all

public void Test()
{
  var tasks = new List<Task>();
  for (var i = 0; i < numberOfTasks; i++)
  {
    var serverId = i;
    var task = Task.Factory.StartNew(() => Foo(serverId));
    tasks.Add(task);
  }
  Task.WaitAll(tasks.ToArray());
}

private void Foo(string serverId)
{
  using (var context = new DataContext(connectionString))
  {
    (from server in context.Server
     where server.Id == serverId
     select server.Name).First();
  }
}

Code: Select all

System.InvalidOperationException
Cannot add query to cache. An item with the same key already exists.
   at Devart.Data.Linq.Engine.LinkedCache`2.a(TKey A_0, TItem A_1)
   at Devart.Data.Linq.Engine.b3.a(Int32 A_0, cy A_1)
   at Devart.Data.Linq.Engine.bj.a(ci A_0, SqlExpression A_1)
   at Devart.Data.Linq.Engine.ah.a(bq A_0)
   at Devart.Data.Linq.Engine.ah.e(Expression A_0)
   at Devart.Data.Linq.DataProvider.a(Expression A_0)
   at Devart.Data.Linq.Engine.DataQuery`1.System.Linq.IQueryProvider.Execute(Expression expression)
   at System.Linq.Queryable.First(IQueryable`1 source)

Code: Select all

public static CompiledQueryCache compiledQueryCache = CompiledQueryCache.RegisterDataContext(typeof([YourDataContextType]));

Code: Select all

class DataContextImpl : TestDataContext
{
    public DataContextImpl(string connection) : base(connection)
    {
    }

    public DataContextImpl(IDbConnection connection) : base(connection)
    {
    }

    public DataContextImpl(string connection, MappingSource mappingSource) : base(connection, mappingSource)
    {
    }

    public DataContextImpl(IDbConnection connection, MappingSource mappingSource) : base(connection, mappingSource)
    {
    }
}