/// <summary> /// Inserts the item. /// </summary> /// <param name="newItem">The new item.</param> internal void InsertItem(CommonItem newItem) { using (var dataContext = new ItemData2DataContext(_connectionString)) { dataContext.ItemDatas.InsertOnSubmit(new ItemData(newItem)); dataContext.SubmitChanges(); } }
///// <summary> ///// Initializes a new instance of the <see cref="ItemData"/> class. ///// </summary> ///// <param name="dataContext">The data context.</param> //internal ItemData2Table(ItemDataDataContext dataContext) // { //} ///// <summary> ///// Finds an item with an id. ///// </summary> ///// <param name="itemId">The item id.</param> ///// <returns></returns> //internal ItemData SelectItem(Guid itemId) //{ // var query = _DataContext.ItemDatas.Where(item => (item.ItemId == itemId)); // List<ItemData> list = query.ToList(); // if (list.Count > 0) // return list[0]; // else // return null; //} /// <summary> /// Selects all items. /// </summary> /// <returns></returns> internal List <ItemData> SelectAllItems() { using (var dataContext = new ItemData2DataContext(_connectionString)) { var query = dataContext.ItemDatas.Where(item => (true)); return(query.ToList()); } }
/// <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(); }