DevForce Community Forum : Help PassthruEsqlQuery http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Help PassthruEsqlQuery Wed, 10 Jun 2026 20:47:39 -700 Fri, 17 Sep 2010 13:19:13 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2163 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Help PassthruEsqlQuery : Another approach is to invoke... http://www.ideablade.com/forum/forum_posts.asp?TID=2163&PID=8552#8552 Author: DenisK
Subject: 2163
Posted: 17-Sep-2010 at 1:19pm

Another approach is to invoke a server method using the DF InvokeServerMethod. Inside that server method, you will need to create an ADO.NET connection using the connection string from the config file as well as creating the command objects and execute the DELETE SQL statement.]]> Fri, 17 Sep 2010 13:19:13 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2163&PID=8552#8552 Help PassthruEsqlQuery : This approach is generally not... http://www.ideablade.com/forum/forum_posts.asp?TID=2163&PID=8551#8551 Author: DenisK
Subject: 2163
Posted: 17-Sep-2010 at 12:37pm

This approach is generally not recommended and you have to write a work around function that involves writing a wrapper around a Transact-SQL statement. ExecuteCommand is a .NET namespace. Please see below for more info.

http://msdn.microsoft.com/en-us/library/system.data.linq.datacontext.executecommand.aspx
]]> Fri, 17 Sep 2010 12:37:19 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2163&PID=8551#8551 Help PassthruEsqlQuery : I have no idea, because EntityManager... http://www.ideablade.com/forum/forum_posts.asp?TID=2163&PID=8549#8549 Author: Molinari
Subject: 2163
Posted: 17-Sep-2010 at 12:15pm

I have no idea, because EntityManager does not has ExecuteCommand or something like method in DevForce2010.

And using PassthruEsqlQuery I am not getting sucess;

thanks...]]> Fri, 17 Sep 2010 12:15:18 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2163&PID=8549#8549 Help PassthruEsqlQuery : I think this post can help you... http://www.ideablade.com/forum/forum_posts.asp?TID=2163&PID=8548#8548 Author: DenisK
Subject: 2163
Posted: 17-Sep-2010 at 11:46am

I think this post can help you get some idea on how you can do that.

http://omaralzabir.com/linq_to_sql__delete_an_entity_using_primary_key_only/
]]> Fri, 17 Sep 2010 11:46:17 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2163&PID=8548#8548 Help PassthruEsqlQuery : I do not want to search all the... http://www.ideablade.com/forum/forum_posts.asp?TID=2163&PID=8547#8547 Author: Molinari
Subject: 2163
Posted: 17-Sep-2010 at 11:19am


I do not want to search all the data
so i can delete, I want delete without search.

using your suggestion, I can do this?

Thanks Denisk....

]]> Fri, 17 Sep 2010 11:19:52 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2163&PID=8547#8547 Help PassthruEsqlQuery : My suggestion is to use our EntityManager.RemoveEntity... http://www.ideablade.com/forum/forum_posts.asp?TID=2163&PID=8545#8545 Author: DenisK
Subject: 2163
Posted: 17-Sep-2010 at 10:21am

My suggestion is to use our EntityManager.RemoveEntity and .RemoveEntities.]]> Fri, 17 Sep 2010 10:21:33 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2163&PID=8545#8545 Help PassthruEsqlQuery : Hi Denisk... You have some idea. to... http://www.ideablade.com/forum/forum_posts.asp?TID=2163&PID=8543#8543 Author: Molinari
Subject: 2163
Posted: 17-Sep-2010 at 9:55am

Hi Denisk...

You have some idea.
to resolve this?

thanks... ]]> Fri, 17 Sep 2010 09:55:43 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2163&PID=8543#8543 Help PassthruEsqlQuery : OK... Denisk Thanks... http://www.ideablade.com/forum/forum_posts.asp?TID=2163&PID=8541#8541 Author: Molinari
Subject: 2163
Posted: 17-Sep-2010 at 5:12am

OK... Denisk

Thanks...]]> Fri, 17 Sep 2010 05:12:43 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2163&PID=8541#8541 Help PassthruEsqlQuery : Hi Molinari;Entity SQL provides... http://www.ideablade.com/forum/forum_posts.asp?TID=2163&PID=8540#8540 Author: DenisK
Subject: 2163
Posted: 16-Sep-2010 at 7:45pm

Hi Molinari;

Entity SQL provides no support for DELETE statement at this time. Please see Microsoft's website below to find out how Entity SQL differs from Transact-SQL.

http://msdn.microsoft.com/en-us/library/bb738573.aspx
]]> Thu, 16 Sep 2010 19:45:57 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2163&PID=8540#8540 Help PassthruEsqlQuery : Hey I wonder if it's possible... http://www.ideablade.com/forum/forum_posts.asp?TID=2163&PID=8527#8527 Author: Molinari
Subject: 2163
Posted: 16-Sep-2010 at 8:01am

Hey

I wonder if it's possible to perform a DELETE this way


PassthruEsqlQuery query = new PassthruEsqlQuery(typeof(PESSOA_TIPO_USUARIO_P_RIGHT),
               "DELETE FROM PESSOA_TIPO_USUARIO_P_RIGHT WHERE FK_PESSOA_TIPO_USUARIO_PERFIL = 1);

query.ExecuteAsync(op =>
{
   if (!op.HasError)
       return;
   else
      MessageBox.Show(op.Error.Message);
});

Thanks]]> Thu, 16 Sep 2010 08:01:37 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2163&PID=8527#8527