Formatting Select Statement Using Dynamic Linq

c# dynamic-linq entity-framework linq sql-server

Question

I've been looking into this for quite some time now and cannot figure out a resolution. I Originally Tried formatting A dynamic linq Statement as you can see here in this post

I declared a class:

public class DynamicHelper
{
    public string FormattedLink(string DisplayText, string ID)
    {
        return "<a href='/Title/Preview/'" + ID + ">" + DisplayText + "</a>";
    }

    public string FormattedLink(string DisplayText, int ID)
    {
        return "<a href='/Title/Preview/'" + ID + ">" + DisplayText + "</a>";
    }
}

After I inserted a new type in DynamicLinq into the predefinedTypes

,typeof(DynamicHelper) //around line 635

I have a program which is attempting to Invoke the FormattedLink inside of a dynamic linq select:

using (var Model = new MK3Entities())
{
    DynamicHelper Dh = new DynamicHelper();

    var TOrigin = (Model.Titles.Where("ID > 19632")
                               .Select("new(ID,  @0.FormattedLink(ExtTitleID, ID) as ExtTitleID )", Dh) as System.Collections.IEnumerable)
                               .Cast<dynamic>().Take(10).ToList();

    Console.ReadKey();
}

When I execute this program I get a runtime exception "LINQ to Entities does not recognize the method 'System.String FormattedLink(System.String, Int32)' method, and this method cannot be translated into a store expression."

Any Ideas on how to fix this... I just need simple formatting from Dynamic Select.

1
0
5/23/2017 12:05:51 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

The error message is pretty self explanatory. The database doesn't know how to translate that method into SQL. You need to fetch the information that the method needs in your database query and then call that function on the results, rather than in the query.

1
10/22/2014 8:26:12 PM

Popular Answer

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("new(ID,  @0.FormattedLink(ExtTitleID, ID) as
                         ExtTitleID )", Dh) as System.Collections.IEnumerable);
Erti-Chris Eelmaa

Related Questions

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

I just want to know how to do the following in Dynamic Linq using System.Linq.Dynamic namespace...var query2 = db.Customers.Select( cust => new Customer { FirstName = cust.FirstName, LastName = cust.LastName Tags="sampleTag,Tag" ...
dynamic-linq linq
asked by emem

Does dynamic GroupBy in dynamic LINQ work with dynamic Where?

I use this ...dynamic LINQ library... together with Linq-to-Entities.... I build query and after that iterate it with ...foreach(object e in query){}...query=db.Table1.Where("it.FieldA>10").Select("it.FieldB");... works....query=db.Table1.Where(e=>e.FieldA>10).GroupBy("it.FieldB", "it").Select("key")... works.... But ...query=db.Table1.Where("it.Fi...
.net dynamic dynamic-linq linq linq-to-entities
asked by alpav

OrderBy inside a GroupBy using dynamic LINQ?

I had the following query using normal linq and it was working great (using anonymous type),... var result = from s in Items group s by s.StartTime into groupedItems select new {groupedItems.Key, Items= groupedItems.OrderBy(x => x.Name) }; ...But using Dynamic Linq I cannot get it to order by within the groupby.... r...
dynamic-linq linq linq-to-objects
asked by Martin

Building a dynamic anonymous type Select statement using Linq

//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().GetPro...
dynamic-linq linq
asked by chugh97

Dynamic Linq Execute Functions inside of Select Statement

I'm trying to grab out formatted values from a project....I have a function declared:...public static string GetFormattedLink(string ExtTitleID) { return "Str_" + ExtTitleID; } ...How would I execute this statement from the Select Statement in Dynamic Linq I tried....using (var Model = new MK3Entities()) { var TOrigin = (Model.Titles.Where(...
c# dynamic-linq function
asked by johnny 5

Dynamic Linq + Entity Framework: datetime modifications for dynamic select

I am trying to find a way to move UTC time to Local before doing a sql grouping. I am using the System.Linq.Dynamic (managed here ...https://github.com/kahanu/System.Linq.Dynamic... ). It works great for doing dynamic selects without having at compile time the required fields. In our case, we store all datetimes in UTC. In this dynamic select, it...
.net c# dynamic-linq entity-framework-6
asked by TravisWhidden

Dynamic LINQ - Entity Framework 6 - Update Records for Dynamic Select

When you do a ...SELECT NEW ...... it selects only specific fields and won't track updates for you. I think if you change your query to be this it will work:...var query = db.tblRecords.Where(x=>x.id == id);
c# dynamic-linq entity-framework-6
asked by jhilden

System.Linq.Dynamic - use SELECT inside WHERE statement

I need to generate SQL query dynamically using System.Linq.Dynamic like this:...SELECT [Extent1].[FromRevision] AS [FromRevision], [Extent1].[Field1] AS [Field1], [Extent1].[TillRevision] AS [TillRevision], [Extent1].[Field2] AS [Field2], [Extent1].[Date1] AS [Date1], [Extent1].[LastChangeDate] AS [LastChangeDate], ...
c# dynamic-linq linq sql
asked by Artem Makarov

Select Clause using System.Linq.Dynamic is returning "'(' expected" fault

I'm trying to use linq dynamic to create a selec that returns me a specific object. But I'm always getting the same error message: '(' expected...My select code:...var resultCollection = manyPartEntireCollection .Select("new MyNamespace.OneToManyViewModel(@0 as OnePartId, Id as ManyPartId, Name as Name, @1.Contains(outerIt.Id) as En...
c# dynamic-linq linq linq-to-sql
asked by André Cristino

Using Dynamic Linq Select - Guid field throwing exception

My Database column name is "Guid" , Since the DB is mapping to many applications and also already in production I couldn't able to change the DB field, ...Error Occurs only if Field Name is "Guid"...var query2 = db2.Charities.Select("New(Name as CharityName,City as City,new Guid as Guid)");
dynamic-linq
asked by Sarath

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