Get Parent based on string value and all its children with Entity Framework Core

Entity Framework 6: Adding child object to parent's list vs. setting child's navigation property to parent

I have an existing database with two tables ...MailServers... and ...MailDomains... in it. ...MailDomains... has the foreign key column ...MailServerId... pointing to the ...Id... primary key column in ...MailServers.... So we have a one-to-many-relationship here....I followed ...this article... and created my Entity Framework POCOs via the "Code f...

Deleting parent-child relation with Entity Framework or Entity Framework Core

I'm learning how to use Entity Framework, having a NHibernate background. There are plenty of tutorials on the net, but I didn't find something for my specific case. I don't want to delete the Category record, I only want to delete the relation!...I have following poco's:... public class TrainingCourse { [Key] public int Cour...

Add child entities to database and assign them to parent object in database Entity Framework Core

I have a datamodel named "Document" which looks like this:...public class Document { [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int Id { get; set; } //[ForeignKey("Id")] public List<DocumentLine> Lines { get; set; } public DateTime PurchaseDate { get; set; } public double TotalValue { get; set; } } ...It...

Entity Framework Core - recursive parent/child linking

I have an "account" table that includes a string foreign-key ("parent_guid") to it's "parent" account (if one exists). I would like to create an entity that knows its parent, as well as all of its children....Here is my entity:...[Table(name:"accounts")] public class Account { [Key] public string Guid { get; set; } public string Name {...

Entity Framework Core to Json Ignore ReferenceLoop - Parent Child

I having entity class with parent-child relationship that having problem serializing to json using newtonsoft json.net...public class Department { [Key] public int DepartmentId { get; set; } public int? ParentId { get; set; } public Department Parent { get; set; } public ICollection<Department>...

Removing child entity from parent entity - EF Core 2.2

I would like to remove an item from collection which exist in one entity. The problem I face is:...-entity is being removed from context...-after save changes the entity still exists...The Parent object:...public class MyObject { public int Id { get; private set; } public ICollection<ChildObject> ChildObjcets { get; private set; } publ...

Entity Framework Core : Access parent from child

EF Core allows you to access the associated ...shadow property... in LINQ to Entities query using the ...EF.Property... method:...Addresses a given property on an entity instance. This is useful when you want to reference a shadow state property in a LINQ query. Currently this method can only be used in LINQ queries and can not be used to access th...

Add or Update child entities when updating a parent entity in Entity Framework Core

In a new project we are using Entity Framework Core instead of EntityFramework 6.2.0. Works good but it causes a problem when updating a parents children while also inserting new children....Example:...Current model:...public class Profile { public Profile() { Interests = new List<Interest>(); } [Key] [DatabaseGenerate...

Avoid attaching parent entity on child entities using EF Core

I got this hierarchical table setup Company has a reference to Postal and Postal has a reference to Area. I'm using EF Core....class Company { CompanyId, .., PostalId, Postal } class Postal { PostalId, .., Company } class Area { AreaId, .., Postal } ...My problem is that the Company entity is added to every Postal entity like a circual reference...

Entity Framework Core Parent Child items in the same model, children node returns null

I have a parent and child property inside one domain model....public class TestModel { public int ParentID { get; set; } public int ID{ get; set; } public string Name{ get; set; } public virtual TestModel parent { get; set; } public virtual List<TestModel> children { get; set; } } ...When I write ...OnModelCreating... event as b...