开发者

oledbtransaction & oledbconnection lifetime

开发者 https://www.devze.com 2023-04-11 01:23 出处:网络
i\'m doing an application in asp.net using a class stack of my authorship to abstract some complexity of the database and the interaction in it is done using 1 connection among all the classes; consta

i'm doing an application in asp.net using a class stack of my authorship to abstract some complexity of the database and the interaction in it is done using 1 connection among all the classes; constantly opening /closing connection and executing oledbcommands on readers, datasets, etc.

and i need to implement a transaction to en开发者_如何学编程capsulte a big chunck of queries

my concrete question is:

my transaction will be lost when my first open/close finish or will persistt among all the page until dispose event is reached?

Note= i'm not setting null/nothing on connection only closing and oppening when i needed


Your transaction will be rolled back when you close the connection.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号