如何使用C＃中的API从数据库中删除行 [英] How to delete a row from database using API in C#

问题描述

public class wishlistController : ApiController
   {
       DataContext rdb;
       public wishlistController()
       {
           rdb = new DataContext();
           rdb.Configuration.ProxyCreationEnabled = false;
       }
       ~wishlistController()
       {
           rdb.Dispose();
       }


       public List<wishlist> Delete(int wishid = 0)
       {

           List<wishlist> deletwish = new List<wishlist>();
           deletwish =rdb.wishlists.Where(x => x.WishID == wishid).ToList();
           rdb.wishlists.DeleteOnSubmit(deletwish);// i am facing problem here.
           return deletwish;
       }

   }

推荐答案

I have done it.

<pre lang="c#">
public class wishlistController : ApiController
    {
        DataContext rdb;
        public wishlistController()
        {
            rdb = new DataContext();
            rdb.Configuration.ProxyCreationEnabled = false;
        }
        ~wishlistController()
        {
            rdb.Dispose();
        }


        public List<wishlist> Delete(int wishid = 0)
        {

            //List<wishlist> deletwish = new List<wishlist>();
           var deletwish =rdb.wishlists.Single(x => x.WishID == wishid);
           rdb.wishlists.Remove(deletwish);
           rdb.SaveChanges();
           return rdb.wishlists.ToList();
        }

    }
</pre>

这篇关于如何使用C＃中的API从数据库中删除行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！