linq extentions (delete multiple rows, dynamic linq queries)

linq extentions (delete multiple rows, dynamic linq queries)

Postby 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/ShowPost.aspx?PostID=2929114&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
yuri@wallie.com
 
Posts: 27
Joined: Mon 08 Sep 2008 16:37

Postby 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
Devart Team
 
Posts: 7293
Joined: Thu 14 Aug 2008 12:44

Postby Shalex » Fri 31 Oct 2008 09:45

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2929114&SiteID=1

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.
http://www.albahari.com/nutshell/predicatebuilder.aspx

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?
Shalex
Devart Team
 
Posts: 7293
Joined: Thu 14 Aug 2008 12:44

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

Hi,

I'm not requesting, i'm just sharing thoughts.
yuri@wallie.com
 
Posts: 27
Joined: Mon 08 Sep 2008 16:37


Return to dotConnect for MySQL