DevForce Community Forum : Complete "Select" Dynamic Query

DevForce Community Forum : Complete "Select" Dynamic Query http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Complete "Select" Dynamic Query Wed, 13 May 2026 09:56:41 -700 Thu, 09 Feb 2012 14:59:29 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=3252 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Complete "Select" Dynamic Query : Hello silvio, Maybe you are right... http://www.ideablade.com/forum/forum_posts.asp?TID=3252&PID=12640#12640 Author: k_cire0426
Subject: 3252
Posted: 09-Feb-2012 at 2:59pm

Hello silvio,

Maybe you are right that it was a requirement to have a primary key...

thanks again..

]]> Thu, 09 Feb 2012 14:59:29 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3252&PID=12640#12640 Complete "Select" Dynamic Query : Hi k_cire0426,Regarding... http://www.ideablade.com/forum/forum_posts.asp?TID=3252&PID=12636#12636 Author: sbelini
Subject: 3252
Posted: 09-Feb-2012 at 10:51am

Hi k_cire0426,

Regarding your comments:

1. Yes, I needed to have a primary key field as well. This might be a DevExpress requirement/issue, since it's set on their EntityInstantFeedbackSource.

2. I didn't need to fill in the 'alias' optional parameter in our ProjectionSelector. (as in the snippet)

I'm attaching the test solution I tested with: uploads/892/T11495.zip

Regards,

Silvio.

]]> Thu, 09 Feb 2012 10:51:13 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3252&PID=12636#12636 Complete "Select" Dynamic Query : hello sbelini, Just an update... http://www.ideablade.com/forum/forum_posts.asp?TID=3252&PID=12634#12634 Author: k_cire0426
Subject: 3252
Posted: 08-Feb-2012 at 9:11pm

hello sbelini,

Just an update here. I managed to make it work but have some catch.

1. The selector should have at least 1 primary/unique key field.

2. I have to fill in the "alias" optional parameter of ProjectionSelector.

I'm not sure if this bug or not and if it is a bug, is it on your side or DevExpress?

thanks..

]]> Wed, 08 Feb 2012 21:11:56 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3252&PID=12634#12634 Complete "Select" Dynamic Query : Hi sbelini, Thank you for taking... http://www.ideablade.com/forum/forum_posts.asp?TID=3252&PID=12633#12633 Author: k_cire0426
Subject: 3252
Posted: 08-Feb-2012 at 7:50pm

Hi sbelini,

Thank you for taking time looking into this. However, we exactly do the same but the data doesn't display. Can you confirm that the data is coming out on your grid?

The weird part is when I didn't use the EntityInstantFeedbackSource and call the Execute method, I can see the data.

thanks..

]]> Wed, 08 Feb 2012 19:50:33 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3252&PID=12633#12633 Complete "Select" Dynamic Query : Hi k_cire0426,You will need... http://www.ideablade.com/forum/forum_posts.asp?TID=3252&PID=12632#12632 Author: sbelini
Subject: 3252
Posted: 08-Feb-2012 at 6:26pm

Hi k_cire0426,

You will need to cast your ITypedEntityQuery into an IQueryable:

EntityInstantFeedbackSource efInstantFeedbackSource1 = new EntityInstantFeedbackSource();

efInstantFeedbackSource1.KeyExpression = "LastName";

efInstantFeedbackSource1.GetQueryable += efInstantFeedbackSource1_GetQueryable;

gridControl1.ItemsSource = efInstantFeedbackSource1;

void efInstantFeedbackSource1_GetQueryable(object sender, GetQueryableEventArgs e) {

NorthwindIBEntities mgr = new NorthwindIBEntities();

IProjectionSelector selector = new ProjectionSelector("LastName");

selector = selector.Combine("FirstName");

var rootQuery = EntityQuery.Create(typeof(Employee), mgr);

var query = rootQuery.Select(selector);

e.QueryableSource = (IQueryable)query;

}

Regards,

Silvio.

Edited by sbelini - 08-Feb-2012 at 6:53pm]]> Wed, 08 Feb 2012 18:26:55 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3252&PID=12632#12632 Complete "Select" Dynamic Query : hello, Is it really needed to... http://www.ideablade.com/forum/forum_posts.asp?TID=3252&PID=12629#12629 Author: k_cire0426
Subject: 3252
Posted: 07-Feb-2012 at 9:59pm

hello,

Is it really needed to call the Execute method when creating select dynamic query? I like to use the feature on EntityInstantFeedbackSource of DevExpress but I failed to do so. Is there a way to do that?

thanks...

]]> Tue, 07 Feb 2012 21:59:54 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3252&PID=12629#12629