利用Linq记录数据库操作

 GuestBookDataContext ctx = newGuestBookDataContext("server=xxx;database=GuestBook;uid=xxx;pwd=xxx"); 

 StreamWriter sw = new StreamWriter(Server.MapPath("log.txt"), true);

            ctx.Log = sw;

            tbGuestBook gb = ctx.tbGuestBooks.Single(b => b.ID == newGuid(e.CommandArgument.ToString()));

            ctx.tbGuestBooks.Remove(gb);

            ctx.SubmitChanges();

            SetBind();

            sw.Close();

posted @ 2012-05-28 12:52  海底的鱼  阅读(128)  评论(0)    收藏  举报