Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsEventsEventsEventController / EventRecurMasterController and SQL TransactionEventController / EventRecurMasterController and SQL Transaction
Previous
 
Next
New Post
2/18/2014 8:53 AM
 

Of coarse, the Event table manipulations are done by the Events Code (EventController / EventRecurMasterController) because I thik this is the "official" Events Interface.

My question is how to access the ADO.NET transaction object of this database manipulations.

Regards,

Bernd

 
New Post
2/18/2014 11:32 AM
 
I do not think that that is possible. The database manipulation in the Events module is done using the standard module structure of DNN: form - code behind form - controller - DataPrivider (for SQL) - Stored Procedure. The first 4 are in .NET, the last is SQL SProc. So I do no think there is an option to interfere with this structure.
It might be that if you create a transaction around your whole data manipulation (which includes Events data), that the transaction will cover the data manipulation of Events as well.

XCESS expertise center b.v.
Regards,
Ernst Peter
LinkedIn Profile Ernst Peter Tamminga


XCESS: DNN/Evoq specialist, zie www.xcess.nl

Events 7.0.1 - Released
Reports 6.1.0 - Released
 
New Post
2/18/2014 6:25 PM
 
As a rule - Transactions in asp.net can be scoped no higher than the database connection level. Since in your case the connection you hold to the database is different to the connection being used by the event controller - it may not be viable to do what you want to achieve.

I would suggest in this case - and yes it breaks all the normal api rules - that to do what you want - you may need to bypass the event controller and directly access the event stored procedures.

Westa
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsEventsEventsEventController / EventRecurMasterController and SQL TransactionEventController / EventRecurMasterController and SQL Transaction


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out