UseGenerateCommandParameterWithLambda(true)时子语句的参数没整合到主语句

[tky753]

[Table(Name = "EDI")]
public class Edi
{
    [Column(Name = "EDI_ID")] public long Id { get; set; }
}

[Table(Name = "EDI_ITEM")]
public class EdiItem
{
    [Column(Name = "EDII_ID")] public long Id { get; set; }
    [Column(Name = "EDII_EDI_ID")] public long EdiId { get; set; }
}

......

var itemId = 1;
var edi = fsql.Select<Edi>()
    .Where(a=>fsql.Select<EdiItem>().Where(b=>b.Id==itemId).Any())
    .First(a=>a);

会报 必须声明标量变量 "@exp_0"
看DbCommand中 参数个数为0
生成sql没有问题。

SELECT TOP 1 a.[EDI_ID] as1
FROM [EDI] a
WHERE (exists(SELECT TOP 1 1
        FROM [EDI_ITEM] b
        WHERE (b.[EDII_ID] = @exp_0)))

[2881099]

好的，UseGenerateCommandParameterWithLambda 可能还有其他问题存在

[2881099]

#200 的问题我回复了，看一下 @tky753

[tky753]

回复了，
稍微更正一下，sql因该也是有点问题的

var id = 1; //主语句变量
var itemId = 1; //子语句变量
var edi = fsql.Select<Edi>()
    .Where(a=>a.Id == id)
    .Where(a=>fsql.Select<EdiItem>().Where(b=>b.Id==itemId).Any())
    .First(a=>a);
            WriteLine(edi.Id);

SELECT TOP 1 a.[EDI_ID] as1 
FROM [EDI] a 
WHERE (a.[EDI_ID] = @exp_0) AND (exists(SELECT TOP 1 1 
	FROM [EDI_ITEM] b 
	WHERE (b.[EDII_ID] = @exp_0)))
--两个都是@exp_0了

[2881099]

这是一个问题，只要把两个 IFreeSql._dbParams 弄成一个引用就好了

[2881099]

var itemId2 = 2;
var itemId = 1;
var edi = g.sqlite.Select<Edi>()
   .Where(a => a.Id == itemId2 && g.sqlite.Select<EdiItem>().Where(b => b.Id == itemId).Any())
   .First(a => a); //#231

SELECT a."EDI_ID" as1 
FROM "EDI" a 
WHERE (a."EDI_ID" = @exp_0 AND exists(SELECT 1 
	FROM "EDI_ITEM" b 
	WHERE (b."EDII_ID" = @exp_1) 
	limit 0,1)) 
limit 0,1

[tky753]

圆满了