MySQL Mapping, no results returned.

I'm having some trouble mapping out a MySQL database. I'm starting small and just wanting to get two tables working.

I have workOrders and workOrderJobs tables that look something like:

[workOrders] workOrderID (Primary Key)

[workOrderJobs] workOrderJobID (Primary Key) workOrderID (Foreign Key)

I've brought both tables into the designer via the server explorer. I then grabbed a one to many tool and connected from workOrders to workOrderJobs. I then set the Key Property Reference to "workOrderID" and ran this query:

Public Sub New()
            Dim obj As Object
            Dim ctx = New LightSpeedContext(Of Models.ThisModelUnitOfWork)("ThisContext")
            ctx.Logger = New TraceLogger()
            Dim uow = ctx.CreateUnitOfWork()
            Dim wo = uow.WorkOrders.Single(Function(x) x.Code = "35477").WorkOrderJobs
End Sub

This results in a query result set of count 0. As you see I've added a tracelogger to see exactly what sql is being constructed.

SELECT
  workOrderJobs.workOrderJobID AS "workOrderJobs.workOrderJobID",
  workOrderJobs.BudgetedTime AS "workOrderJobs.BudgetedTime",
  workOrderJobs.Detail AS "workOrderJobs.Detail",
  workOrderJobs.JobId AS "workOrderJobs.JobId",
  workOrderJobs.Sequence AS "workOrderJobs.Sequence",
  workOrderJobs.WorkOrderId AS "workOrderJobs.WorkOrderId"
FROM
  workOrderJobs
WHERE
  workOrderJobs.WorkOrderId = 10124

If I execute this exact statement against my database I get a result set of count 5. I'm not sure what's going on here. I've tried several different workorders that I know have multiple workorderjobs and some will return a single workorderjob but never a collection. Any help would be appreciated.

Thanks, Stephen

Remove the Key Property Reference definition. This is only valid for composite key based entities.

Jeremy