Timespan not working with in memory LINQ

Asked Jul 26 '16 at 04:54

Active Jul 26 '16 at 05:14

Viewed 82 times

I was under the impression that when using in memory LINQ as below that TimeSpan is able to be used. If this is not the case how do I convert TimeSpan to date then? Note I believe entities in an in memory list.

var charterRequestDtoIds = from e in entities.Where(e => e.ClientId == clientId
                                        && e.Status != TrackingState.Void
                                        && DateTime.Now < DbFunctions.AddDays(e.CreatedAt, e.BiddingToCloseIn.Days + 30))
                                    select(e.Id);

The Error:

System.NotSupportedException: The specified type member 'BiddingToCloseIn' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported.

edited Jul 26 '16 at 05:14

Jason Boyd

6,839
4
29
47

asked Jul 26 '16 at 04:54

RickyTamma

What is entities ? An in-memory list ? or some IQueryable ? – Zein Makki Jul 26 '16 at 04:57
In memory list I believe – RickyTamma Jul 26 '16 at 05:00
2

Where is the code using `TimeSpan` and what's the error? And what _I believe_ should mean? – Aleksey L. Jul 26 '16 at 05:04
Alright question updated with more information – RickyTamma Jul 26 '16 at 05:06
I'm pretty sure the error is because `BiddingToCloseIn.Days` or `BiddingToCloseIn` are not database columns for the entity in question. Try converting the upper portion of the where clause to a list using `ToList` and then applying another `where` to the list. – Ash Jul 26 '16 at 05:10
why `DbFunctions` is used with in memory list? – Aleksey L. Jul 26 '16 at 05:11
4

@AlekseyL. because it is not In-Memory. The question is just misleading. – Zein Makki Jul 26 '16 at 05:13

Timespan not working with in memory LINQ

0 Answers0