Lloyd.NET

Programing experiments

Bulk SQL Update and Delete with LINQ to EF

The more I use EF to SQL the more I like it and get rid of stored procedures. It really ease maintenance and development!

There is one major area where EF is lacking though, and stored proc still absolutely required, and it is bulk update and delete. Wouldn’t it be nice to be able to do that with just some strongly typed nice C# code?

Come to think about it, it might be possible… and Google helping I found a blog which provided an implementation for just that!

Yoohoo!
Just to be safe I downloaded his C# source code file and provide it here as well (untested and unread yet… will do that tomorrow at work…)


Tags: ,
Categories: .NET | Database
Permalink | Comments (0) | Post RSSRSS comment feed