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
Muhammad Imran AnsariPosted Mar 16, 2022, 7:39 AM
Rijwan AnsariPosted Mar 16, 2022, 10:32 AM
Muhammad Imran AnsariPosted Mar 16, 2022, 8:17 AM
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;
}
Jagjit SainiPosted Mar 16, 2022, 8:02 AM
Muhammad Imran AnsariPosted Mar 16, 2022, 7:50 AM
Jagjit SainiPosted Mar 16, 2022, 7:47 AM