"Specified method is not supported" when query let with odata service
Hi, I am using Linqpad6 against Linq to Odata Service. When I query with let, I end with "Specified method is not supported." error. Target framework is .Net 5. Doesn't Linqpad supports full linq to odata query? If so, where can I confirm the limitations?
from i in incident let location = location.First(l => l.location_code == "40117") .dwi_location where i.dwk_location == 53 select new{dwk_location = i.dwk_location}
without the let, the query works fine.
at Microsoft.OData.Client.DataServiceQuery1.System.Collections.IEnumerable.GetEnumerator()
at LINQPad.ObjectGraph.ListNode.GetItems(IEnumerable list, Type staticDumpType, GraphOptions options)+MoveNext()
at LINQPad.ObjectGraph.ListNode..ctor(ObjectNode parent, IEnumerable list, Type staticDumpType, GraphOptions options, String name)
at LINQPad.ObjectGraph.ObjectNode.CreateInternal(ObjectNode parent, Object item, Type staticDumpType, GraphOptions options, Object itemForDescription, Boolean& collapse)
at LINQPad.ObjectGraph.ObjectNode.TryCreate(ObjectNode parent, Object item, Type staticTypeDump, GraphOptions options)
at LINQPad.ObjectGraph.ObjectNode.Create(Object item, Type staticDumpType, GraphOptions options)
at LINQPad.ObjectGraph.Formatters.HtmlWriter.FormatObject(Object value, String heading, GraphOptions options, Boolean& inline, TimeSpan& formattingTime)
at LINQPad.ObjectGraph.Formatters.OutputWriter.WriteObject(Object value, String heading, GraphOptions options, Boolean noNewLine)
at LINQPad.ObjectGraph.Formatters.OutputWriter.WriteLineObject(Object value, String heading, GraphOptions options, Boolean noNewLine)
at LINQPad.Extensions.DumpCore[T](T o, String description, Nullable1 depth, Nullable1 collapseTo, Boolean toDataGrid, String exclude, String include, Nullable1 alpha, Boolean noTotals, Nullable1 repeatHeadersAt, Boolean includePrivate)
at LINQPad.Extensions.Dump[T](T o, String description, Nullable1 depth, Nullable1 collapseTo, Boolean toDataGrid, String exclude, String include, Nullable1 alpha, Boolean noTotals, Nullable1 repeatHeadersAt, Boolean includePrivate)
at LINQPad.Extensions.Dump[T](T o)
at UserQuery.Main() in C:\Users\aaron.kim\AppData\Local\Temp\LINQPad6_gxckozdr\jmfnqh\LINQPadQuery.cs:line 1000021
at LINQPad.ExecutionModel.ClrQueryRunner.Run()
at LINQPad.ExecutionModel.Server.RunQuery(QueryRunner runner)
`