How can we get list of two column say firstname and lastname from customer table in MVC using linq query also how to create a view for that

Question

1.44/5 (2 votes)

See more:

Every time I run this I get an error:

Unable to cast object of type 'System.Collections.Generic.List1[<>f__AnonymousType1 2[System.String,System.String]]' to type 'System.Collections.Generic.IEnumerable1[CRUD__MVC.Models.Customer]

What I have tried:

//Scenario 1

C#

public ActionResult FirstLastName()
{
    return View(Name()); 
}

IEnumerable<customer>Name()   
{
    using (AdventureWorksLTDataContext db = new AdventureWorksLTDataContext())
    {
        return (IEnumerable<customer>)db.Customers.Select(c => new { FirstName = c.FirstName, LastName = c.LastName }).ToList();
    }
}

//Scenario 2

C#

IEnumerable<customer> Name()   
{
            
return db.Customers.Select(c => new Customer { FirstName = c.FirstName, LastName = c.LastName });
            
}

Posted 20-Jan-22 3:21am

Avinash yadav 2022

Updated 20-Jan-22 7:56am

PIEBALDconsult

v2

Add a Solution

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

M Imran Ansari · Accepted Answer · 2022-01-20T04:12:00

<pre>Use the following code:

IEnumerable<customer>Name()   
{
    using (AdventureWorksLTDataContext db = new AdventureWorksLTDataContext())
    {
        return (IEnumerable<customer>)db.Customers.Select
		(c => new customer //specify customer type!!
						{ 
							FirstName = c.FirstName, 
							LastName = c.LastName 
						}
		).ToList();
    }
}

You are returning anonymous type and missing the specific type.
So this List<customer> is a totally different type than a 
IEnumerable<customer>.

Avinash yadav 2022 · Accepted Answer · 2022-01-20T07:47:00

C#

Well we can generate a class that derives from my LINQ to SQL class

internal class CustomerView: Customer { }

And rewrite the query as.

IEnumerable<customer> Name()   
{
    using (AdventureWorksLTDataContext db = new AdventureWorksLTDataContext())
    {
        var query= db.Customers.Select(c => new CustomerView { FirstName = c.FirstName, LastName = c.LastName }).ToList();
        //Cast it back to Customer
        return (query.Cast<customer>())
    }
}

Avinash yadav 2022 · Accepted Answer · 2022-01-20T07:56:00

Can Anyone tell me how to create a view for that.

This is what I tried.

@model IEnumerable<CRUD__MVC.Models.Customer>

<table class="table">
    <tr>
        
        <th>
            @Html.DisplayNameFor(model => model.FirstName)
        </th>
        
        <th>
            @Html.DisplayNameFor(model => model.LastName)
        </th>
       
    </tr>

@foreach (var item in Model) {
    <tr>
        <td>
            @Html.DisplayFor(modelItem => item.FirstName)
        </td>
        
        <td>
            @Html.DisplayFor(modelItem => item.LastName)
        </td>
        
    </tr>
}

</table>

How can we get list of two column say firstname and lastname from customer table in MVC using linq query also how to create a view for that

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0