Error: Cannot Implicitly Convert to To System.linq.iqueryable<System.Linq.IGrouping<string,AnonymousType#1>> to system.Collection.List<>, and explicit conversion exist..are you missing a cast ?

Question

0.00/5 (No votes)

See more:

hy i am not very much familiar to asp.net . Explain briefly why em encountering this error.

here is my code

C#

public List<Department> getDeptNames(){
using (
RailwayElectricBillingDBEntities context = new RailwayElectricBillingDBEntities())
{
var obj = context.Departments.ToList();
List<Department> dic = (from p in context.Departments
select new { p.DepartmentId, p.DepartmentName }).GroupBy( o=> o.DepartmentName);
return obj;

}}

Posted 4-Mar-15 18:24pm

Arif H Shigri

Add a Solution

Comments

Tejas Vaishnav 5-Mar-15 1:28am

can you share your Department class here, so i can help you with your problem.

Arif H Shigri 5-Mar-15 4:05am

public partial class Department
{
public Department()
{
this.Employees = new HashSet<employee>();
}

public int AddressId { get; set; }
public int ZoneId { get; set; }
public int DepartmentId { get; set; }
public string DepartmentName { get; set; }
public string PhoneNo { get; set; }

public virtual Address Address { get; set; }
public virtual Zone Zone { get; set; }
public virtual ICollection<employee> Employees { get; set; }
}

Arif H Shigri 5-Mar-15 4:14am

The entity or complex type 'RailwayElectricBillingDBModel.Department' cannot be constructed in a LINQ to Entities query.

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tejas Vaishnav · Answer 1 · 2015-03-04T19:42:00

suppose your Department class is something

C#

public class department
   {
       public int DepartmentId { get; set; }
       public string DepartmentName  { get; set; }
   }

then you need to write your query like this...

C#

public List<Department> getDeptNames()
    {
        using (RailwayElectricBillingDBEntities context = new RailwayElectricBillingDBEntities())
        {
            List<Department> dic = (from p in context.Departments
                                    select new Department
                                        {
                                            DepartmentId = p.DepartmentId,
                                            DepartmentName = p.DepartmentName
                                        }
                                    ).ToList();
            return obj;
        }
    }

debashishPaul · Answer 2 · 2015-03-04T19:46:00

(from p in context.Departments
select new { p.DepartmentId, p.DepartmentName }).GroupBy( o=> o.DepartmentName);

You are selecting an Anonymous type, hence will not be able to cast it to List<department></department>

Try:

C#

(from p in context.Departments
select p).GroupBy( o=> o.DepartmentName).ToList();

manu g m · Answer 3 · 2015-03-04T18:42:00

Solution 1

Try this

C#

List<department> dic =(List<department>) (from p in context.Departments
select new { p.DepartmentId, p.DepartmentName }).GroupBy( o=> o.DepartmentName);</department></department>

Posted 4-Mar-15 18:42pm

manu g m

Comments

Arif H Shigri 5-Mar-15 0:59am

Now Getting This Error:
Unable to cast object of type 'System.Data.Entity.Infrastructure.DbQuery`1[System.Linq.IGrouping`2[System.String,<>f__AnonymousType0`2[System.Int32,System.String]]]' to type 'System.Collections.Generic.List`1[DataLayer.Department]'.

Error: Cannot Implicitly Convert to To System.linq.iqueryable<System.Linq.IGrouping<string,AnonymousType#1>> to system.Collection.List<>, and explicit conversion exist..are you missing a cast ?

3 solutions

Solution 2

Solution 3

Solution 1

Add your solution here

Preview 0

Error: Cannot Implicitly Convert to To System.linq.iqueryable<System.Linq.IGrouping<string,AnonymousType#1>> to system.Collection.List<>, and explicit conversion exist..are you missing a cast ?

3 solutions

Solution 2

Solution 3

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us