Update By Query: The variable name '@p__linq__0' has already been declared.

[wmwood]

When ever I try to do a update by query, i get the following Exception message:

"The variable name '@p__linq__0' has already been declared. Variable names must be unique within a query batch or stored procedure."

[RudeySH]

Can you provide a code example that reproduces this issue?

[DusanSenior]

Hi, I have similar problem, there is an example (like your example EFBatchOperation.For(db, db.Comments).Where(x => x.Text == "a").Update(x => x.Reads, x => x.Reads + 1);)

var value1 = 1 var value2 = 2 EFBatchOperation.For(db, db.Comments) .Where(x => x.Reads == value1) .Update(x => x.Reads, x => value2); The variable name '@p__linq__0' has already been declared... is thrown Note: If I have used constant instead of variables all is OK But I would like to execute update Comments set Reads = @2 where Reads = @1 Thanks Dusan

[austinw-fineart]

Another example:

var userId = 1;
var now = DateTime.UtcNow;
EFBatchOperation.For(db, db.Comments)
    .Where(x => x.UserId == userId && x.ReadAt == null)
    .Update(x => x.ReadAt, x => now);