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
I am using package FluentMigrator.Runner.SqlServer version 3.2.7
The following code:
IDbConnection db = ...;
await db.UpdateAsync(
dbo,
d => d.SettingCollectionKey == collection.Key && d.Key == value.Key
);
`dbo` Model
[Table("SettingCollectionValue")]
internal class SettingCollectionValueDbo
{
public string? SettingCollectionKey { get; set; }
public string? Key { get; set; }
public string? Label { get; set; }
public string? Value { get; set; }
}
Fails with error Microsoft.Data.SqlClient.SqlException (0x80131904): The variable name '@SettingCollectionKey' has already been declared. Variable names must be unique within a query batch or stored procedure.
A workaround is using the non-typed UpdateAsync overload
Workaround
await db.UpdateAsync(
"SettingCollectionValue",
new
{
dbo.Label,
dbo.Value,
},
new[]
{
new QueryField("SettingCollectionKey", dbo.SettingCollectionKey),
new QueryField("Key", dbo.Key),
}
);
I am using package
FluentMigrator.Runner.SqlServerversion3.2.7The following code:
`dbo` Model
Fails with error
Microsoft.Data.SqlClient.SqlException (0x80131904): The variable name '@SettingCollectionKey' has already been declared. Variable names must be unique within a query batch or stored procedure.A workaround is using the non-typed
UpdateAsyncoverloadWorkaround
Possibly related: #485