Linq query with too many includes exception


I am using EF6 and I have a query that selects only one entity from the database but with including all of the related entities. I am selecting only one using FirstOrDefault() method but sometimes this exception appears

System.Data.SqlClient.SqlException (0x80131904): Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction.

Here is the code that causes the issue

return All()
                .Include(p => p.Location)
                .Include(m => m.Bookings)
                .Include(p => p.Links)
                .Include(p => p.Links1)
                .Include(p => p.Details)
                .Include(p => p.Details.Select(x => x.Diagnostic))
                .Include(p => p.Alerts)
                .Include(p => p.Allergies)
                .Include(p => p.Allergies.Select(x => x.List.ListCategory))
                .Include(p => p.Links.Select(x => x.Link1))
                .Include(p => p.Links1.Select(x => x.Link))
                .FirstOrDefault(n => n.Id == id);
asked on Stack Overflow Sep 7, 2020 by TinyDev

0 Answers

Nobody has answered this question yet.

User contributions licensed under CC BY-SA 3.0