Lightswitch Join query pattern problem RRS feed

  • Question

  • var accState = from obj in this.DataWorkspace.FF_DataExtractData.stg_auto_operators
                               join avo in this.DataWorkspace.FF_DataExtractData.stg_auto_veh_oper_assns on obj.etl_sequence_number equals avo.operator_seq_nbr
                               join pu in this.DataWorkspace.FF_DataExtractData.punits on avo.operator_seq_nbr equals pu.c59_id
                               select pu.a02_state;

    Could not find an implementation of the query pattern for source type 'Microsoft.LightSwitch.Framework.EntitySet<LightSwitchApplication.stg_auto_operator>'.  'Join' not found.  Consider explicitly specifying the type of the range variable 'obj'.

    i want the value of state through this LINQ, 

    operator_seq_nbr, c59_id and etl_sequenceNumber are of LONG type,

    a02_state is of string type.

    Thursday, May 21, 2015 11:42 AM