我正在嘗試在 EF 中調(diào)用 SQL SCALAR 函數(shù)。我嘗試了各種示例,但我不斷收到:無(wú)法將類型 y 上的指定方法 x 轉(zhuǎn)換為 LINQ to Entities 存儲(chǔ)表達(dá)式。我在用...英孚 6.1.3EntityFramework.Functions 1.4.1查詢:注意我在 SELECT 中調(diào)用它...public IQueryable<MeterDataItem> Query(){ var query = from meter in UnitOfWork.Meter join meterType in UnitOfWork.MeterType on meter.MeterTypeId equals meterType.Id into meterTypeLEFTJOIN from meterType in meterTypeLEFTJOIN.DefaultIfEmpty() join company in UnitOfWork.Company on meter.CompanyId equals company.Id join meterPosition in UnitOfWork.EFMMeterPosition on meter.EFMMeterPositionId equals meterPosition.Id into meterPositionLEFTJOIN from meterPosition in meterPositionLEFTJOIN.DefaultIfEmpty() join flowType in UnitOfWork.FlowType on meter.FlowTypeId equals flowType.Id into flowTypeLEFTJOIN from flowType in flowTypeLEFTJOIN.DefaultIfEmpty() join fluidType in UnitOfWork.FluidType on meter.FluidTypeId equals fluidType.Id into fluidTypeLEFTJOIN from fluidType in fluidTypeLEFTJOIN.DefaultIfEmpty() join runStatus in UnitOfWork.RunStatus on meter.RunStatusId equals runStatus.Id into runStatusLEFTJOIN from runStatus in runStatusLEFTJOIN.DefaultIfEmpty() join pipeline in UnitOfWork.Pipeline on meter.PipelineId equals pipeline.Id into pipelineLEFTJOIN from pipeline in pipelineLEFTJOIN.DefaultIfEmpty() // Device portion join device in UnitOfWork.Device on meter.DeviceId equals device.Id into deviceLEFTJOIN from device in deviceLEFTJOIN.DefaultIfEmpty() join rtuDevice in UnitOfWork.RTUDevice on device.Id equals rtuDevice.DeviceId into rtuDeviceLEFTJOIN from rtuDevice in rtuDeviceLEFTJOIN.DefaultIfEmpty()
- 1 回答
- 0 關(guān)注
- 166 瀏覽
添加回答
舉報(bào)
0/150
提交
取消