How to combine 2 fields in a linq

Question

Hi

In below linq query i want to return 2 fields . I want to combine CourseCode & Name as a single field.

Id,Coursecode_name

public List<TrainingModuleMaster> GetRecordDetailsByTypeId(Int32 ID)
{
try
{
List<TrainingModuleMaster> Result = (from t in context.TrainingModuleMasters
where t.TrainingTypeID == ID
select t).ToList();
return Result;
}
catch (Exception ex)
{
throw ex;
}
}

Thanks

Vishal Joshi · Answer

You should add a new property in your model class ' TrainingModuleMaster ' like CourseCodeWithName or as per coding standard naming convention. You can write query like a below code: // Model Master Publick Class TrainingModuleMaster { public int ID { get ; set ;} public string Name { get ; set ;} public string CourseCodeWithName { get ; set ;} } // Function to get record detail public List GetRecordDetailsByTypeId(Int32 ID) { try { List Result = (from t in context.TrainingModuleMasters where t.TrainingTypeID == ID select new TrainingModuleMaster { ID = t.TrainingModuleID , Name = t.CourseName CourseCodeWithName = t.CourseModule + " " + t.CourseName }).ToList(); return Result; } catch (Exception ex) { throw ex; } }

Ramco Ramco · Answer

Hi Vishal trying below code but not working. Error - cannot implicitly convert type system.collection.genereic.list public List GetRecordDetailsByTypeId(Int32 ID) { try { List Result = (from t in context.TrainingModuleMasters where t.TrainingTypeID == ID select new { ID = t.TrainingModuleID , Name = t.CourseModule + " " + t.CourseName }).ToList(); return Result; } catch (Exception ex) { throw ex; } } Thanks

Vishal Yelve · Answer

Try this (from t in context.TrainingModuleMasters where t.TrainingTypeID == ID select new { CourseName = t.CourseCode + " " + t.Name }).ToList();