How to combine 2 fields in a linq

Ramco Ramco

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 GetRecordDetailsByTypeId(Int32 ID)
{
try
{
List Result = (from t in context.TrainingModuleMasters
where t.TrainingTypeID == ID
select t).ToList();
return Result;
}
catch (Exception ex)
{
throw ex;
}
}

Thanks

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vishal Joshi4y ago
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;
  }
}
+2
Ramco Ramco4y ago
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
+2

Vishal Yelve4y ago

Try this

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