Cannot implicitly convert anonymous type #1[] to anonymous type #2[]

anonymous-types asp.net-mvc-4 c# entity-framework linq

Question

I have following scenario:

public JsonResult ChangeFilterList(int option)
{
    var data = new[] { new { Text = "Unknown option", Value = -1 } };
    switch (option)
    {
        case 2: data = _departmentnameRepository.All.Select(x => new { Text = x.DeptName, Value = x.Id }).ToArray();
            break;
        case 3: data = Session["projectid"] == null
                ? _assetSequenceRepository.All.Select(x => new { Text = x.AssetShotName, Value = x.Id }).ToArray()
                : _assetSequenceRepository.FindBy(p => p.ProjectId == (int)Session["projectid"]).Select(x => new { Text = x.AssetShotName, Value = x.Id }).ToArray();
            break;
        default: data = _userRepository.All.Select(x => new { Text = x.DisplayName, Value = x.UserID }).ToArray();
            break;
    }            

    return Json(data, JsonRequestBehavior.AllowGet);
}

case2 and default looks great but complains on case 3 (conditional) saying: Cannot implicitly convert type 'AnonymousType#1[]' to 'AnonymousType#2[]'. Shouldn't ?: be able to decide the type since i already have provided the blueprint for the anonymous as var data = new[] { new { Text = "Unknown option", Value = -1 } };.

Solution:

@Darin Dimitrov answer is great but i want to have some test with anonymous types (Simple cases always need it). As @Douglas suspects : My assetSequenceRepository is supplying id as long and anonymous Value goes in favor of int not long. since C# compiler does not implicitly cast long to int, i got the error. Compiling snippet is:

public JsonResult ChangeFilterList(int option = 3)
        {
            var data = new[] { new { Text = "Unknown option", Value = long.MaxValue } };
            switch (option)
            {
                case 2: data = _departmentnameRepository.All.Select(x => new { Text = x.DeptName, Value = (long)x.Id }).ToArray();
                    break;
                case 3: data = Session["projectid"] == null
                        ? _assetSequenceRepository.All.Select(x => new { Text = x.AssetShotName, Value = x.Id }).ToArray()
                        : _assetSequenceRepository.FindBy(p => p.ProjectId == (int)Session["projectid"]).Select(x => new { Text = x.AssetShotName, Value = x.Id }).ToArray();
                    break;
                default: data = _userRepository.All.Select(x => new { Text = x.DisplayName, Value = (long)x.UserID }).ToArray();
                    break;
            }            

            return Json(data, JsonRequestBehavior.AllowGet);
        }
1
3
11/1/2013 6:39:39 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

My guess is that your FindBy method returns objects whose properties have different types from the ones you're expecting (e.g. int? instead of int). Try specifying a type cast to ensure that your anonymous type has the correct definition:

case 3: data = Session["projectid"] == null
             ? _assetSequenceRepository.All.Select(x => new { Text = x.AssetShotName, Value = x.Id }).ToArray()
             : _assetSequenceRepository.FindBy(p => p.ProjectId == (int)Session["projectid"]).Select(x => new { Text = (string)x.AssetShotName, Value = (int)x.Id }).ToArray();
        break;

The key change is:

new { Text = (string)x.AssetShotName, Value = (int)x.Id })
                  ↖    explicit type casts    ↗
4
10/7/2013 12:15:58 PM

Popular Answer

You are putting the compiler to a real test here. Just write a view model to end its suffering and make things more explicit:

public class MyViewModel
{
    public int Value { get; set; }
    public string Text { get; set; }
}

and then project your LINQ queries to this view model to avoid any possible ambiguity that might arise from the use of the conditional operator and anonymous types:

public ActionResult ChangeFilterList(int option)
{
    var data = new[] 
    { 
        new MyViewModel { Text = "Unknown option", Value = -1 } 
    };

    switch (option)
    {
        case 2: data = _departmentnameRepository
            .All
            .Select(x => new MyViewModel { Text = x.DeptName, Value = x.Id })
            .ToArray();
            break;
        case 3: data = Session["projectid"] == null
                ? _assetSequenceRepository
                    .All
                    .Select(x => new MyViewModel { Text = x.AssetShotName, Value = x.Id })
                    .ToArray()
                : _assetSequenceRepository
                    .FindBy(p => p.ProjectId == (int)Session["projectid"])
                    .Select(x => new MyViewModel { Text = x.AssetShotName, Value = x.Id })
                    .ToArray();
            break;
        default: data = _userRepository
            .All
            .Select(x => new MyViewModel { Text = x.DisplayName, Value = x.UserID })
            .ToArray();
            break;
    }            

    return Json(data, JsonRequestBehavior.AllowGet);
}
Darin Dimitrov

Related Questions

The anonymous type of a Linq query cannot be transformed to a POCO object.

I have the following linq query ... ...public List<UserProject> GetProjectsByUser(int userid) { //var query = return ( from p in this.Entities.Projects join c in this.Entities.Categories on p.CategoryId equals c.CategoryId join u in this.Entities.Users on p...
entity-framework linq linq-to-sql
asked by Kevin Donde

Cannot implicitly convert type System.Collections.Generic.IEnumerable<> to bool

You might want another ....Any... instead of a ....Where... in your ....Any... clause at the end:...var customer = db.GNL_Customer.Where(d => d.GNL_City.FKProvinceID == advancedProvinceID || advancedProvinceID == null) .Where(d => d.FKCityID == advancedCityID || advancedCityID == null) .Where(d => d.FKDepartmentStoreID == ad...
c# entity-framework
asked by Andrew Whitaker

Cannot implicitly convert type 'System.Collections.Generic.List<AnonymousType#1>' to 'System.Collections.Generic.IEnumerable

Now that im trying the Right Join An Exception Popped up. ...This is my Controller... public IEnumerable<APPLICANT> GetApplicant() { IEnumerable<APPLICANT> applicantdata = Cache.Get("applicants") as IEnumerable<APPLICANT>; IEnumerable<Profile> profiledata = Cache.Get("profiles") as IEnumerable<Profile>; if (applicant...
asp.net asp.net-mvc c# entity-framework linq
asked by Enrique Gil

Cannot implicitly convert type '.List<AnonymousType#1>' to '.List<WebApplication2.Customer>'

You are selecting to an anonymous type, which is not a ...Customer.......If you want to do (sort of) this, you can write it like this:...return db.Customers.Select(x => new Customer { Name = x.CustName, Email = x.CustEmail, Address = x.CustAddress, ContactNo = x.ContactNo }).ToList(); ...This assumes the properties on your ...Customer... object are...
asp.net c# entity-framework linq
asked by Mark Avenius

An anonymous type cannot have multiple properties with the same name

I want to bind gridview through entity framework but it throws error like-...An anonymous type cannot have multiple properties with the same name Entity Framwrok...Here is my method....public void UserList(GridView grdUserList) { using (TreDbEntities context = new TreDbEntities()) { var query =( from m in context.aspnet_Membership...
entity-framework
asked by Mukesh Bhagat

Cannot implicitly convert type System.Linq.IQueryable<string> to string

I have two tables named Rank and CrewMembers.I want to fetch the name of rank which is present in Rank table on the basis of id of CrewMember.I have passed the crewId as a parameter and on the basis of that the method would return the Rank of that specific Crew Member.This is how my code is-... public string GetRank(int CrewId) { ...
c# entity-framework iqueryable linq
asked by prers

Cannot implicitly convert type System.Data.Entity.Core.Objects.ObjectResult to System.Data.Objects.ObjectResult

You need to upgrade to the new Entity Framework 6 runtime....Right-click on your project and select ...Manage NuGet Packages...... Under the ...Online... tab select ...EntityFramework... and click ...Install... Note: If a previous version of the EntityFramework NuGet package was installed this will upgrade it to EF6. Alternatively, you can run the ...
c# entity-framework
asked by Akira Yamamoto

Error: Cannot implicitly convert type 'System.Data.Entity.DbSet' to 'System.Linq.IQueryable'

I am trying to follow the following tutorial: ASP.NET Web Forms Getting started with Web Forms and Visual studio (URL: ...http://www.asp.net/web-forms/overview/getting-started/getting-started-with-aspnet-45-web-forms/introduction-and-overview...)....I have other names in my project but the idea is the same. I am trying to create a Reservations syst...
asp.net entity-framework linq webforms
asked by Marjolein

Cannot implicitly convert type 'void' to 'int'?

The method...public void StoreMail(PhishingMail PhishingMail)...is not returning any value. So when you do:...phishingMailId = _storageAgent.StoreMail(phishingMail);...You are getting that error, since ...StoreMail... is declared as ...void..., which means it does not return anything....To fix this, simply call ...StoreMail... like this:..._storage...
c# entity-framework int void
asked by Jason Evans

Cannot implicitly convert type 'System.Data.Entity.Core.Objects.ObjectResult<>' to 'int'

I have created a stored procedure and using Entity framework database first approach in MVC application. I am trying to capture the ...requestid... which is an identity field that is generated in my database in the repository method. I am getting a compile time error in my repository method saying ...Error CS0029 Cannot implicitly convert type '...
asp.net-mvc-5 c# entity-framework-6
asked by Tom

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow