DevForce Community Forum : Batch delete in Silverlight (and DF) http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Batch delete in Silverlight (and DF) Tue, 12 May 2026 22:23:39 -700 Wed, 08 May 2013 10:37:45 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=4142 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Batch delete in Silverlight (and DF) : You said: "I want delete... http://www.ideablade.com/forum/forum_posts.asp?TID=4142&PID=16308#16308 Author: sbelini
Subject: 4142
Posted: 08-May-2013 at 10:37am

You said:

"I want delete a bulk of records in this proc."
So why not call the stored proc directly from client rather than invoke a server method and then call the stored proc?



"I didn't understand how to use EM instance for this purpose. Also, I didn't understand how to use method described in the "Stored Procedure queries" topic for deleting of records"
In the second link I provided, there is a walkthrough explaining how to use a stored proc. The principle is the same and the two differences are that your stored procedure won't return anything and that you'd execute it synchronously (if you were to run it on the server). Have you gone thru the steps? If so, what issues have you come across? Post the exceptions, if any.

Edited by sbelini - 08-May-2013 at 3:15pm]]> Wed, 08 May 2013 10:37:45 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4142&PID=16308#16308 Batch delete in Silverlight (and DF) : >>Can you explain why are... http://www.ideablade.com/forum/forum_posts.asp?TID=4142&PID=16307#16307 Author: MaksimK
Subject: 4142
Posted: 08-May-2013 at 10:29am

>>Can you explain why are you trying to call a stored proc from a RSM?

I want delete a bulk of records in this proc.

>>In theory you could call it just as in the client by creating an EM instance: var em = new MyEntityManager(EntityManager);

I didn't understand how to use EM instance for this purpose. Also, I didn't understand how to use

method described in the "Stored Procedure queries" topic for deleting of records]]> Wed, 08 May 2013 10:29:00 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4142&PID=16307#16307 Batch delete in Silverlight (and DF) : MaksimK, Can you explain why... http://www.ideablade.com/forum/forum_posts.asp?TID=4142&PID=16305#16305 Author: sbelini
Subject: 4142
Posted: 08-May-2013 at 9:27am

MaksimK,

Can you explain why are you trying to call a stored proc from a RSM?

In theory you could call it just as in the client by creating an EM instance: 
var em = new MyEntityManager(EntityManager);


]]> Wed, 08 May 2013 09:27:31 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4142&PID=16305#16305 Batch delete in Silverlight (and DF) : Howtocallstoredprocfromremoteservermethodcall... http://www.ideablade.com/forum/forum_posts.asp?TID=4142&PID=16304#16304 Author: MaksimK
Subject: 4142
Posted: 08-May-2013 at 6:32am

How to call stored proc from remote server method call ?

]]> Wed, 08 May 2013 06:32:00 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4142&PID=16304#16304 Batch delete in Silverlight (and DF) : MaksimK, EF doesn't have... http://www.ideablade.com/forum/forum_posts.asp?TID=4142&PID=16299#16299 Author: sbelini
Subject: 4142
Posted: 07-May-2013 at 10:34am

MaksimK,

EF doesn't have support for bulk updates/deletes. So, your option would be calling a stored procedure that would delete all the rows in your table. See http://drc.ideablade.com/xwiki/bin/view/Documentation/stored-procedure-queries and http://drc.ideablade.com/xwiki/bin/view/Documentation/code-sample-stored-procedure-queries-silverlight.]]> Tue, 07 May 2013 10:34:44 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4142&PID=16299#16299 Batch delete in Silverlight (and DF) : Hello!I need delete a bulk of... http://www.ideablade.com/forum/forum_posts.asp?TID=4142&PID=16298#16298 Author: MaksimK
Subject: 4142
Posted: 07-May-2013 at 8:55am

Hello!
I need delete a bulk of entities and want NOT to load them beforehand to client. Is there any possibility to execute in Silverlight arbitrary stored proc/SQL (DELETE FROM ..) ? 
]]> Tue, 07 May 2013 08:55:59 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4142&PID=16298#16298