linq extentions (delete multiple rows, dynamic linq queries)
Posted: Mon 27 Oct 2008 11:03
Hi,
Linq is great, but it also introduces a few problems. It would be great to have a set of extentions to the default devart classes.
Example 1: When we want to delete multiple rows, we first have to have retreive the objects from the database, so that we can delete them. This is unneccesary I/O.
Sollution: http://forums.microsoft.com/MSDN/ShowPo ... 4&SiteID=1
Example 2: Building dynamic LINQ queries: When we want to use multiple AND / OR operators in a linq query, based on a stringcollection as an input, you can use the predicatebuilder.
Sollution: http://www.albahari.com/nutshell/predicatebuilder.aspx
Linq is great, but it also introduces a few problems. It would be great to have a set of extentions to the default devart classes.
Example 1: When we want to delete multiple rows, we first have to have retreive the objects from the database, so that we can delete them. This is unneccesary I/O.
Sollution: http://forums.microsoft.com/MSDN/ShowPo ... 4&SiteID=1
Example 2: Building dynamic LINQ queries: When we want to use multiple AND / OR operators in a linq query, based on a stringcollection as an input, you can use the predicatebuilder.
Sollution: http://www.albahari.com/nutshell/predicatebuilder.aspx