Building a dynamic anonymous type Select statement using Linq

dynamic-linq linq

Question

//list is IEnumeable NOT IEnumerable<T>

var IEnumerable<object> = list.AsQueryable().Cast<object>().Select(x=> .........);

object actually has a POCO underlying Anonymous class e.g

AccountId,Name,SecretInfo

What I want in the select statement is 

AccountId = x.GetType().GetProperty("AccountId").GetValue(x,null),
Name = x.GetType().GetProperty("Name").GetValue(x,null)

Also I want to hide the SecretInfo Column which I can pass as a hardcoded string "SecretInfo" Basically the select list needs to be built up dynamically on the Anonymous type.... How can this be done....Any Linq punters out there who can help me?

1
0
6/26/2013 11:37:17 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

The answer to your question relies on anonymous types. The following code is what you can use:

var result = list.AsQueryable().Cast<Info>().Select(x => new
    {
        AccountId = x.AccountId,
        Name = x.Name
    });

Between the brackets that follow the new keyword in the select statement, you are creating an anonymous type that will have two implicitly typed read-only fields (AccountId and Name). Hope this helps!

I would like to post this quote from the linked (no pun intended) article:

Anonymous types typically are used in the select clause of a query expression to return a subset of the properties from each object in the source sequence. For more information about queries, see LINQ Query Expressions (C# Programming Guide).

0
6/26/2013 12:15:08 PM

Related Questions

Is it feasible to create dynamic LINQ queries for datatables that aren't strongly typed?

I found a solution here. I know this approach is might not be good when talking about performance, but it works for what I want...HOW TO: Implement a DataSet GROUP BY Helper Class in Visual C# .NET
dynamic-linq linq
asked by Raúl Roa

Using the System.Linq.Dynamic namespace, how to perform the following in Dynamic Linq

I tried this:...using System; using System.Linq; using System.Linq.Dynamic; using System.Collections.Generic; namespace ConsoleApplication1 { public class Customer { public string FirstName { get; set; } public string LastName { get; set; } public string Tags { get; set; } } class Program { sta...
dynamic-linq linq
asked by MattC

Multiple table dynamic, Entity Data Model, Dynamic Linq Strongly typed return types, when clause

The solution to my particular query was to do this:... var query = from pl in CurrentDataSource.ProductListing join pla in CurrentDataSource.ProductListingAttribute on new {pl.ProductID, pl.WebCategoryID, pl.ParentProductID} equals new {pla.Pro...
anonymous-types c# dynamic-linq linq-to-entities
asked by rposbo

OrderBy inside a GroupBy using dynamic LINQ?

This is a good question!...I simulated your situation by creating a class called Item....public class Item { public DateTime StartTime { get; set; } public string Name { get; set; } } ...and then created a basic list of items to do the groupby....List<Item> Items = new List<Item>() { new Item() { StartTime = DateTime.Today, Name = "item...
dynamic-linq linq linq-to-objects
asked by Bengel

Dynamic LINQ DateTime Comparison String Building - Linq To Entities

I was able to get it working with a slightly different string format using the information ...here.......Doing this worked fine for me:...ContactList.Where("DateAdded >= DateTime(2013, 06, 18)") ...Note this does not work at all with ...DateTimeOffset... columns.
c# dynamic-linq entity-framework linq string
asked by Richard Rout

Building a Dynamic Linq Query using Equals and an Array

I'm not sure if this works in the standard Dynamic Linq library, but I just tried this is ...my open-source version..., and it works well:...var data = data.Where("GuidPrimaryKey in @0", array); ...This also works:...var data = data.Where("@0.Contains(GuidPrimaryKey)", array); ...Here is a full unit test I wrote to confirm this:...[TestMethod] publ...
c# dynamic-linq linq where
asked by Nathan A

Dynamic Linq Execute Functions inside of Select Statement

It looks like the scope is on title which does not have the "GetFormattedLink", try calling that method with the full namespace if it is not on the Title class (or move it to the title class if that is where it belongs)
c# dynamic-linq function
asked by Matt Sanders

Formatting Select Statement Using Dynamic Linq

I just solved similiar problem few hours back....YOu need ...ToList()... that works with Dynamic linq. Check out this thread: ...Can't find property or field on a dynamic object...Just copy paste those to your project, and later:...var TOrigin = (Model.Titles.Where("ID > 19632") .ToAnonymousList() .Select("ne...
c# dynamic-linq entity-framework linq sql-server
asked by Erti-Chris Eelmaa

How to convert an anonymous type in Dynamic LINQ to a strong type

How can I project an anonymous type to a strong type?...Well, an anonymous type ...is... a strong type - you just don't know the ...name... of the type at compile time (hence "anonymous"). So sure, you can project to a ...different... type and use tools like AutoMapper to map the anonymous type to a different type but you ...still... have to know t...
anonymous-types c# dynamic-linq linq
asked by D Stanley

System.Linq.Dynamic - use SELECT inside WHERE statement

You can utilize the optional ...params object[] values... argument to pass some parameters to the dynamic query (like ...query..., ...tillRevision... and ...fromRevision...). Then you can refer to them inside the string as ...@0..., ...@1..., ...@2... based on their position....For accessing the current range variable in scope you could use ...it..
c# dynamic-linq linq sql
asked by Ivan Stoev

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow