DbContext Check all values and compare

Question

Hello,

I have orders and order details. I want to check all the order details in order to find out if the status of all the order details is completed. There are a couple of statuses; canceled, completed, continues. How to check the statuses in the sample below in order to know if all order details are completed?

await this._db.OrderDetails.Where(x => x.OrderId) == id);  

Thanks.

Answer 1

Keep in mind, we cannot see the schema. If OrderDetails has a Status column then you can get the status value by OrderId using the following.

 (await this._db.OrderDetails.FirstOrDefault(x => x.OrderId == id)).Status;  

If you want to filter by the status column and the status column is a string type then the LINQ syntax is...

this._db.OrderDetails.Where(x => x.Status == "completed");  

The C# programming guide and EF Core fundamentals cover LINQ query syntax.

Introduction to LINQ Queries (C#)
Querying Data

Answer 2

I would recommend storing the status as an int and relate to a status table e.g.

The code to get statues using an order identifier

public class DataOperations  
{  
  
    public static List<OrderDetails> OrdersDetailsList(int orderId, int[] identifiers)  
    {  
        using var context = new NorthContext();  
        return context  
            .OrderDetails  
            .Include(x => x.Product)  
            .Include(x => x.Status)  
            .Where(x => x.OrderId == orderId && identifiers.Contains(x.Status.StatusId))  
            .ToList();  
    }  
}  

If you are using SQL-Server, see full source which shows the above method and the above method with a single status.