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…
I'm working on a gift card system where I have two main database tables: GiftCards and ActivationCodes. Each gift card can have many pre-generated activation codes, and after a user purchases a gift card, they should receive one of the…
I'm trying to use appsettings.json to store the database connection string to use different strings for build configurations. But, I'm getting this exception: System.InvalidOperationException: A named connection string was used, but the name 'ConnectionStrings:DefaultConnection' was not found in the application's…