Basically I want to create an inner or join. In SQL: SELECT COUNT(*) FROM Discounts JOIN DiscountArticles ON Discounts.ID = DiscountArticles.Discount JOIN Articles ON (DiscountArticles.Article = Articles.ID OR DiscountArticles.ArticleGroup = Articles.ArticleGroup) This answer says, it’s not possible using entity framework, however we can use an cross join, which works fine on SQL: SELECT COUNT(*) AS… Read More How to join with or condition? Cross Join is creating a IS NULL where clause

I have the following models: public class User { public long Id { get; set; } public string? Name { get; set; } public string? Surname { get; set; } public string? PhoneNumber { get; set; } public IEnumerable<Sale>? Sales { get; set; } } public class Product { [Key] public int Id { get;… Read More How to group data by two fields in C# Linq?

I have this simple entity which may have some children of its own type: public class File { public long Id { get; set; } public File? Parent { get; set; } public long? ParentId { get; set; } public IList<File>? Children { get; set; } public string Name { get; set; } } Actually,… Read More Self-referencing zero or one to many (0-1 -> N) relation in Entity Framework Core 6

I’m trying to implement a global query filter for tenancy within my application. I’ve got AssessmentModels that can have multiple owners, the owners coming from a 3rd party that I don’t have complete control over, but can adjust as needed. (And can manipulate before I save to my database) Right now, the Owners are stored… Read More EF Core Global Query Filter Complex expression