I have a request that takes in a list of ids and I want to return objects if they are found within that list for example public async Task<IEnumerable<ChatThread>> GetThreadByIDS(List<long> ids) { // how do I query dbContext to get…
I want to select the multiple column based on if condition, While adding "Select" method as nested it is not working, Getting null for each properties in the class. So how to fix this? public async Task<Form?> GetFormByIdAsync(long formId, string…
I have collection of Images in my Product class: public ICollection<Image> Images { get; set; } = null!; I ran into problem where Images are not being included when I try to take only 4 first products. This code includes…
currently i`m using very bad query to get the data i whant var map = await mapRepository.SingleAsync(x => x.Slug == slug); var groups = await repository.Queryable() .Include(x => x.Categories.Where(c => c.Locations.Any(l => l.MapId == map.Id))) // if not exist gets…
I need a live demo for a product. Said product uses ASP.NET with Entity Framework. Currently I create a new in-memory database like this: var sqliteConnection = new SqliteConnection("DataSource=:memory:"); sqliteConnection.Open(); builder.Services .AddDbContextFactory<DatabaseContext> (options => options.UseSqlite(sqliteConnection, o => o.UseQuerySplittingBehavior(QuerySplittingBehavior.SplitQuery))); However, I…
Why does EF Core add the "RideId1" property to my model "RidePrice"? The error message from EF doesn't provide much help: "The foreign key property 'RidePrice.RideId1' was created in shadow state because a conflicting property with the simple name 'RideId'…
I have following parent and child models public class Director { public int ID { get; set; } public Home? Home { get; set; } } public class Home { public int ID { get; set; } public int DirectorID…
I try to make patients table. I pulled the data from the database with entityframework. But I want to make the gender data male if true then female if false aspx.cs using System; using System.Collections.Generic; using System.Linq; using System.Web; using…
I have a Station entity (in the context of bus stations). This Station entity has a collection of Stations to represent the destinations. How can I map that as a many-to-many relationship in EF Core? public class Station { [Key]…
I wrote a SQL query to get a overview of sales revenue per car manufacturer. Simple enough: select sum(s.Price * s.NumberOfCars) as Revenue, m.Name from Sale as s join Car as c on c.Id = s.CarId join Manufacturer as m…