Entity Framework Core - Knowledge Base (KB)

Insert data into multiple table in entity framework

I have 2 tables like below. am using DB first approch...public class Team { public long Id { get; set; } public string Name { get; set; } public string Description { get; set; } } public class Employee { public long Id { get; set; } p...

Create a Class for extend Model Classes in EF code first

I have a model class that has for example 3 properties and corresponding table in my data base. ...public partial class Person { public string prop1 {set; get;} public string prop2 {set; get;} public string prop3 {set; get;} } ...Now I want de...

c# Lambda Query fetching one of the property weirdly null

[HttpGet] public ActionResult SecondMission(string Id) { CATSDDEntities db = new CATSDDEntities(); db.Configuration.ProxyCreationEnabled = false; var setAlet= db.Setalets.Where(x => x.Aletler.Barkod == Id && x.Bolum == ...

Entity Framework Core - Unique Constraint

I have two models (User and Game) They are connected by another model named PlayerID. For Instance a user can have an special ID for each game. I would like to set it to that a user can only have one ID for each game. What is the best practice for that? ....

Why the include function is not including the navigational property of the model?

I have these 2 models:...Phones:...public class Phones { public int ID { get; set; } public string Model { get; set; } public string Manufacturer { get; set; } // e.g. XIAOMI, NOKIA, IPHONE public int UserID { get; ...

Adding item to collection navigation property in EF Core

I have a ...Project... class that contains a collection of ...AppUsers...public class Project { public int ProjectID { get; set; } [Required(ErrorMessage = " Please enter a project name")] public string Name { get; set; } [Required(Error...

Cannot create a DbSet for 'ApplicationUser' because this type is not included in the model for the context

When trying to add a new user using entity framework core I get the above error code. I know this has been asked on here before but I can't fix my issue with the solutions I have found so far....Im trying to create a user with a username (email) and passw...

System.InvalidOperationException: 'No suitable constructor found for entity type 'HealthCheck'

I get this error when trying to add something on my db through EF Core. ...System.InvalidOperationException: 'No suitable constructor found for entity type 'HealthCheck'. The following constructors had parameters that could not be bound to properties ...

How can I add coreIdentity to existing DB

I have problem with adding Microsoft.AspNetCore.Identity.EntityFrameworkCore to my project. I have created db already (code-first) and now i need to add some tables, that are necessary to create login and register system....i've tried to do some tutorials...