Hi In below query i want to select only 2 columnc public List GetList() { List Result = (from t in context.View_Headers where t.IsActive == true select t).ToList(); return Result; } Thanks

Change your wuery as below: var Result = ( from t in EmpList where t.IsActive == true select new View_Header { t.column1, t.column1 }).ToList(); public List GetList() { var Result = (from t in context.View_Headers where t.IsActive == true select new View_Header { First_Column = t.column1, Second_Column = t.column2 }).ToList(); return Result; }

Hi I am using Entity Framework , Sql etc Thanks

Which data source you are using to assign this values?

Hi Error - Cannot implicity convert type System.linq.queryable to System.collections.GenericList Thanks

Answers

List only 2 columns

Jagjit Saini

764

In below query i want to select only 2 columnc

public List<View_Header> GetList()
{
    List<View_Header> Result = (from t in context.View_Headers
                                    where t.IsActive == true
                                    select t).ToList();
    return Result;
}

Thanks