sql linq concat fields where code example

Example: Linq Select string fields concat as one fieldsub query in linq

You need to name your anonymous members:
.Select( c => new {COURSE_ID = c.COURSE_ID, COURSE_TITLE = c.CIN + " " + c.COURSE_TITLE})