DevForce Community Forum : Query Dynamic http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : Community Forum : Query Dynamic Sat, 11 Apr 2026 07:58:13 -700 Thu, 21 Jun 2012 17:08:29 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=3505 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Query Dynamic : I'm not following what... http://www.ideablade.com/forum/forum_posts.asp?TID=3505&PID=13889#13889 Author: mgood
Subject: 3505
Posted: 21-Jun-2012 at 5:08pm

I'm not following what you are saying. Joining tables without a common key is not a reason to create queries on the fly. As long as two entities have one or more type compatible properties you can join them statically using the join operator.
LINQ is by definition a strongly typed and static language integrated query language. That means you need to know at design time what your query is going to be and what the types are that you are querying. If you don't know that, then you are in the realm of needing to dynamically build queries at runtime. ESQL and LINQ are two different things.
 
.NET doesn't provide dyanamic LINQ out of the box, so DevForce adds this functionality. I'm not sure what you mean by forbidden to use this. Forbidden to use what?
]]> Thu, 21 Jun 2012 17:08:29 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3505&PID=13889#13889 Query Dynamic : The only reason to create queries... http://www.ideablade.com/forum/forum_posts.asp?TID=3505&PID=13888#13888 Author: giotis
Subject: 3505
Posted: 21-Jun-2012 at 4:50pm

The only reason to create queries on the fly  is only when you need to join tables without a common key or something else.
The creation of dynamic queries by the DefForce technique is quite difficult since I read and probably I will come
to the ESQL technique only when necessary.

I want to use it only for viewing. Is there any specific reason that we are forbidden to use this ?

there is any sample  - example ?

Edited by giotis - 21-Jun-2012 at 4:51pm]]> Thu, 21 Jun 2012 16:50:12 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3505&PID=13888#13888 Query Dynamic : That would be using the dynamic... http://www.ideablade.com/forum/forum_posts.asp?TID=3505&PID=13887#13887 Author: mgood
Subject: 3505
Posted: 21-Jun-2012 at 3:44pm

That would be using the dynamic LINQ feature in DevForce. It's not quite as simple as turning a string into a query, but it's fully dynamic and lets you dynamically compose a query at runtime.
 
http://drc.ideablade.com/xwiki/bin/view/Documentation/dynamic-queries
]]> Thu, 21 Jun 2012 15:44:49 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3505&PID=13887#13887 Query Dynamic : what is the best method to implement... http://www.ideablade.com/forum/forum_posts.asp?TID=3505&PID=13886#13886 Author: giotis
Subject: 3505
Posted: 21-Jun-2012 at 2:45pm

what is the best method to implement a LINQ query in runtime, without limiting functionality of Cocktail.

 Something like this :

string str= "EntityManager.StaffingResources
                             .Where(r => r.Id == (Guid) keyValues[0])
                             .Include(r => r.Addresses)
                             .Include(r => r.PhoneNumbers)"

IEntityQuery  query = FromStringToEntityQuery(TempHireEntities, str);

Is this possible ?


]]> Thu, 21 Jun 2012 14:45:17 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3505&PID=13886#13886