You will not be able to do this by getting the SQL from an EntityQuery.

The choice is to use a stored procedure, but like you mentioned "there is the potential for there to be far to many" (guids). What I can think of is that if the list of guids grow too big, split it and make multiple stored procedure calls.

Unfortunately, I can't think of any other option to deal with this sort of bulk operation. 

I am still waiting on your response on this issue

thanks

Murray

Thanks for the suggestion, however performance wise doing tens of thousands of inserts into a table through devforce would be terrible.

The only way to do the insert would be to bypass devforce completely. Which I am trying not to do. 

The user can filter what data they want processed ( Ie which locations they want the data processed for). I determine the locations that they are interested on the client by building a IPredicateDescription and then doing a typed entity query. This will give me a list of the locations on the client.

My problem is passing the list of locations ( id guids) back to the server so that the stored procedure can run and make the results for those locations. 

The most elegant method I can come up with is to extract the SQL from the entity query,  pass that string to the server stored procedure and get the results back.

I have considered the following

- I can't pass a list of Guids to the server because there is the potential for there to be far to many.

- I can't do one at a time because the time cost of calling the stored procedure through devforce is too great

- If i could pass a table of results to the stored procedure this might work, though I am not sure it is supported and it would not have as good a performance as just passing the sql

Does this make sense?

thanks for your help

murray.bryant,

This would need the use of Table values in Stored Procedures.

I know you can do this in EntityFramework ( see http://stackoverflow.com/questions/8157345/entity-framework-stored-procedure-table-value-parameter )

Would something like this work in DevForce?

I would worry about performance with this method still though.

did anything happen with this?

At some point devforce does convert its queries into SQL statements. Is it in anyway possible to capture those statements?

I have the need to extract the sql from a  query into a string. I basically need to pass this  dynamic where statement into a stored procedure to return data ( for performance reasons)

  var p1 = FilterViewModel.FilterPredicate;
                ITypedEntityQuery query = EntityQuery.Create(entityType);

                if (p1 != null)
                {
                    query = query.Where(p1);
                }
             

in Entity Framework you can use the getcommand to return the sql statement as per http://msdn.microsoft.com/en-us/library/system.data.linq.datacontext.getcommand.aspx

Is there a way to do this with Ideablade?

thanks

Murray