Page 1 of 1

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

Posted: Thu 30 Oct 2008 17:07
by Shalex
Thank you for your feedback.

We will consider the possibility of making these improvements in the future.

Posted: Fri 31 Oct 2008 09:45
by Shalex
We don't support the usage of SQL as a text. In this case, it is necessary to use the ADO.NET provider directly. In addition, it is impossible to change a state of remote objects correctly having such implementation.
It works, because the query is created by the LINQ code from Microsoft, and our provider is used at the moment of executing. The message can be shown, that some method is not implemented. These situations are individual. What is your request?

Posted: Fri 31 Oct 2008 11:11
Hi,

I'm not requesting, i'm just sharing thoughts.