I am having a hard time writing LINQ query for building JSON response. Can some one help me with this?
Requirement: A movie can be produced by two productions and many assistant directors but movie will have a single director.
I am fetching this data from DB
PRODUCTIONID MOVIENAME DID PLACE DNAME AID ANAME
-----------------------------------------------------------------------------------------------------------------
1 DDLJ 11 DELHI RAJ 111 Name 1
1 DDLJ 11 DELHI RAJ 112 Name 2
1 DDLJ 11 DELHI RAJ 113 Name 3
1 DDLJ 11 DELHI RAJ 114 NAME 4
2 DDLJ 11 DELHI RAJ 111 Name 1
2 DDLJ 11 DELHI RAJ 112 Name 2
2 DDLJ 11 DELHI RAJ 113 Name 3
2 DDLJ 11 DELHI RAJ 114 NAME 4
2 DON2 22 NOIDA SAM 221 Name 5
2 DON2 22 NOIDA SAM 222 Name 6
2 DON2 22 NOIDA SAM 223 Name 7
2 DON2 22 NOIDA SAM 224 NAME 8
My JSON response should be like:
{
"Movies": [
{
"ProductionID": "string",
"MovieInfo": [
{
"MovieName": "string",
"Directorinfo": [
{
"Did": "string",
"Dname": "string",
"Place": "string"
}
],
"AssistantDirectors": [
{
"Aid": "string",
"Aname": "string",
}
]
}
]
}
]
}
}
Sample output that is expected:
"content": [
{
"Movies": [
{
"ProductionID”: “1”,
"MovieInfo": [
{
"MovieName": "DDLJ",
"Directorinfo": [
{
"Did": "11",
"Dname": "RAJ",
"Place": "delhi"
}
],
"AssistantDirectors": [
{
"Aid": "111",
"Aname": "NAME 1"
},
{
"Aid": "112",
"Aname": "NAME 2"
},
{
"Aid": "113",
"Aname": "NAME 3"
},
{
"Aid": "114",
"Aname": "NAME 4"
}
]
}
]
},
{
"ProductionID": "2",
"MovieInfo": [
{
"MovieName": "DDLJ",
"Directorinfo": [
{
"Did": "11",
"Dname": "RAJ",
"Place": "delhi"
}
],
"AssistantDirectors": [
{
"Aid": "111",
"Aname": "NAME 1"
},
{
"Aid": "112",
"Aname": "NAME 2"
},
{
"Aid": "113",
"Aname": "NAME 3"
},
{
"Aid": "114",
"Aname": "NAME 4"
}
]
},
{
"Moviename": "DON",
"Directorinfo": [
{
"Did": "22",
"DName": "SAM",
"Place": "NOIDA"
}
],
"AssistantDirectors ": [
{
"AID": "221",
"aName": "NAME 5"
},
{
"AID": "222",
"aName": "NAME 6"
},
{
"AID": "223",
"aName": "NAME 7"
},
{
"AID": "224",
"aName": "NAME 8"
},
]
}
]
}
]
}
],
}
}