Home
Help
Register
Log in

Search

 
   Active Threads  

You are here: Home > LLBLGen Pro > LLBLGen Pro Runtime Framework> QuerySpec join with composite key fields
 

Pages: 1
LLBLGen Pro Runtime Framework
QuerySpec join with composite key fields
Page:1/1 

  Print all messages in this thread  
Poster Message
jovball
User



Location:
USA
Joined on:
23-Jan-2005 19:53:47
Posted:
393 posts
# Posted on: 22-Sep-2017 13:18:21.  
How can I do a join in QuerySpec to a table with composite key fields? For example, a table that has a foreign key reference to Northwind Order Details.

I've tried this (with & and also with && operators) but it doesn't compile.

Code:

             var query = qf.Create()
                     .From(qf.OrderDetaill)
                     .InnerJoin(qf.OrderDetailChild)
                            .On(OrderDetailFields.OrderId == OrderDetailChildFields.OrderId &
                                OrderDetailChild.ProductId == OrderDetailChildFields.ProductId


Surely there must be a way to do this.
Joel Reinford
LLBLGenPro Version: 5.5.3
Templates: Adapter
Framework: .Net 4.6
Database: SQL Server 2012/2014, DB2 v10
 
Top
jovball
User



Location:
USA
Joined on:
23-Jan-2005 19:53:47
Posted:
393 posts
# Posted on: 22-Sep-2017 16:46:21.  
Gah. Never mind. It's just a misplaced paren on my part.

Joel Reinford
LLBLGenPro Version: 5.5.3
Templates: Adapter
Framework: .Net 4.6
Database: SQL Server 2012/2014, DB2 v10
 
Top
Pages: 1  


Powered by HnD ©2002-2007 Solutions Design
HnD uses LLBLGen Pro

Version: 2.1.12172008 Final.