I think I may have a bug in the data provider code. You may have already noticed and fixed it, but here it is.
public override void AddItemTag(int itemVersionId, int tagId)
{
StringBuilder sql = new StringBuilder(128);
sql.Append("insert into ");
sql.Append(NamePrefix);
sql.Append("itemversiontags {ItemVersionId, TagId} Values{");
sql.Append(itemVersionId);
sql.Append(", ");
sql.Append(tagId);
sql.Append("}");
SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.Text, sql.ToString());
}
This method is throwing an SQL syntax error because of the {'s. The method below this uses transactions and it works fine, I assume it's because of the parentheses instead of brackets.
Please let me know if this will be included in an upcoming release, I'm going to go ahead and change the code for now.
Thanks, Jacob