Getting error during create list in ASP.NET MVC View

Question

I am trying to fetch the data from database using database first approach and want to display the data in a list.. I am trying the following code for this

This is my Action method

 public ActionResult transaction()
        {

            var result = from T in db.tbProcTransactions
                         select T.pServiceID;
            return View(result);
        }

and in my view I write this

@model IEnumerable<LinQuery.Models.tbProcTransaction>

@{
    ViewBag.Title = "transaction";
}

<h2>transaction</h2>

@foreach (var serviceID in @Model.pServiceID)
{
    @serviceID;
}

But when I run this code I get this Error

System.Collections.Generic.IEnumerable' does not contain a definition for 'pServiceID' and no extension method 'pServiceID' accepting a first argument of type 'System.Collections.Generic.IEnumerable' could be found (are you missing a using directive or an assembly reference?)

I am unable to resolve this error Please resolve this error experts

is this possibly blogs.msdn.com/b/webdev/archive/2014/10/16/… ? — Martijn
– Martijn, Commented Oct 18, 2014 at 10:52
You are returning an IEnumerable<typeof(pServiceID)>. Simplest solution is to use select T; instead of select T.pServiceID; — Satpal
– Satpal, Commented Oct 18, 2014 at 10:54

user3559349 · Accepted Answer · 2014-10-18 10:52:20Z

2

Change your foreach statement to

@foreach (var serviceID in Model)
{
  @serviceID;
}

answered Oct 18, 2014 at 10:52

user3559349

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

Comments

Spider man · Accepted Answer · 2014-10-19 13:10:43Z

0

In Action select T instead of T. pServiceID

answered Oct 19, 2014 at 13:10

Spider man

3,3604 gold badges32 silver badges43 bronze badges

Comments

AstroCB · Accepted Answer · 2014-10-20 01:14:56Z

0

Try this:

@model IEnumerable<LinQuery.Models.tbProcTransaction>

@{
    ViewBag.Title = "transaction";
}

<h2>transaction</h2>

@foreach (var serviceID in Model)
{
    serviceID.pServiceID;
}

edited Oct 20, 2014 at 1:14

AstroCB

12.4k20 gold badges59 silver badges75 bronze badges

answered Oct 19, 2014 at 23:56

Louis Michael

3981 silver badge12 bronze badges

Collectives™ on Stack Overflow

Getting error during create list in ASP.NET MVC View

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related