I am trying to do some unit tests where I have the following:
investment = db.Investment
.Include(e => e.Positions.Select(p => p.Transactions))
//.Include(e => e.Positions.Select(p => p.InvestmentCarry))
.Include(e => e.RelatedInvestments)
.Include(e => e.PrivateInvestment)
.Include(e => e.CoInvestment)
.FirstOrDefault(e => e.Id == id)
The time it takes for Effort to execute this is 5 or more minutes. I have another LINQ query that is similar that takes 14 minutes on our build server.
Any ideas? Does Effort need to be adjusted somehow? Maybe I need to reconsider how I've set up my query, although in a database environment it executes quickly.