ef mysql 参数化_请教EF中生成参数化的动态查询的方法

SELECT`Filter1`.`UserId`,

`Filter1`.`DebtorName`,

`Extent4`.`UserId`AS`UserId1`FROM(SELECT`Extent1`.`Id`,

`Extent1`.`ServiceId`,

`Extent1`.`DebtorId`,

`Extent1`.`CustomerId`,

`Extent1`.`CustomerName`,

`Extent1`.`CurrencyTypeName`,

`Extent1`.`CityId`,

`Extent1`.`CityName`,

`Extent1`.`ProvinceId`,

`Extent1`.`ProvinceName`,

`Extent1`.`OutDate`,

`Extent1`.`DueDate`,

`Extent1`.`OutAmount`,

`Extent1`.`CurrentOutAmount`,

`Extent1`.`OutRMBAmount`,

`Extent1`.`CurrentRMBAmount`,

`Extent1`.`CSName`,

`Extent1`.`CustAgentName`,

`Extent1`.`OutIDNumber`,

`Extent1`.`OutIDType`,

`Extent1`.`AccountNumber`,

`Extent1`.`OutNumber`,

`Extent1`.`OutLageDay`,

`Extent1`.`OutAccountAge`,

`Extent1`.`FeeRate`,

`Extent1`.`AccountFeatureId`,

`Extent1`.`AccountBasicWorkStateId`,

`Extent1`.`AccountSupervisionId`,

`Extent1`.`AccountDataResultId`,

`Extent1`.`AccountCategoryId`,

`Extent1`.`AddTime`,

`Extent1`.`UpdateTime`,

`Extent1`.`AddUserId`,

`Extent1`.`UpdateUserId`,

`Extent1`.`IsValid`,

`Extent2`.`Id`AS`ID1`,

`Extent2`.`AccountId`,

`Extent2`.`UserId`,

`Extent2`.`UserName`,

`Extent2`.`AllotmentId`,

`Extent2`.`GroupId`,

`Extent2`.`GroupName`,

`Extent2`.`UnitId`,

`Extent2`.`UnitName`,

`Extent2`.`CompanyId`,

`Extent2`.`CompanyName`,

`Extent2`.`AccountStateId`,

`Extent2`.`OscarWorkStateId`,

`Extent2`.`ProgressStateId`,

`Extent2`.`ProgressValue`,

`Extent2`.`VisitStateId`,

`Extent2`.`MailApprovalStateId`,

`Extent2`.`UserRemark`,

`Extent2`.`SupervisorRemark`,

`Extent2`.`CSRemark`,

`Extent2`.`AuditRemark`,

`Extent2`.`LastWorkTime`,

`Extent2`.`NextWorkTime`,

`Extent2`.`CloseTime`,

`Extent2`.`CurrentLagDay`,

`Extent2`.`CurrentAccountAge`,

`Extent2`.`LastRepayTime`,

`Extent2`.`LastRepayAmount`,

`Extent2`.`NextTimeRemark`,

`Extent2`.`IsWorking`,

`Extent2`.`StarUserIdArry`,

`Extent2`.`AddTime`AS`ADDTIME1`,

`Extent2`.`UpdateTime`AS`UPDATETIME1`,

`Extent2`.`AddUserId`AS`ADDUSERID1`,

`Extent2`.`UpdateUserId`AS`UPDATEUSERID1`,

`Extent2`.`IsValid`AS`ISVALID1`,

`Extent3`.`Id`AS`ID2`,

`Extent3`.`DebtorName`,

`Extent3`.`IDNumber`,

`Extent3`.`IDTypeName`,

`Extent3`.`SexTypeName`,

`Extent3`.`Age`,

`Extent3`.`AddTime`AS`ADDTIME2`,

`Extent3`.`UpdateTime`AS`UPDATETIME2`,

`Extent3`.`AddUserId`AS`ADDUSERID2`,

`Extent3`.`UpdateUserId`AS`UPDATEUSERID2`,

`Extent3`.`IsValid`AS`ISVALID2`FROM`T_Account`AS`Extent1`INNER JOIN `T_AccountBasicWorkState` AS `Extent2` ON `Extent1`.`AccountBasicWorkStateId` =`Extent2`.`Id`INNER JOIN `T_Debtor` AS `Extent3` ON `Extent1`.`DebtorId` =`Extent3`.`Id`WHERE`Extent1`.`IsValid`= 1 --常量部分的条件在里

AND `Extent2`.`IsWorking` = 1)AS`Filter1`LEFT OUTER JOIN `T_AccountBasicWorkState` AS `Extent4` ON `Filter1`.`AccountBasicWorkStateId` =`Extent4`.`Id`WHERE`Filter1`.`UserId`= @p__linq__0 --变量部分的条件在外，导致子查询的过滤条件缺失，多扫描了NNNN倍的行

AND `Filter1`.`DebtorName` = @p__linq__1

AND `Filter1`.`AccountSupervisionId` > @p__linq__2