/// <summary>
/// Deletes the item with the id.
/// </summary>
/// <param name="itemId">The item id.</param>
internal void DeleteItem(Guid itemId)
{
string sqlCommand = $"DELETE FROM [ItemData] WHERE [ItemId] = '{itemId}'";
using (var dataContext = new ItemData2DataContext(_connectionString))
{
dataContext.ExecuteCommand(sqlCommand);
}
// LINQ round-trip DELETE queries are too slow
//var query = _DataContext.ItemDatas.Where(item => (item.ItemId == itemId));
//_DataContext.ItemDatas.DeleteAllOnSubmit(query);
//_DataContext.SubmitChanges();
}
