how to deserialize json array in asp.net core api in post method?

ehsan khosravi

how i can solve this problem (serialized/ and deserialize JSON array and store and read from sql server)? thank you

i created asp.net core api that connected to angular project and occurs problem when i want post json that contains json array(ingredient) :

{ "RecepieName": "3222",

"Ingredient": [ { "ingredientName": "43243", "value": "33", "measure": "" },

{ "ingredientName": "565" , "value": "3", "measure": "" }],

"CookingTime": 3,

"Level": "advance",

"ServingPerson": 3,

"RecepieAbstration": "good food",

"RecepieText": "",

"CreateDate": "2021-01-04T12:37:51.948",

"ModifiedDate": "2021-01-04T12:37:51.948" }

you can see my model , dto and action post in controller and DbContext :

Model :

public class Recepie
{
[Key]
public int ID { get; set; }
[Required]
public string RecepieName { get; set; }
[Required]
public string Ingredient { get; set; } // include ingredientName / value / measure array
[Required]
public int CookingTime { get; set; }
[Required]
public string Level { get; set; }
[Required]
public int ServingPerson { get; set; }
[Required]
public string RecepieAbstration { get; set; }
[Required]
public string RecepieText { get; set; }
[Required]
public string NutritionalInformation { get; set; }
[Required]
public string Tags { get; set; }
public DateTime CreateDate { get; set; }
public DateTime ModifiedDate { get; set; }
}

DTO : RecepieCreateDto

public class RecepieCreateDto
public string RecepieName { get; set; }
//public int MentorID { get; set; }
public string Ingredient { get; set; }
public int CookingTime { get; set; }
public string Level { get; set; }
public int ServingPerson { get; set; }
public string RecepieAbstration { get; set; }
public string RecepieText { get; set; }
public string Tags { get; set; }
public DateTime CreateDate { get; set; }
public DateTime ModifiedDate { get; set; }

Action Post :

//Post api/recepie
[HttpPost]
public ActionResult CreateRecepie(RecepieCreateDto recepieCreateDto)
{
var recepieModel = _mapper.Map(recepieCreateDto);
_repository.CreateRecepieObject(recepieModel);
_repository.SaveChange();
var recepieReadDto = _mapper.Map(recepieModel);
return CreatedAtRoute(nameof(GetRecepieByID), new { Id = recepieReadDto.ID }, recepieReadDto);
// return Ok(recepieModel);
}

DbContext :

public class FoodpackContext : DbContext
{
public FoodpackContext(DbContextOptions opt):base(opt)
{
}
public DbSet Recepies { get; set; }

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar5y ago
1)Create View model For input Api
public class RecepieCreateViewModel
   {
        public string RecepieName { get; set; }
public List Ingredient { get; set; }
public int CookingTime { get; set; }
public string Level { get; set; }
public int ServingPerson { get; set; }
public string RecepieAbstration { get; set; }
public string RecepieText { get; set; }
public string NutritionalInformation { get; set; }
public string Tags { get; set; }
public DateTime CreateDate { get; set; }
public DateTime ModifiedDate { get; set; }
    }
public class Ingredient
    {
        public string ingredientName { get; set; }
        public string value { get; set; }
        public string measure { get; set; }
    }
2)Create Dto Model
public class RecepieCreateDto
{
    public string RecepieName { get; set; }
    public string Ingredient { get; set; }
    public int CookingTime { get; set; }
    public string Level { get; set; }
    public int ServingPerson { get; set; }
    public string RecepieAbstration { get; set; }
    public string RecepieText { get; set; }
    public string NutritionalInformation { get; set; }
    public string Tags { get; set; }
    public DateTime CreateDate { get; set; }
    public DateTime ModifiedDate { get; set; }
}
3)Cast Ingredient Model ToJson Object In Api And Create New RecepieCreateDto Like Below Code
var result=Newtonsoft.Json.JsonConvert.SerializeObject(recepieCreateDto.Ingredient);

   RecepieCreateDto readDto = new RecepieCreateDto
    {
        CookingTime = recepieCreateDto.CookingTime,
        Level = recepieCreateDto.Level ,
        ModifiedDate = recepieCreateDto.ModifiedDate ,
        NutritionalInformation = recepieCreateDto.NutritionalInformation ,
        RecepieAbstration = recepieCreateDto.RecepieAbstration ,
        RecepieName = recepieCreateDto.RecepieName ,
        RecepieText = recepieCreateDto.RecepieText ,
        ServingPerson = recepieCreateDto.ServingPerson ,
        CreateDate = recepieCreateDto.CreateDate ,
        Tags = recepieCreateDto.Tags ,
        Ingredient=result,
    };
Kiran Mohanty5y ago
You still have Ingredient property as string in RecepieCreateDto class. So you are facing error

Unable to determine the relationship represented by navigation 'Recepie.Ingredient' of type 'List
Sachin Singh5y ago
i don't know in real life , Ingredient are unique or not , but can't you declare a key , ofcourse if it make sense.
as it will be Identity in database
public class Ingredient
{
[Key]
public int Id {get;set;}
public string ingredientName{get;set;}

public string value {get;set;}

public string measure {get;set;}
}
ehsan khosravi5y ago
i did your suggest but i occurs this error : System.InvalidOperationException: 'The entity type 'Ingredient' requires a primary key to be defined. If you intended to use a keyless entity type, call 'HasNoKey' in 'OnModelCreating'.

then i do this :
public FoodpackContext(DbContextOptions opt):base(opt)
{
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    modelBuilder.Entity(builder => { builder.HasNoKey(); });
}

public DbSet Recepies { get; set; }
after do this occurs :

'Unable to determine the relationship represented by navigation 'Recepie.Ingredient' of type 'List'. Either manually configure the relationship, or ignore this property using the '[NotMapped]' attribute or by using 'EntityTypeBuilder.Ignore' in 'OnModelCreating'.'
Sachin Singh5y ago
to send an array of thing , you need to create List of that thing in your class
so create a list of Ingredient under Recepie
public class Ingredient
{
public string ingredientName{get;set;}

public string value {get;set;}

public string measure {get;set;}
}


    public class Recepie
        {
        [Key]
        public int ID { get; set; }
        [Required]
        public string RecepieName { get; set; }
        [Required]
        public List Ingredient { get; set; }   // include ingredientName / value / measure array
        [Required]
        public int CookingTime { get; set; }
        [Required]
        public string Level { get; set; }
        [Required]
        public int ServingPerson { get; set; }
        [Required]
        public string RecepieAbstration { get; set; }
        [Required]
        public string RecepieText { get; set; }
        [Required]
        public string NutritionalInformation { get; set; }
        [Required]
        public string Tags { get; set; }

        public DateTime CreateDate { get; set; }

        public DateTime ModifiedDate { get; set; }
        }