Retrieving Data From Multiple Tables in a LINQ to SQL query

Question

I'm new to LINQ and I'm not sure how to retrieve data from multiple tables from my SQL server database, here's the query:

SELECT cp.*, tsd.Action, tsd.CurrencyPair 
from TradeStatsData tsd, CalculatedPrices cp 
where tsd.TradeID = cp.TradeID and cp.Price is null and cp.ActiveTime < GETDATE()

The database uses the variable connection

How can I do this?

Justin Iurman · Accepted Answer · 2014-02-05 21:48:12Z

2

Your sql query would be something like this in LINQ:

var result = from tsd in TradeStatsData
             join cp in CalculatedPrices on tsd.TradeID equals cp.TradeID
             where cp.Price == null && cp.ActiveTime < DateTime.Now
             select new
             {
                CP = cp,
                Action = tsd.Action,
                CurrencyPair = tsd.CurrencyPair
             };

edited Feb 5, 2014 at 21:48

answered Feb 5, 2014 at 21:13

Justin Iurman

19k3 gold badges39 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Lorentz Vedeler · Accepted Answer · 2014-02-05 21:52:24Z

0

Linq is very similar to sql, just a little backwards.

from tsd in TradeStatsData
join cp in CalculatedPrices on tsd.TradeID equals cp.TradeID
where cp.Price == null && cp.ActiveTime < DateTime.Now
select new { cp.Col1... cp.ColN, tsp.Action, tsp.CurrencyPair }

edited Feb 5, 2014 at 21:52

answered Feb 5, 2014 at 21:13

Lorentz Vedeler

5,3813 gold badges32 silver badges42 bronze badges

Collectives™ on Stack Overflow

Retrieving Data From Multiple Tables in a LINQ to SQL query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related