/// <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(); }