Object does not contain "fullname" LINQ error

Question

I am a beginner to MVC and using Linq. So any help would be much appreciated.

So I have this LINQ statement to select and join my 3 tables,

OnlineRegistrationDBEntities1 dbEvents = new OnlineRegistrationDBEntities1();

var displayRegisteredEvents = (from x in dbEvents.Registers
                              join c in dbEvents.clients on x.email equals c.email
                              join e in dbEvents.events on x.eventname equals e.eventname
                              select new 
                              {
                                  fullname = c.fullname,
                                  eventname = e.eventname,
                                  email = c.email,
                                  guestnumber = x.guestnumber,
                                  payment_amount = x.payment_amount
                              });

return View(displayRegisteredEvents);

And I'm trying to display the result on an HTML table like this,

<tbody>
        @foreach (var i in Model)
        {
            <tr>
                <td>@i.fullname</td>
                <td>@i.eventname</td>
                <td>@i.email</td>
                <td>@i.guestnumber</td>
                <td>@i.payment_amount</td>
                <td>
                    <button type="button" class="modalLink btn btn-danger" data-id="@i.email" data-toggle="modal" data-target="#editModal">
                        Delete
                    </button>

                </td>
            </tr>
        }
</tbody>

However, when I run the program an error occurs saying:

'object' does not contain a definition for 'fullname'

Any idea what's wrong? Please help. Thanks a lot.

Hi, good sir thank you for the help. You mean you wanna see the Model of my project? — jeloneedshelp, May 22 '20 at 09:24
No, it should be definition of your model in cshtml like `@model IEnumerable`, could you please share it. — Selim Yildiz, May 22 '20 at 09:32
So, where this model in `@foreach (var i in Model)` comes from then? — Selim Yildiz, May 22 '20 at 09:36
Oh in my controller I added my model library like this, using OnlineEventRegistration.Models; — jeloneedshelp, May 22 '20 at 09:38
You return IEnumerable anonymus objects from controller, so you can add `@model IEnumerable` to view — Selim Yildiz, May 22 '20 at 09:39
Please let me know after try whether it solves your problem or not, so that I can add this to an answer. — Selim Yildiz, May 22 '20 at 09:41
Hi sir, I tried adding that @model IEnumerable to my view, it still outputs the same error. — jeloneedshelp, May 22 '20 at 09:47
What do you see when you put debug inside of foreach, what is the type of `Model` and do you have data in model? — Selim Yildiz, May 22 '20 at 09:54
@model IEnumerable that is my definition and that model contains the FK of my other two table. — jeloneedshelp, May 22 '20 at 10:03
System.InvalidOperationException: The model item passed into the dictionary is of type 'System.Data.Entity.Infrastructure.DbQuery`1[<>f__AnonymousType1`5[System.String,System.String,System.String,System.Nullable`1[System.Int32],System.Nullable`1[System.Double]]]', but this dictionary requires a model item of type 'System.Collections.Generic.IEnumerable`1[OnlineEventRegistration.Models.Register]'.. That is the error when I run it sir. — jeloneedshelp, May 22 '20 at 10:04
You need to create new POCO class and return it from controller, I have added an answer plase check. — Selim Yildiz, May 22 '20 at 10:10

Selim Yildiz · Accepted Answer · 2020-05-22T10:14:41.210

Since you are using anonymous types, from: Anonymous View Models in ASP.NET MVC Using Dynamics

The answer here lies in the fact that anonymous classes are internal by default, meaning they are only accessible to the assembly in which they were created. Once you cross that assembly boundary, it gets treated as a regular object

I suggest you that create a new POCO class then pass it to view instead of using anonymous types:

public class OnlineRegistrationViewModel
{
    public string fullname { get; set; }

    public string eventname { get; set; }

    public string email { get; set; }

    public string guestnumber { get; set; }

    public string payment_amount { get; set; }
}

And in your controller you need to return List<OnlineRegistrationViewModel>:

OnlineRegistrationDBEntities1 dbEvents = new OnlineRegistrationDBEntities1();

var displayRegisteredEvents = (from x in dbEvents.Registers
                              join c in dbEvents.clients on x.email equals c.email
                              join e in dbEvents.events on x.eventname equals e.eventname
                              select new OnlineRegistrationViewModel
                              {
                                  fullname = c.fullname,
                                  eventname = e.eventname,
                                  email = c.email,
                                  guestnumber = x.guestnumber,
                                  payment_amount = x.payment_amount
                              }).ToList();

return View(displayRegisteredEvents);

In your view you need to declare Model:

@model List<OnlineRegistrationViewModel>

See these references:

Object does not contain "fullname" LINQ error

1 Answers1