WCF Data Services with Dynamic Join

dynamic-linq wcf wcf-data-services

Question

I am prototyping a generic data browser over WCF Data Services.

The user can select the entities from a TreeView, thus I cannot hardcode the query result types and have to code the queries (URI or LINQ) dynamically.

To offer joins across different Data Services I am loading the results from each Data Service to the client an try to dynamically join them:

Dim q1 As IQueryable = ctx.Execute(Of Object)(New Uri("Service1.svc/Customers")).ToList.AsQueryable

Dim q2 As IQueryable = ctx.Execute(Of Object)(New Uri("Service2.svc/Orders")).ToList.AsQueryable

Dim j = q1.JoinDynamic("q1", q2, "q2", "q1.CustomerID", "q2.CustomerID", "New (q1.CustomerID as q1id, q1.CompanyName as CompanyName)")

I'm am stuck with a problem using the dynamich Join. See: link text

  1. Is ctx.Execute the right way to query results when the types not known until runtime?

  2. Does someone have a better idea on how to implement dynamic joins over Data Services?

1
1
2/12/2010 5:22:48 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

As a workaround I dynamically created the join code via an in-memory assembly. This seems to work fine. I can see the join result in the debugger. I only do not know hot to bind the result to a DataGrid.

        Dim codeDomProvider = New VBCodeProvider
    Dim cp As New Compiler.CompilerParameters
    cp.GenerateExecutable = False
    cp.GenerateInMemory = True
    cp.CompilerOptions = "/optionexplicit- /optionstrict-"
    cp.ReferencedAssemblies.Add(IO.Path.ChangeExtension(My.Application.Info.AssemblyName, "exe"))
    cp.ReferencedAssemblies.Add("System.dll")
    cp.ReferencedAssemblies.Add("System.Core.dll")
    cp.ReferencedAssemblies.Add("System.Data.Services.Client.dll")

    Dim sb = New Text.StringBuilder()
    sb.Append("Imports System" & vbCrLf)
    sb.Append("Imports System.Linq" & vbCrLf)
    sb.Append("Imports " & My.Application.Info.AssemblyName & vbCrLf)
    sb.Append("Public Class JoinHelper" & vbCrLf)
    sb.Append("Public Shared Function GetData() As Object" & vbCrLf)
    sb.Append("  Dim ctx1 As New NorthwindDataService.NorthwindEntities(New Uri(""http://localhost:3631/NorthwindDataService.svc/""))" & vbCrLf)
    sb.Append("  Dim ctx2 As New SalesDataService.SalesEntities(New Uri(""http://localhost:4354/SalesDataService.svc""))" & vbCrLf)
    sb.Append("  Dim q1 as System.Data.Services.Client.QueryOperationResponse (of NorthwindDataService.Customers) = ctx1.Execute(Of NorthwindDataService.Customers)(New Uri(""Customers"", UriKind.Relative))" & vbCrLf)
    sb.Append("  Dim q2 as System.Data.Services.Client.QueryOperationResponse (of SalesDataService.CustomerSize) = ctx2.Execute(Of SalesDataService.CustomerSize)(New Uri(""CustomerSize"", UriKind.Relative))" & vbCrLf)
    sb.Append("  Dim j = From c In q1 Join s In q2 On c.CustomerID Equals s.CustomerID Select New With {c.CompanyName, s.Size}" & vbCrLf)
    'sb.Append("  return j.tostring" & vbCrLf)
    sb.Append("  return j" & vbCrLf)
    'sb.Append("  r = j.ToList" & vbCrLf)
    'sb.Append("  return r" & vbCrLf)
    sb.Append("End Function" & vbCrLf)
    sb.Append("End Class" & vbCrLf)
    sb.Append(vbCrLf)
    Dim code = sb.ToString
    Dim compilerResults = codeDomProvider.CompileAssemblyFromSource(cp, code)
    If compilerResults.Errors.HasErrors Then
        Throw New ApplicationException(compilerResults.Errors.Item(0).ToString)
    End If
    Dim o = compilerResults.CompiledAssembly.CreateInstance("JoinHelper")
    Dim t = o.GetType
    Dim j = t.InvokeMember("GetData", Reflection.BindingFlags.InvokeMethod, Nothing, o, Nothing)
    DataGrid1.ItemsSource = j
0
2/12/2010 5:26:06 PM

Related Questions

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

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

When writing a method for an oData service I have the below linq, for which I need to have a dynamic "where" clause to filter the results (the "new"s in the joins are for composite PKs in the Entity Data Model):...var query = from pl in CurrentDataSource.ProductListing join pla in CurrentDataSource.ProductListingAttribute ...
anonymous-types c# dynamic-linq linq-to-entities
asked by rposbo

With Dynamic Linq, how can I make a left outer join?

I am trying to mimick the left outer join ...here... but using dynamic linq extension methods. What i have:...public static IQueryable SelectMany(this IQueryable source, string selector, string resultsSelector, params object[] values) { if (source == null) throw new ArgumentNullException("source"); if (selector == null) throw new Argum...
.net c# dynamic-linq linq linq-to-sql
asked by jaywayco

Dynamic Linq/ Dynamic Query: cannot get data for jqGrid

I'm using jqGrid and I have a problem getting Dynamic Linq to work. I used NuGet to install Dynamic and added "using System.Linq.Dynamic;"....Using VS 2010 Pro, MVC 3.0...This works:...var s = context.testdata; var c = s.Count(); ...c shows 5136 items....But I cannot get the dynamic approach to work:...var s = context.testdata.OrderBy("id asc"); ..
asp.net-mvc dynamic-linq entity-framework jqgrid linq
asked by Oliver Kötter

How to filter dynamic linq query on the initial data when there is self-join

I have a query that I generate by dynamic linq. The problem is when I self-join the initial data set, all other filters are on the latest table. I want it to be on the initial. How can I do that? Here is an example: ...var result = dataContext.Person; var initialData = result; .... var subQuery = initialData.Where(String.Format(predicateEntityIn, e...
c# dynamic-linq
asked by Thea

Dynamic Linq - Joining a table with 1 to many relationship

I'm using Dynamic Linq as the backend to an in-app reporting tool and I've hit a problem that I can't get round where I have to access a table that has a 1:M relationship . ...My simplified data structure is this:...If I were querying this in standard Linq I'd write the query as:...from a in context.Table_A select new { a.RefNo, val = from...
c# dynamic-linq join linq
asked by GrandMasterFlush

Use Dynamic LINQ Library with join

Following is the UI :...And this is code snippet i am using to fire dynamic where clause :...public void bind() { string filter = ""; if (!string.IsNullOrEmpty(txtPart.Text)) { filter = filter + "masterinv.inv_item_id = " + txtPart.Text; } if (!string.IsNullOrEmpty(txtDescription.Tex...
c# dynamic-linq linq-to-sql
asked by Sunny

How to use a dynamic LINQ join extension method for multiple conditions

I'm trying to test out a dynamic join extension method as defined ...here... to join two datasets(dataset1 and dataset2) on multiple conditions. My join condition is as shown below... outerSelector = "new ( dataset1.ToBeReconciled as col1, dataset1.TransactionDate as col2)"; innerSelector = "new ( dataset2.ToBeReconciled as col1, dataset2.Transa...
c# dynamic-linq join linq multiple-conditions
asked by yogita thelasaria

C# - Dynamic Linq left outer join on multiple properties

i want to do left outer join in ...Dynamic Linq..., but i can't get the syntax right. In SQL it would look like this:...SELECT col1, col2, col3 from tableA as a LEFT OUTER JOIN tableB as b on a.col1 = b.col1 AND a.col2 = b.col2 AND a.col3 = 1 ...In dynamic linq i tried this:...dbContext.tableA .GroupJoin(tableB, col1 == tableA.col1 && col2 == table...
c# dynamic-linq linq sql
asked by Oktay Myumyunov

left outer join with multiple conditions using Dynamic Linq

I am trying to build ...Dynamic Left outer join... Linq query. ...I took help of ...How do I do a left outer join with Dynamic Linq?...I am getting the following error in ..."SelectMany"....... System.Linq.Dynamic.ParseException: 'No property or field 'ls' exists in type 'DataStore'' ...Code I have is : ...public static IQueryable GroupJoin(this ...
c# dynamic-linq linq
asked by rmkr

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