Store Data in table using linq.

Question

How tpo send this type format data and save in database in c# web api using linq. {"injuries":{"injuriesList": [{"userInjuriesTypeId":4,"description": "Over Wegiht", "date": "22/7/2020"}, {"userInjuriesTypeId":4,"description": "Over Wegiht", "date": "22/7/2020"}],"UserId":4}} please make a demo code

Jenith Thakkar · Answer

static void Main( string [] args) { stringjsonData = @ "{ 'FirstName' : 'Jignesh' , 'LastName' : 'Trivedi' } "; var myDetails = JsonConvert.DeserializeObject (jsonData); Console.WriteLine( string .Concat( "Hi " , myDetails.FirstName, " " + myDetails.LastName)); Console.ReadLine(); } public class MyDetail { public string FirstName { get ; set ; } public string LastName { get ; set ; } } Please check above example

Guest User · Answer

Any example please it's most important for me. Its me model code . public class InjuerisResult { public int Response { get; set; } public string ErrorMessage { get; set; } } public class RootObject { public string InjuriesDetails { get; set; } public List UserInjerisList { get; set; } } [Table("TblInjurie")] public class InjerisDetail { public int? UserId { get; set; } public int UserInjuriesTypeId { get; set; } public string Description { get; set; } public bool? IsActive { get; set; } [Column(TypeName = "date")] public string Date { get; set; } } it's me c# code please help me. public InjuerisResult SavePhysicalInjueris(InjerisDetail[] obj_parameter) { InjuerisResult obj_result = new InjuerisResult(); try { if (obj_parameter == null) { obj_result.Response = 2; obj_result.ErrorMessage = " object is null"; } else { List list_Injurie = new List (); obj_parameter.ToList().ForEach(x => { var obj_tblInjurie = new TblInjurie(); obj_tblInjurie.Date = DateTime.ParseExact(x.Date, "d/M/yyyy", CultureInfo.InvariantCulture); obj_tblInjurie.Description = x.Description; obj_tblInjurie.UserInjuriesTypeId = x.UserInjuriesTypeId; obj_tblInjurie.UserId = x.UserId; obj_tblInjurie.IsActive = true; obj_tblInjurie.UpdatedDate = DateTime.UtcNow; list_Injurie.Add(obj_tblInjurie); }); _context.TblInjurie.AddRange(list_Injurie); _context.SaveChanges(); } obj_result.Response = 1; obj_result.ErrorMessage = "No Error Found"; } catch (Exception ex) { obj_result.Response = 0; obj_result.ErrorMessage = "Internal Server Error"; } return obj_result; }

Jenith Thakkar · Answer

Serialize that json and convert it into sting so you can store that string in database

Store Data in table using linq.

Answers (3)