Home
Help
Register
Log in

Search

 
   Active Threads  

You are here: Home > LLBLGen Pro > Generated code> Using the adapter to fire some SQL... is it possible?
 

Pages: 1
Generated code
Using the adapter to fire some SQL... is it possible?
Page:1/1 

  Print all messages in this thread  
Poster Message
MattWoberts
User



Location:
Lancaster, UK
Joined on:
08-Apr-2004 10:24:31
Posted:
497 posts
# Posted on: 30-Apr-2007 14:54:10.  
Hi,

I have some LLBLGen code inserts some rows into a new table. This table currently contains a trigger that is getting in the way for me, so I want to temporarily disable the trigger, do the update, then re-enable the trigger. So, I need to fire this SQL against the database:

ALTER TABLE tablename DISABLE TRIGGER ALL

Can I do this within the adapter object somehow? I'm sure I remember Frans saying ages ago this is possible....

BTW I'm on the latest 2.0 code!

Thanks!

Matt
Matt  Top
Aurelien
Support Team



Location:
France
Joined on:
28-Jun-2006 16:32:08
Posted:
162 posts
# Posted on: 30-Apr-2007 15:26:09.  
Hi,

Maybe you can have a look to DataAccessAdapterBase.ExecuteActionQuery method.


Aricie  Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
34815 posts
# Posted on: 01-May-2007 11:07:08.  
Indeed, you could use that method. First open the connection manually on the adapter, then execute your query, set KeepConnectionOpen to true, run your updates, and then close the connection manually again.
Frans Bouma
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
Pages: 1  


Powered by HnD ©2002-2007 Solutions Design
HnD uses LLBLGen Pro

Version: 2.1.12172008 Final.