public void Delete(int id)
{
using (var context = new IceCreamDataContext())
{
context.ExecuteCommand("delete from IceCream where Id = {0}", id);
}
}
public void Update(IceCream ice)
{
using (var context = new IceCreamDataContext())
{
context.ExecuteCommand("update IceCream set Flavor = {0},Lowfat = {1} where Id = {2}", ice.Flavor, ice.LowFat, ice.Id);
}
}
public IEnumerable <IceCream> GetOrders()
{
using (var context = new IceCreamDataContext())
{
return(context.IceCreams.ToList());
}
}
public void Add(IceCream ice)
{
using (var context = new IceCreamDataContext())
{
context.IceCreams.InsertOnSubmit(ice);
context.SubmitChanges();
}
}
