EF core keeps making up table names and columns? Table 'player_roles' doesn't exist Bare in mind I'm using snake_case column naming. I have 5 tables players players_roles (bridge table) roles roles_permissions (bridge table) permissions With the following entities: public class…
I have a many to one relation between two models in a .NET Web API Entity Framework project. Each model has a Navigation property to the other model. This as expected generates a "JsonException: A possible object cycle was detected."…
I have two collections in MongoDB with many-to-many relationship. Many users can be cast in many roles. It looks like Entity Framework is adapted only for relational databases, where an helper table between two entities is used as a join…
I get an error when insert record in MySQL database with Microsoft Entity Framerk. Mi table is CREATE TABLE IF NOT EXISTS `preventive` ( `IDPREVENTIVE` mediumint(9) NOT NULL AUTO_INCREMENT, `DESCRIPTION` text, `DATA_CRE` datetime DEFAULT NULL, UNIQUE KEY `preventive_unique` (`CODICE`) )…
I have a Asp.Net project where I try to migrate a Database with a DbContext. Unfortunately, I get the Error Unable to create a 'DbContext' of type ''. The exception 'Unable to resolve service for type 'Microsoft.EntityFrameworkCore.DbContextOptions`1[Bulky.DataAccess.Data.ApplicationDbContext]' while attempting to…
In Entity Framework 7 what would be the best way to do batchInsert to a table which is mapped using entity framework but I want to make sure that this is one transaction so either all objects are inserted or…
Consider the following very big object stored in database being access via Entity Framework (EF Core 8): public record VeryBigObject(int Id, string Name, string LotsOfData); And a corresponding DTO: public record VeryBigObjectDto(int Id, string Name); In real life, there are…
I have a given entity 'Student' with application based concurrency control defined on 'LastModified'. public class Student { public int Id { get; set; } public string Name { get; set; } = null!; public DateTimeOffset Created { get; set;…
I am working on a legacy Asp.Net MVC 5 project. We do not have a proper data access layer, and our business layer classes directly interact with the DbContext, which is injected. I am facing a problem, the essence of…
My question is based on a similar question but with the added complexity of pagination. public class Parent { public Parent() { this.Children = new List<Child>(); } public int Id { get; set; } public virtual ICollection<Child> Children { get;…