linq extentions (delete multiple rows, dynamic linq queries)

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
yuri@wallie.com
Posts: 27
Joined: Mon 08 Sep 2008 16:37

linq extentions (delete multiple rows, dynamic linq queries)

Post by yuri@wallie.com » 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

Shalex
Site Admin
Posts: 8196
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Thu 30 Oct 2008 17:07

Thank you for your feedback.

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

Shalex
Site Admin
Posts: 8196
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 31 Oct 2008 09:45

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?

yuri@wallie.com
Posts: 27
Joined: Mon 08 Sep 2008 16:37

Post by yuri@wallie.com » Fri 31 Oct 2008 11:11

Hi,

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

Post Reply