SQL to LLBLGen

Posts   
 
    
Rob
User
Posts: 54
Joined: 17-Sep-2004
# Posted on: 11-Jan-2006 06:56:48   

Hello!

I have a straight-forward query that I can't figure out how to convert to generated code.

Can anyone point me in the right direction?

This is the query:


SELECT 
    Sum(P.Price * C.Quantity)
FROM
    Certificate C
INNER JOIN
    FundProduct P ON P.FundProductID = C.FundProductID
WHERE
    C.CertificateStatusID = 1
AND
    C.FundID = 21

Thanks,

!Rob

Walaa avatar
Walaa
Support Team
Posts: 14950
Joined: 21-Aug-2005
# Posted on: 11-Jan-2006 07:23:29   

Please check the following thread: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=5086

It should put you on the right track.

Good Luck

Rob
User
Posts: 54
Joined: 17-Sep-2004
# Posted on: 11-Jan-2006 08:31:04   

Thanks Walaa

Translating: - Scenario - Adapter to Selfservicing - VC to C#

all proved too difficult for me.

Thanks anyway...

Paul.Lewis
User
Posts: 147
Joined: 22-Aug-2005
# Posted on: 12-Jan-2006 04:55:07   

Rob wrote:

Thanks Walaa

Translating: - Scenario - Adapter to Selfservicing - VC to C#

all proved too difficult for me.

Thanks anyway...

Rob, did you find an answer to you question?