System.Linq.IQueryable auto generated properties throws exception properties defined in a partial class

Sorry for the long heading but is there a way to overcome this?

I have the following autogenerated property against my database:

 public System.Linq.IQueryable<AgentLocation> AgentLocations
    {
      get { return this.Query<AgentLocation>(); }
    }

I have a partial class called AgentLocation which contains a property say Geometry. Of course, there is no such column in the AgentLocation table.

When I try to use AgentLocations to query against the database, like so:

var agents = AgentLocations.Where(a => a.Id == 0)

an exception is thrown indicating Geometry is not a valid column. True but can I get around this?

Also, it looks like this IQueryable does not support Join. Is this correct?

If you are adding custom fields (e.g. you are adding the Geometry property) you must write the property with a declared backing field and you can then apply the [Transient] attribute to the field which will tell LightSpeed to ignore it from any queries/persistence - e.g.

[Transient]
private string _geometry;

public string Geometry
{
  get { return _geometry; }
  set { _geometry = value; }
}

In terms of supporting .Join, LightSpeed's LINQ provider supports translation of .Join assuming it is actually valid to translate. Are you having a specific problem with a query where it is throwing a NotSupportedException or the like?

Jeremy