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=> .........);

really has a POCO class called Anonymous behind it, for example.

AccountId,Name,SecretInfo

In the choose statement, I want the following:

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

The SecretInfo Column, which I may supply as a hardcoded string named "SecretInfo," is something else I wish to conceal. Basically, the Anonymous type must be used to build the choose list dynamically. How is this possible? Anyone who plays the Linq who can assist me?

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

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

Your question's resolution depends on type anonymous. You may use the code that follows:

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

You are developing an anonymous type in the select statement with two implicitly typed read-only fields within the braces that follow the new keyword (AccountId and Name). Hope this is useful!

I'd like to share the following passage from the related 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?

Here's a solution I discovered. Although I am aware that this strategy may not be ideal for discussing performance, it serves my purposes....HOW TO: Use Visual C#.NET to build a DataSet GROUP BY Helper Class
dynamic-linq linq
asked by Raúl Roa

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

I gave it a try:...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 { ...
dynamic-linq linq
asked by MattC

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

The answer to my specific problem was to perform the following:... var query = from pl in CurrentDataSource.ProductListing join pla in CurrentDataSource.ProductListingAttribute on new {pl.ProductID, pl.WebCategoryID, pl.ParentProductID} equals ...
anonymous-types c# dynamic-linq linq-to-entities
asked by rposbo

OrderBy inside a GroupBy using dynamic LINQ?

This is a wise question!...I developed a class named Item in order to mimic your circumstance....public class Item { public DateTime StartTime { get; set; } public string Name { get; set; } } ...Then after that made a simple list of things to categorize by....List<Item> Items = new List<Item>() { new Item() { StartTime = DateTime.Today,...
dynamic-linq linq linq-to-objects
asked by Bengel

Dynamic LINQ DateTime Comparison String Building - Linq To Entities

Using the data ...here... and a slightly modified string structure, I was able to get it running....This method worked well for me:...ContactList.Where("DateAdded >= DateTime(2013, 06, 18)") ...Note that technique is completely ineffective 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 whether this works with the default Dynamic Linq library, but I just gave it a go and it seems to work fine:...var data = data.Where("GuidPrimaryKey in @0", array); ...This also functions:...var data = data.Where("@0.Contains(GuidPrimaryKey)", array); ...Here is a comprehensive unit test I created to support this:...[TestMethod] public...
c# dynamic-linq linq where
asked by Nathan A

Dynamic Linq Execute Functions inside of Select Statement

If "GetFormattedLink" is not available because the scope seems to be on the Title class, try using that method with the complete namespace (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 recently resolved a situation that was similar....You must...ToList()... which works with Dynamic Linq. View this discussion at ...Unable to locate a field or attribute on a dynamic object.......Just copy paste those to your project, and later:...var TOrigin = (Model.Titles.Where("ID > 19632") .ToAnonymousList() ...
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?...You don't know the type's ...name... at build time, but an anonymous type is still a powerful type (hence "anonymous"). So yes, you can map the anonymous type to a different type using tools like AutoMapper and project to a ...different... type, but you ...still... have to know the fields at c...
anonymous-types c# dynamic-linq linq
asked by D Stanley

System.Linq.Dynamic - use SELECT inside WHERE statement

You may make use of the optional...params object[] values... input to include a few parameters in the dynamic search (like example...query... , ...tillRevision... and ...fromRevision... They might then be referred to as within the string as...@0... , ...@1... , ...@2... dependent on where they are....You might use to get access to the current rang...
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