You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
System.Data.SqlClient.SqlException (0x80131904): The variable name '@p__linq__0' has already been declared. Variable names must be unique within a query batch or stored procedure.
The problem is that EFUtilities declared the same variable twice.
I'm using the latest release (1.0.2.0).
The text was updated successfully, but these errors were encountered:
This code...
EFBatchOperation.For(_repo, _repo.CityServices)
.Where(cs => cs.serviceid == serviceid && citiesInThisFieldOffice.Contains(cs.cityid) && cs.status)
.Update(x => x.updatedby, x => userId);
..generated this update...
exec sp_executesql N'UPDATE [dbo].[cityservices] SET [updatedby] = @p__linq__0 WHERE ([serviceid] = @p__linq__0) AND ([cityid] IN (6688, 4934, 2215, 2302, 2210, 6725, 6749, 7217, 7241, 7329, 3959, 5615, 7405, 7406, 7412, 7414, 7417, 7425, 7432, 7443, 7444, 7448, 7449, 7450, 7452, 7456, 7463, 7464, 7465, 7471, 7473, 7476, 6946, 7389, 7142, 4519, 2231, 16756, 6763, 7256, 6719, 6371)) AND ([status] = 1)',N'@p__linq__0 int,@p__linq__0 int',@p__linq__0=531,@p__linq__0=711
go
System.Data.SqlClient.SqlException (0x80131904): The variable name '@p__linq__0' has already been declared. Variable names must be unique within a query batch or stored procedure.
The problem is that EFUtilities declared the same variable twice.
I'm using the latest release (1.0.2.0).
The text was updated successfully, but these errors were encountered: