Creating an Entity Framework model from JSON Object

Question

Using the following JSON object I want to create models in EF and their navigation properties also need model.Builder Entity

Also need information on one to many relation using the json specified below and using migrations create database tables.

[{

"Title": "AC",
"IconClass": "ac",
"Departments": "Housekeeping,Maintenance",
"Status": "NotInOrder",
"Parts": [{
    "Title": "Power",
    "IconClass": "power",
    "Departments": "Housekeeping,Maintenance",
    "Status": "NotInOrder",
    "DependentUpon": "",
    "Id": null
}, {
    "Title": "Remote",
    "IconClass": "remote",
    "Departments": "Housekeeping,Maintenance",
    "Status": "CleanedMaintained",
    "DependentUpon": "Power",
    "Id": null
}, {
    "Title": "Cooling",
    "IconClass": "cooling",
    "Departments": "Housekeeping,Maintenance",
    "Status": "CleanedMaintained",
    "DependentUpon": "Remote",
    "Id": null
}],
},
{

"Title": "TV",
"IconClass": "tv",
"Departments": "Housekeeping,Maintenance",
"Status": "CleanedMaintained",
"Parts": [{
    "Title": "Power",
    "IconClass": "power",
    "Departments": "Housekeeping,Maintenance",
    "Status": "CleanedMaintained",
    "DependentUpon": "",
    "Id": null
}, 
{
    "Title": "TV - Remote",

    "IconClass": "remote",
    "Departments": "Housekeeping,Maintenance",
    "Status": "CleanedMaintained",
    "DependentUpon": "Power",
    "Id": null
}]
]

TanvirArjel · Accepted Answer · 2018-09-05 08:21:21Z

1

According to your JSON object, your Entity Framework model classes should be as follows:

public class Product
{
    [Key]
    public int ProductId {get; set;}
    public string Title { get; set; }
    public string IconClass { get; set; }
    public string Departments { get; set; }
    public string Status { get; set; }

    public ICollection<Part> Parts { get; set; }
}

public class Part
{
    [Key]
    public string Id { get; set; }
    [ForeignKey("Product")]
    public int ProductId {get; set;}
    public string Title { get; set; }
    public string IconClass { get; set; }
    public string Departments { get; set; }
    public string Status { get; set; }
    public string DependentUpon { get; set; }

    public Product Product {get; set;}

}

Then the DbContext:

public class YourDbContext : DbContext
{
    public YourDbContext () : base("name=DefaultConnection")
    {
    }

    public static YourDbContext  Create()
    {
        return new YourDbContext ();
    }

    public DbSet<Product> Products { get; set; }

    public DbSet<Part> Parts { get; set; }

}

edited Sep 5, 2018 at 8:21

answered Sep 5, 2018 at 8:07

TanvirArjel

32.4k14 gold badges89 silver badges120 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

Priyanka Over a year ago

public class Product { [StringLength(100)] public string Title { get; set; } [StringLength(100)] public string IconClass { get; set; } public virtual ICollection<Department> Departments { get; set; } [JsonConverter(typeof(StringEnumConverter))] public RoomSubEntityPartStatus Status { get; set; } public virtual ICollection<RoomSubPart> RoomSubParts { get; set; } [StringLength(100)] public string DependentUpon { get; set; } }

TanvirArjel Over a year ago

@Priyanka look at my updated answer! This will be generalized solution. Now you can change things accordingly!

Priyanka Over a year ago

Yeah, but I have an exception to the changes I made, Introducing FOREIGN KEY constraint 'FK_dbo.RoomParts_dbo.RoomEntities_RoomEntityId' on table 'RoomSubParts' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints. Here RoomParts : Parts, RoomSubEntities : Products

TanvirArjel Over a year ago

@Priyanka Share classes modifying the question

Priyanka Over a year ago

Ok give me half an hour

|

Collectives™ on Stack Overflow

Creating an Entity Framework model from JSON Object

1 Answer 1

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related