467,894 Members | 1,762 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,894 developers. It's quick & easy.

implementing sql transactions in data access layers

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
  • viewed: 2402
Share:
2 Replies
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
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.

Similar topics

reply views Thread by Stephen Haeney via .NET 247 | last post: by
reply views Thread by D Lester | last post: by
3 posts views Thread by kbutterly | last post: by
7 posts views Thread by =?Utf-8?B?U2F2dm91bGlkaXMgSW9yZGFuaXM=?= | last post: by
4 posts views Thread by xenoix | last post: by
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.