Get value for each of array from another table in Web Api LINQ-Asp
|Added at||2016-12-31 19:12|
I have a 'Skill' table where i store skills. And in 'Job' table i store all required skill when post job lile UpWork. Employeers have checkbox to select all required skills. But i store skillID like: 1,5,6,8 in job table. When i retrieve the job details, i want to get name of the all skills because i want to show SkillName with other details of the Job from job table. My Web Api:
the "j.ReSkill" response with like- 1,5,6,8 for each job. How can get SkillName instead of ID- like 'PHP','WordPress','ASP' with all other field. Or, should i store SkillName instead of ID at the time of job post?
How can i make LINQ query to get this? Thanks in advance.