A second operation was started on this context instance before a previous operation completed. This is usually caused by different threads concurrently using the same instance of DbContext. For more information on how to avoid threading issues with DbContext, see https://go.microsoft.com/fwlink/?linkid=2097913.

The LINQ expression 'DbSet<SalesTable>() .Where(inv => inv.CId == __companyId_0 && inv.FinancialYear == __financialYear_1 && (int)inv.Status == 1 && (int)inv.InvoiceType == 0 || (int)inv.InvoiceType == 10 && inv.Markets != null && inv.Customer != null) .GroupBy(inv => new { MarketId = inv.Markets, CustomerId = inv.Customer }) .Join( inner: DbSet<LedgerTable>(), outerKeySelector: g => g.Key.CustomerId, innerKeySelector: cust => (int?)cust.ID, resultSelector: (g, cust) => new { g = g, cust = cust })' could not be translated. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to 'AsEnumerable', 'AsAsyncEnumerable', 'ToList', or 'ToListAsync'. See https://go.microsoft.com/fwlink/?linkid=2101038 for more information.

The LINQ expression 'DbSet<SalesTable>() .Where(inv => inv.CId == __companyId_0 && inv.FinancialYear == __financialYear_1 && (int)inv.Status == 1 && (int)inv.InvoiceType == 0 || (int)inv.InvoiceType == 10 && inv.Markets != null && inv.Customer != null) .GroupBy(inv => new { MarketId = inv.Markets, CustomerId = inv.Customer }) .Join( inner: DbSet<LedgerTable>(), outerKeySelector: g => g.Key.CustomerId, innerKeySelector: cust => (int?)cust.ID, resultSelector: (g, cust) => new { g = g, cust = cust })' could not be translated. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to 'AsEnumerable', 'AsAsyncEnumerable', 'ToList', or 'ToListAsync'. See https://go.microsoft.com/fwlink/?linkid=2101038 for more information.

The LINQ expression 'DbSet<SalesTable>() .Where(inv => inv.CId == __companyId_0 && inv.FinancialYear == __financialYear_1 && (int)inv.Status == 1 && (int)inv.InvoiceType == 0 || (int)inv.InvoiceType == 10 && inv.Markets != null && inv.Customer != null) .GroupBy(inv => new { MarketId = inv.Markets, CustomerId = inv.Customer }) .Join( inner: DbSet<LedgerTable>(), outerKeySelector: g => g.Key.CustomerId, innerKeySelector: cust => (int?)cust.ID, resultSelector: (g, cust) => new { g = g, cust = cust })' could not be translated. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to 'AsEnumerable', 'AsAsyncEnumerable', 'ToList', or 'ToListAsync'. See https://go.microsoft.com/fwlink/?linkid=2101038 for more information.

The LINQ expression 'DbSet<SalesTable>() .Where(inv => inv.CId == __companyId_0 && inv.FinancialYear == __financialYear_1 && (int)inv.Status == 1 && (int)inv.InvoiceType == 0 || (int)inv.InvoiceType == 10 && inv.Markets != null && inv.Customer != null) .GroupBy(inv => new { MarketId = inv.Markets, CustomerId = inv.Customer }) .Join( inner: DbSet<LedgerTable>(), outerKeySelector: g => g.Key.CustomerId, innerKeySelector: cust => (int?)cust.ID, resultSelector: (g, cust) => new { g = g, cust = cust })' could not be translated. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to 'AsEnumerable', 'AsAsyncEnumerable', 'ToList', or 'ToListAsync'. See https://go.microsoft.com/fwlink/?linkid=2101038 for more information.

The LINQ expression 'DbSet<SalesTable>() .Where(inv => inv.CId == __companyId_0 && inv.FinancialYear == __financialYear_1 && (int)inv.Status == 1 && (int)inv.InvoiceType == 0 || (int)inv.InvoiceType == 10 && inv.Markets != null && inv.Customer != null) .GroupBy(inv => new { MarketId = inv.Markets, CustomerId = inv.Customer }) .Join( inner: DbSet<LedgerTable>(), outerKeySelector: g => g.Key.CustomerId, innerKeySelector: cust => (int?)cust.ID, resultSelector: (g, cust) => new { g = g, cust = cust })' could not be translated. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to 'AsEnumerable', 'AsAsyncEnumerable', 'ToList', or 'ToListAsync'. See https://go.microsoft.com/fwlink/?linkid=2101038 for more information.

The LINQ expression 'DbSet<SalesTable>() .Where(inv => inv.CId == __companyId_0 && inv.FinancialYear == __financialYear_1 && (int)inv.Status == 1 && (int)inv.InvoiceType == 0 || (int)inv.InvoiceType == 10 && inv.Markets != null && inv.Customer != null) .GroupBy(inv => new { MarketId = inv.Markets, CustomerId = inv.Customer }) .Join( inner: DbSet<LedgerTable>(), outerKeySelector: g => g.Key.CustomerId, innerKeySelector: cust => (int?)cust.ID, resultSelector: (g, cust) => new { g = g, cust = cust })' could not be translated. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to 'AsEnumerable', 'AsAsyncEnumerable', 'ToList', or 'ToListAsync'. See https://go.microsoft.com/fwlink/?linkid=2101038 for more information.

A transport-level error has occurred when receiving results from the server. (provider: Session Provider, error: 19 - Physical connection is not usable)

Invalid file signature.

An exception has been raised that is likely due to a transient failure. Consider enabling transient error resiliency by adding 'EnableRetryOnFailure' to the 'UseSqlServer' call.

A transport-level error has occurred when receiving results from the server. (provider: Session Provider, error: 19 - Physical connection is not usable)

A transport-level error has occurred when receiving results from the server. (provider: Session Provider, error: 19 - Physical connection is not usable)

The CancellationTokenSource has been disposed.

Invalid file signature.

Data is Null. This method or property cannot be called on Null values.