By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,354 Members | 907 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,354 IT Pros & Developers. It's quick & easy.

implementing sql transactions in data access layers

P: n/a
Hi,

I am trying to implement sql transactions. But I am not knowing how to
do that. I created a data access layer which contains methods to
select/insert/update tables in a database. I have also created a business
logic layer to retrieve/update the data from the data access layer. All of
this is working fine if there are no transactions involved. If I need to use
transactions, I am not knowing how to do that. Lets say I have a webform from
which I want to insert 10 records into our database. I need to make sure that
either all of them gets inserted or nothing gets inserted. so to do that I
need to have sql transactions. So how should I wrap these insert statements
inside transactions? Do I need to first get the sql connection object and
create a transaction in the webform and attach that transaction to the sql
connection object. And once all the transactions are done I would commit the
transactions inside the web form. Is it right to get the sql connection from
data access layer to the webform and implement the transactions? please let
me know.

Thanks,
sridhar.
Oct 10 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Here is some documentation to get you started:
http://msdn.microsoft.com/library/de.../html/daag.asp

In the past, when I have needed transactions, I have not done them in
the data layer, but within a stored procedure, recently though I have
begun to toy with them within the data access layer, mainly with O/R
Mappers.

Transactions is a large topic, so reading the above link will give you
the low down.

hope it helps!

Sean

Sridhar wrote:
Hi,

I am trying to implement sql transactions. But I am not knowing how to
do that. I created a data access layer which contains methods to
select/insert/update tables in a database. I have also created a business
logic layer to retrieve/update the data from the data access layer. All of
this is working fine if there are no transactions involved. If I need to use
transactions, I am not knowing how to do that. Lets say I have a webform from
which I want to insert 10 records into our database. I need to make sure that
either all of them gets inserted or nothing gets inserted. so to do that I
need to have sql transactions. So how should I wrap these insert statements
inside transactions? Do I need to first get the sql connection object and
create a transaction in the webform and attach that transaction to the sql
connection object. And once all the transactions are done I would commit the
transactions inside the web form. Is it right to get the sql connection from
data access layer to the webform and implement the transactions? please let
me know.

Thanks,
sridhar.
Oct 11 '06 #2

P: n/a
Thank you.

"Sean Chambers" wrote:
Here is some documentation to get you started:
http://msdn.microsoft.com/library/de.../html/daag.asp

In the past, when I have needed transactions, I have not done them in
the data layer, but within a stored procedure, recently though I have
begun to toy with them within the data access layer, mainly with O/R
Mappers.

Transactions is a large topic, so reading the above link will give you
the low down.

hope it helps!

Sean

Sridhar wrote:
Hi,

I am trying to implement sql transactions. But I am not knowing how to
do that. I created a data access layer which contains methods to
select/insert/update tables in a database. I have also created a business
logic layer to retrieve/update the data from the data access layer. All of
this is working fine if there are no transactions involved. If I need to use
transactions, I am not knowing how to do that. Lets say I have a webform from
which I want to insert 10 records into our database. I need to make sure that
either all of them gets inserted or nothing gets inserted. so to do that I
need to have sql transactions. So how should I wrap these insert statements
inside transactions? Do I need to first get the sql connection object and
create a transaction in the webform and attach that transaction to the sql
connection object. And once all the transactions are done I would commit the
transactions inside the web form. Is it right to get the sql connection from
data access layer to the webform and implement the transactions? please let
me know.

Thanks,
sridhar.

Oct 11 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.