How to get monthly order count by status in a Blazor Server application?

Question

How to get monthly order count by status in a Blazor Server application?

Cenk 1,051

Hello, I am working on a Blazor Server application and need to find the number of monthly orders that are either completed or continue based on their status. I have a query that works for a specific year and status, but I need to refactor it to accept status and year as parameters. Here is the query I have so far:

Orders
.Where(x => x.OrderDateTime.Year == DateTime.Now.Year)
.GroupBy(x => new { Month = x.OrderDateTime.Month, Status = x.Status })
.Select(u => new 
        {
            Month = u.Key.Month,
			Status = u.Key.Status,
			Count = u.Count()
            
        })
		.OrderBy(u => u.Month)

Locked Question. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Answer 1

Wenbin Geng 746 Microsoft External Staff

Hi @Cenk, Welcome to Microsoft Q&A.

I'm glad you were able to resolve your issue. Below I will explain some reasons so that you can have a deeper understanding of Blazor Server and EF Core.

You are trying to use DateTime.Now.Year as part of a query criteria. This means you are trying to use the current year in C# in a LINQ query. However, Blazor Server applications execute on the server side, not the client, so DateTime.Now will return the server's current date and time, not the client's.

So when you specify the year and status, you can get the query you want.

Best Regards,

Wenbin

---If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Con Kauer 0 Reputation points

2026-09-18T17:02:35.5833333+00:00

I have a Blazor app that adds income and subtracts expenses to a budget stored in sql how can i add them

to a monthly persistant record
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
JuliaMarvin 22,615 Reputation points Volunteer Moderator

2026-09-19T05:23:37.7933333+00:00

@Con Kauer
Please start your own thread/question.

Answer 2

Lorenzo Regalado 0

Something like this ?

var query = Orders
        .Where(x => x.OrderDateTime.Year == year && x.Status == status)
        .GroupBy(x => new { Month = x.OrderDateTime.Month })
        .Select(u => new
        {
            Month = u.Key.Month,
            Status = status,
            Count = u.Count()
        })
        .OrderBy(u => u.Month);

Cenk 1,051

this worked for me.

Orders
        .Where(x => x.OrderDateTime.Year == 2023 && x.Status == "Continues")
        .GroupBy(x => new { Month = x.OrderDateTime.Month, Status = x.Status })
        .Select(
            u => new { Month = u.Key.Month, Status = u.Key.Status, Count = u.Count() })
        .OrderBy(u => u.Month)