C
C#•6mo ago
_vegabyte_

Trying to create a notification service

Hi, I'm trying to create a notification service. My initial setup is I create a command that counts based on the query from where my data is. But the problem is the condition for the query is getting complicated and everytime there is a new condition to the query I need to update the Notification Service. Is there any way to simplified the Notification Services. Any suggestions and advice are well much appreciated. Thank you
No description
2 Replies
Angius
Angius•6mo ago
I'm not sure how the query would be changing? You have a Notifications table with... notifications There's an FK to the user for whom the notification is And maybe a IsRead bool 
var count = await _ctx.Notifications
    .Where(n => n.UserId == id)
    .Where(n => n.IsRead == false)
    .CountAsync();
var count = await _ctx.Notifications
    .Where(n => n.UserId == id)
    .Where(n => n.IsRead == false)
    .CountAsync();
life grinder
life grinder•6mo ago
usually the way to simplify stuff is extracting/isolating (a part of) the logic 🤷‍♂️
Want results from more Discord servers?
Add your server
More Posts
✅ Trying To Get Better At Database Command Executioncode : https://pastebin.com/hH3nGTMe how database is created: https://pastebin.com/wHLmbu9w In my chave a class based of identity user. however when I try to find a user it returns nullHelpan issue with my methodI got help earlier on how to declare a method from my class to Program.cs and i decided to make the ✅ Visual Studio debugging issue with assembly info attributeI'm working on my game, and very often when I EaC or hot reload, the console will output:```Distracti am struggling to make a method code.i am trying to declare my method in the program cs but i dont know howduende identity serverHey guys I have setup duende identity server which gives me jwt token and I have react-vite applicat✅ Opinion time: Handling multiple id's in the same path (ASP.NET MVC)I want to make surveys and survey submissions. The URL will be something like `/surveys/1/submissionHelp with Lists and index.Im making a game for a project and my current code randomly generates coins in different locations, Cannot resolve AddAuthentication()I'm setting up a Minimal API in C# with .NET 6.0 but cannot seem to be able to use the `AddAuthenticHow to Create Maui-App with Asp.Net Api + SQL Express?Hello, For the past few days, I've been looking into how I can create a Maui application that will h