now I'm updating everything to .NET 8 and trying to use clean architecture, I'm using Entity Framewokr 8.
It does not make sense to use direct DB calls in the entity class, these Shifts are all saved in the DB and could be edited anytime but the None and DayOff shifts are used very often.
an example is GetShift() method for a staff which has something like this:
public Shift GetShift(DateTime date){ var contract = GetContract(date); if (contract == null) return Shift.None;...}
public Shift GetShift(DateTime date){ var contract = GetContract(date); if (contract == null) return Shift.None;...}
I'm a bit lost on what would be the best way to set this up. I could pass those shifts to the GetShift method from a service but I'm wondering if there's a better solution, this GetShift method is used in a lot of .Where clauses also.