How can I return fieldList from an IQueryable object?
// fieldList="Code,Name";
var result = from Activity in query
select new
{
Code = Activity.Code,
Name = Activity.Name,
StatusCode = Activity.ClaimStatus.Name
};
Asked
Active
Viewed 33 times
-2
Chris Pickford
- 8,642
- 5
- 42
- 73
Sukhendu Chakraborty
- 17
- 2
-
Why would you want to do that? Why don't you know the columns you want to select at compile time? How do you determine this `fieldlist`(get as parameter?)? – Tim Schmelter Oct 15 '18 at 12:11
-
After creating the IQueryable object i want to return based on fieldList which is dynamic. I dont know at compilation time. Yes it will come as a parameter – Sukhendu Chakraborty Oct 15 '18 at 12:13
-
You want to return an anonymous type from the method? – Tim Schmelter Oct 15 '18 at 12:14
-
That will also be fine – Sukhendu Chakraborty Oct 15 '18 at 12:17
-
No, it's not fine bacause you can't resolve this type on the other side.The whole requirement is unclear and can certainly be done in a better way. – Tim Schmelter Oct 15 '18 at 12:18
-
So what is better way you think – Sukhendu Chakraborty Oct 15 '18 at 12:19
-
You haven't told anything about what you are actually trying to avchieve and why you think you need this. So we can't show you a better way. – Tim Schmelter Oct 15 '18 at 12:20
-
My requirement is simple fieldList is dynamic and i have IQueryable object available in system. example i have given you. Now i want to query based on fieldList – Sukhendu Chakraborty Oct 15 '18 at 12:22
-
Maybe this helps: https://stackoverflow.com/questions/44241996/linq-to-entities-select-columns-with-expression-parameter – Tim Schmelter Oct 15 '18 at 12:25
-
But there is no clear implementation available – Sukhendu Chakraborty Oct 15 '18 at 13:17
1 Answers
0
DTO
public class CustomDto
{
public string Code { get; set; }
public string Name { get; set; }
public string StatusCode { get; set; }
}
Convert To Dto
var result = items.AsQueryable().Select(x => new CustomDto()
{
Code = x.Code,
Name = x.Name,
StatusCode = x.ClaimStatus
}).ToList();
go..
- 958
- 7
- 15
-
after creating the object i want to return column based on array fieldList it is dynamic – Sukhendu Chakraborty Oct 15 '18 at 12:08
-
After creating the IQueryable object i want to return based on fieldList which is dynamic. I don't know at compilation time. It will come as a parameter – Sukhendu Chakraborty Oct 15 '18 at 12:16
-
there is your answer https://stackoverflow.com/questions/16516971/linq-dynamic-select – go.. Oct 15 '18 at 12:21