1.I have a BaseModel class: public class BaseModel : BaseDeletedModel { [Key, Column(Order = 0), MaxLength(50), Required] public string ID { get; set; } } public class BaseDeletedModel { [Column(Order = 100), DefaultValue(false)] public bool IsDeleted { get; set; }…
I would like to return all the rows that contains a price higher than 123: // Entity Table1 [Column(TypeName = "jsonb")] public List<NewPrice> HistoryPrices { get; set; } public class NewPrice { public int Price { get; set; } public…
I have the following table: recipe id | ingredients ----+-------------- 1 | "1,2,3" 2 | "3,4" 3 | "2" 4 | "1,2,3,4" I want to find all recipes containing ingredient "1", "3" or "4". How can I achieve that using…
I am trying to use EF Core with MongoDB, I've grouped additional info to separate classes MyInfo and ThirdpartyInfo. internal class MyObject { [BsonId] public ObjectId Id { get; set; } public string Name { get; set; } public MyInfo?…
Once I have added my first Migration Add-Migration InitialMigration, it display this error below, An error occurred while accessing the Microsoft.Extensions.Hosting services. Continuing without the application service provider. Error: Failed to load configuration from file 'C:UsersAmmadsourcereposEmployeesProjectEmployeesProjectappsettings.json'. Unable to create a…
I have a DDD setup in C#, linking entities to DB tables. An entity has a configured Id (primary key) that encapsulates a non-negative, non-zero integer (a value object). I have the primary key configured in EF Core fluent API,…
I'm encountering an issue while trying to insert data using Entity Framework Core in my .NET application. I have a table that I populate with data using an independent SQL script, which inserts records with primary keys (PKs) ranging from…
I'm working with EF Core 6 and PostgreSQL, and I need to construct a query that efficiently retrieves author names along with an array of their book titles. My database schema: Books BookId (number) AuthorId (number) BookName (string) Authors AuthorId…
We created an API, which will fetch data from a SQL view created in the database. Here is the repository code: List<Entities.MyView> reportsData = await ( from r in _context.MyView where r.UserKey == userKey select r) .ToListAsync(cancellationToken); Now, we need…
I have wrote my own source generator which generates some boilerplate converters, including a value converter for EF Core. Here's a short example: [GenerateConverters] public partial record Height(int Value) : StrongTypeComparableRecord<int, Height>(Value) { public partial class HeightValueConverter; public partial class…