LINQ to SQL Select new as Custom Type not working!

Question

Hi, can anyone tell me why this doesnt work?

 public class GeocodeCoord
 {
     public string Outcode { get; set; }
     public int X { get; set; }
     public int Y { get; set; }
 }

---

List<GeocodeCoord> _geocode;

using (MyDataContext db = new MyDataContext())
{
   _geocode = db.Geocodes.Select(g => new GeocodeCoord { g.postcode, g.x, g.y }).ToList<GeocodeCoord>();
}

I get the following error:

Cannot initialize type 'Search.GeocodeCoord' with a collection initializer because it does not implement 'System.Collections.IEnumerable'

Thanks

Answer 1

Just use ToList(), the compiler will find the correct type for you.

Answer 2

Type in the property names of the initializer like new GeocodeCoord { Postcode = g.postcode, X = g.x, Y = g.y }

Answer 3

The line should be:

_geocode = db.Geocodes.Select(g => new GeocodeCoord { Outcode = g.postcode, X = g.x, Y = g.y }).ToList();