Anonymous types

We have a query that looks like this:

var pg = entity as EntPointGroup;

var query = p_manager.EntPointSet

.Where(p => p.p_pointGroup.p_pointGroupID == pg.p_pointGroupID)

.Where(p => !(p.p_geoX == 0 && p.p_geoY == 0))

.GroupBy(p => new {p.p_pointGroupID})

.Select(g => new

{

m_maxGeoX = g.Max(p => p.p_geoX),

m_minGeoX = g.Min(p => p.p_geoX),

m_maxGeoY = g.Max(p => p.p_geoY),

m_minGeoY = g.Min(p => p.p_geoY)

});

It queries for points under a point group. Then we want the min- and maxvalues for x and y from the coordinates of these points to determine a boundary that contains all these points.

The result of this query is an anonymous type and this works fine.

But if I begin moving the points and there by changing their coordinates in the entity model and run the query again – I get the same min max values as before.

This is because it fetches the data from the datasource every time and not from the entity model.

If we make a known type GeoXY and query like this:

var pg = entity as EntPointGroup;

var query = p_manager.EntPointSet

.Where(p => p.p_pointGroup.p_pointGroupID == pg.p_pointGroupID)

.Where(p => !(p.p_geoX == 0 && p.p_geoY == 0))

.GroupBy(p => new {p.p_pointGroupID})

.Select(g => new GeoXY

{

m_maxGeoX = g.Max(p => p.p_geoX),

m_minGeoX = g.Min(p => p.p_geoX),

m_maxGeoY = g.Max(p => p.p_geoY),

m_minGeoY = g.Min(p => p.p_geoY)

});

We get this error:

Caught exception: System.Exception: Unable to locate type: System.Linq.IQueryable`1[[C2Net.CommonClasses.GeoXY, C2NetDomainModel, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Core, Version=2.0.5.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e. Check that the assembly holding this type is available in the bin/exe folder. Also check that both your assemblies and DevForce assemblies have the expected version number on both client and server. at IdeaBlade.Core.TypeWrapper.FindType() at IdeaBlade.Core.TypeWrapper.Restore() at IdeaBlade.Core.TypeWrapper.get_Type() at IdeaBlade.Linq.ExpressionBlock.set_TypeWrapper(.....

We have added GeoXY to the same class that all of our other known types are located.

Is it even possible to query like this on the entity model?

Hi Silvio,

Yes it is present in both client and server

[System.Runtime.Serialization.DataContract]

public class GeoXY : IdeaBlade.EntityModel.IKnownType

{

[System.Runtime.Serialization.DataMember]

       public double m_maxGeoX { get; set; }

       [System.Runtime.Serialization.DataMember]

       public double m_minGeoX { get; set; }

       [System.Runtime.Serialization.DataMember]

       public double m_maxGeoY { get; set; }

       [System.Runtime.Serialization.DataMember]

       public double m_minGeoY { get; set; }

}