List returning 0 records

Jagjit Saini

IN below query there r 2 records in View_Header . but it shows 0 in tt. In below query i wants to add where Clause also.

List tt = new List();
tt.Select(x => new { x.ID, x.Name }).ToList();

Thanks

4 Replies

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

Jignesh Kumar4y ago
Accepted answer
Hi Jagjit,

In above query you are selecting from tt list which you have created above only so there is no records in it. From which list you want to get records.
+2
Jagjit Saini4y ago
Resolved

public List GetList()
{
var Result = (from t in context.View_Headers
where t.IsActive == true
select new View_Header { ID = t.ID, Namee = t.Namee }).ToList();
return Result;
}

+2
Muhammad Imran Ansari4y ago
Jagjit,
You have initilized 'tt' as new List and it will defenately return 0 records. Please share your complete code to address your issue.
+1
Jagjit Saini4y ago
Hi Jignesh

Below is the code. I want to list only 2 columnc

public List GetList()

{

List Result = (from t in context.View_Headers

where t.IsActive == true

select t).ToList();

return Result;

}

Thanks
+2