how to pass linq list to view in mvc

Question

1.00/5 (1 vote)

See more:

the code is given below

C#

var IS = (from c in xfeed.ciqCompanies
      join s in xfeed.ciqSecurities on c.companyId equals s.companyId
      join ti in xfeed.ciqTradingItems on s.securityId equals ti.securityId
      join e in xfeed.ciqExchanges on ti.exchangeId equals e.exchangeId
      join fp in xfeed.ciqLatestInstanceFinPeriods on c.companyId equals fp.companyId
      join pt in xfeed.ciqPeriodTypes on fp.periodTypeId equals pt.periodTypeId
      join fd in xfeed.ciqFinancialDatas on fp.financialPeriodId equals fd.financialPeriodId
      join di in xfeed.ciqDataItems on fd.dataItemId equals di.dataItemId
      where fd.dataItemId == 3069
      && fp.periodTypeId ==1
      && fp.fiscalYear>=DateTime.Now.AddYears(-5).Year && fp.fiscalYear<=DateTime.Now.Year
      && ti.tickerSymbol == tickerSymbol
      && e.exchangeSymbol == exchangeSymbol
      select new
      {
          c.companyName,
          c.companyId,
          ti.tickerSymbol,
          e.exchangeSymbol,
          pt.periodTypeName,
          fp.fiscalYear,
          fd.dataItemId,
          di.dataItemName,
          fd.dataItemValue
      }).ToList();

Posted 13-Oct-15 23:00pm

Athul MS

Updated 14-May-20 23:58pm

Krunal Rohit

v2

Add a Solution

4 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)

Krunal Rohit · Answer 1 · 2015-10-13T23:15:00

Don't pass any anonymous type to the view. Rather create one ViewModel of your models & make a query for it.

Read this for example:
http://stackoverflow.com/questions/20319324/how-to-pass-custom-linq-query-to-view[^]
http://stackoverflow.com/questions/13037282/pass-linq-query-to-view[^]

-KR

F-ES Sitecore · Answer 2 · 2015-10-13T23:17:00

Create a concrete class (MyViewModel or whatever) that has properties for your fields, so CompanyName, CompanyID, TickerSymbol etc, and create a List<myviewmodel> from your query rather than the anonymous type you're creating now.

C#

select new MyViewModel
      {
          CompanyName = c.companyName,
          CompanyID = c.companyId,
          ...
      }).ToList();

Have your view accept List<MyViewModel> as it's type. Not sure if the above code is the exact syntax you need, google for converting linq query to concrete class if it isn't.

Umar_Farooq · Answer 3 · 2015-10-14T01:34:00

Solution 3

study this link

https://www.microsoftvirtualacademy.com/en-us/training-courses/introduction-to-asp-net-mvc-8322?l=nKZwZ8Zy_3504984382[^]

Everything about MVC

Posted 14-Oct-15 1:34am

Umar_Farooq

Member 14833140 · Answer 4 · 2020-05-14T23:58:00

First, you create a concrete class "InfoViewModel" for example that has properties for your fields in the select statement: CompanyName, CompanyID, TickerSymbol, etc,

public class InfoViewModel<br />
    {<br />
        public string CompanyName { get; set; }<br />
        public string CompanyID { get; set; }<br />
        etc...<br />
    }

then create a List<infoviewmodel> from your query in the PageModel
public List<InfoViewModel> Info= new List<InfoViewModel>();
and then create a foreach loop after the select statement to store the query result in the list you created, in order not to have a conflict regarding the anonymous type error that you will face.

<br />
select new <br />
      {<br />
          CompanyName = c.companyName,<br />
          CompanyID = c.companyId,<br />
          etc...<br />
      }).ToList();<br />
<br />
<br />
 foreach (var item in q)<br />
                {<br />
                    InfoViewModel info = new InfoViewModel();<br />
                    info.CompanyName = item.CompanyName ;<br />
                    info.CompanyID = item.CompanyID ;<br />
                    etc...<br />
                    Info.Add(info);<br />
                }<br />

then in the .cshtml ViewModel:

<tbody><br />
                @foreach (var item in Model.Info)<br />
                {<br />
                    <tr><br />
                        <td><br />
                            @Html.DisplayFor(modelItem => item.CompanyName)<br />
                        </td><br />
                        <td><br />
                            @Html.DisplayFor(modelItem => item.CompanyID)<br />
                        </td><br />
                    </tr><br />
                }<br />
            </tbody>

how to pass linq list to view in mvc

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0