i need linq query of the sql query

Question

0.00/5 (No votes)

See more:

SQL

SELECT c.companyName, c.companyId, ti.tickerSymbol, e.exchangeSymbol,
    pt.periodTypeName,fp.fiscalYear
    ,fd.dataItemId
    ,di.dataItemName
    ,fd.dataItemValue
FROM ciqCompany c join ciqSecurity s on c.companyId = s.companyId
    join ciqTradingItem ti on ti.securityId = s.securityId
    join ciqExchange e on e.exchangeId = ti.exchangeId
    join ciqLatestInstanceFinPeriod fp on fp.companyId = c.companyId
    join ciqPeriodType pt on pt.periodTypeId = fp.periodTypeId
    join ciqFinancialData fd on fd.financialperiodid = fp.financialperiodid
    join ciqdataitem di on di.dataitemid = fd.dataitemid
WHERE fd.dataItemId in (3069)---Total Revenue
    AND fp.periodTypeId = 1
    and fp.fiscalyear between year(dateadd(yy,-5, getdate())) and year(getdate())
    AND ti.tickerSymbol = 'ibm'
    AND e.exchangeSymbol = 'Nyse'
ORDER BY fd.dataitemid desc, fp.fiscalYear desc

Posted 13-Oct-15 21:01pm

Athul MS

Updated 13-Oct-15 21:09pm

Tomas Takac

v2

Add a Solution

Comments

OriginalGriff 14-Oct-15 3:36am

And?
What have you tried?
Where are you stuck?
What help do you need?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Magic Wonder · Answer 1 · 2015-10-14T00:12:00

Solution 1

Hi,

Check this...LINQ - SQL[^]

Hope this will help you.

Cheers

Posted 14-Oct-15 0:12am

Magic Wonder

Maciej Los · Answer 2 · 2015-10-14T01:17:00

My best guess:

C#

var query = from c in ciqCompany
    join s in  ciqSecurity on c.companyId equals s.companyId
    join ti in ciqTradingItem on ti.securityId equals s.securityId
    join e in ciqExchange on e.exchangeId equals ti.exchangeId
    join fp in ciqLatestInstanceFinPeriod on fp.companyId equals c.companyId
    join pt in ciqPeriodType on pt.periodTypeId equals fp.periodTypeId
    join fd in ciqFinancialData on fd.financialperiodid equals fp.financialperiodid
    join di in  ciqdataitem on di.dataitemid equals fd.dataitemi
    where fd.dataItemId == 3069 && fp.periodTypeId = 1  && fp.fiscalyear >= DateTime.Today.AddYears(-5)  && fp.fiscalyear <= DateTime.Today  && ti.tickerSymbol = 'ibm' && e.exchangeSymbol = 'Nyse'
    select new {
        c.companyName,
        c.companyId,
        ti.tickerSymbol,
        e.exchangeSymbol,
        pt.periodTypeName,
        fp.fiscalYear,
        fd.dataItemId,
        di.dataItemName,
        fd.dataItemValue
    };

For further information, please see:
join clause (C# Reference)[^]
101 LINQ Samples[^]