public async Task <int> InsertSingleTagAsync(Tag tag)
{
int sum = 0;
TagDataVerification.VerifyTagParameteres(tag);
using (var connection = new SqlConnection(_connectionString))
{
await connection.OpenAsync();
using (var transaction = await connection.BeginTransactionAsync())
{
sum += await connection.ExecuteAsync(@"
INSERT INTO [dbo].[Tags]
([TagId]
,[Name]
,[ImageKey])
VALUES
(@TagId,
@Name,
@ImageKey)",
new
{
tag.TagId,
tag.Name,
tag.ImageKey
}, transaction : transaction);
transaction.Commit();
}
}
return(sum);
}
public async Task <int> InsertTagsAsync(IEnumerable <Tag> tags, DbTransaction transaction, SqlConnection connection)
{
if (tags is null)
{
return(0);
}
int sum = 0;
foreach (var item in tags)
{
TagDataVerification.VerifyTagParameteres(item);
sum += await connection.ExecuteAsync(@"
INSERT INTO [dbo].[Tags]
([TagId]
,[Name]
,[ImageKey])
VALUES
(@TagId,
@Name,
@ImageKey)",
new
{
item.TagId,
item.Name,
item.ImageKey
}, transaction : transaction);
}
return(sum);
}
