Hi everyone,
I am trying to write a compound join statement using linq-to-sql. I am running into some compile time issues that I can't seem to overcome. Can someone shed some light for me as to what is the best way to proceed with writing linq-to-sql join statements?
Here is what I have so far:
var acc_ped_pos =
from v in vehicles
from e in engine
where v.engine_type == e.engine_type && v.engine_code == e.engine_code
select e.accelerator_pedal_position;
The compiler says "The type or namespace name "SelectMany" does not exist in the namespace "vehicles" (are you missing an assembly reference)?
The name engine does not exist in the current context.
I have my database set up with a table name engine and vehicles.
Thanks in advance for any assistance!