Shulou(Shulou.com)06/02 Report--

This article mainly introduces "what is the method of deleting records by LINQ". In daily operation, I believe that many people have doubts about the method of deleting records by LINQ. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubts of "what is the method of deleting records by LINQ?" Next, please follow the editor to study!

The occurrence of the LINQ delete record problem:

Public void DeleteAlbum (int albumid) {var albumlog = (from p in xt.AlbumInfo where p.Album_id = = albumid select p). Single (); var picslog = from q in xt.PictureInfo where q.AlbumInfo.Album_id = = albumid select q; foreach (PictureInfo log in picslog) {xt.PictureInfo.DeleteOnSubmit (log);} xt.AlbumInfo.DeleteOnSubmit (albumlog); xt.SubmitChanges ();}

My goal was to delete the album with ID albumid and all the photos in it, but there was a "loop detected in the change set" error.

Solution to the problem of LINQ deleting records:

You can use Linq's DeleteAllOnSubmit statement without the need for a loop. Replace the foreach statement with xt.PictureInfo.DeleteAllOnSubmit (picslog)

Another: * statement should use .SingleOrDefault () query and to determine whether there is a query result picslog can use var picslog = xt.PictureInfo.where (q.AlbumInfo = = albumlog)

Also, why use anonymous types if we already know the type of variable? It's a bit of a waste to let the compiler do the work again.

At this point, the study on "what is the method of deleting records by LINQ" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.