Entity framework performance with mysql

• Question

• 

  

  0

  Sign in to vote

  Hi,

  I would really appreciate if anybody can point me to the right direction on how to solve this issue.

  I have the follow query in entity framework. The database in mysql and the ado.net connector is from Devart. It is really slow and most time just timed out. But the same query works fine with mssql. Any body have any suggestions? Thanks in advance.

  (
  from mp in ircontext.ZoomedPixelCoordinateSet
  join c in
  (
  from zp in ircontext.ZoomedPixelCoordinateSet
  where zp.GTileX == gTile.X && zp.GTileY == gTile.Y && zp.Zoom == PointInPolygonZoom
  select new { zp.StateCode, zp.NeighborhoodID, zp.Zoom }
  ).Distinct()
  on new { StateCode = mp.StateCode, NeighborhoodID = mp.NeighborhoodID, Zoom = mp.Zoom }
  equals
  new { StateCode = c.StateCode, NeighborhoodID = c.NeighborhoodID, Zoom = c.Zoom }
  orderby mp.StateCode, mp.NeighborhoodID, mp.SortOrder, mp.OriginalSortOrder
  select new {
  StateCode = mp.StateCode,
  NeighborhoodID = mp.NeighborhoodID,
  TileX = mp.GTileX,
  TileY = mp.GTileY,
  X = mp.GX,
  Y = mp.GY,
  SortOrder = mp.SortOrder
  }
  ).ToList();

  • Moved by Michael Sun [MSFT]Microsoft employee Tuesday, August 3, 2010 12:33 PM 3rd party EF provider issue (From:ADO.NET Entity Framework and LINQ to Entities)

  Monday, August 2, 2010 5:59 AM