Simple transaction question ????

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear all,

I am building a multi tiers application.
I have a remote object hosted by a Windows Service which is charge to store
certain data in an SQL databse. Works great.

After this operation I need to dispatch store data to some other tables. for
that opertaion I need database transaction.
The doubt that I have is , do I have to manage my transaction directly using
DAO or should I go for a serviced Component using automatique transaction ??

Any comments will be appreciate..
PS my databas is not a huge database like you might have for a bank or
market database but still have to manage transactionnal stuff

Regards
serge
 
Are you using .net (ado.net)?
BTW, if you have to manage transaction that spawns a single database then
DAO (or whatever database provider technology) is just fine and you should
avoid serviced component transactions.
 
Also, if your transaction is to a single SQL database, can't you implement
the transaction in the database rather than the component?
--
Jim Anderson, MCSD
Consultant
Columbus, Ohio


Miha Markic said:
Are you using .net (ado.net)?
BTW, if you have to manage transaction that spawns a single database then
DAO (or whatever database provider technology) is just fine and you should
avoid serviced component transactions.

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/


calderara said:
Dear all,

I am building a multi tiers application.
I have a remote object hosted by a Windows Service which is charge to
store
certain data in an SQL databse. Works great.

After this operation I need to dispatch store data to some other tables.
for
that opertaion I need database transaction.
The doubt that I have is , do I have to manage my transaction directly
using
DAO or should I go for a serviced Component using automatique transaction
??

Any comments will be appreciate..
PS my databas is not a huge database like you might have for a bank or
market database but still have to manage transactionnal stuff

Regards
serge
Click to expand...
Click to expand...
 
This is what I was thinking to do first..managinthis dispatch data directly
in SQL data base through store procedure or function but then sounds more
compleicated for me first becasue I:

1- I am not used to the SQL syntax in SQL server side, faster for me to get
something ready using dataset under ado.net

2- Before storing those data in other database table, I need to validate
some buisness rules, and once those rules gets validdated then process for
the storage.

3- before reaching the finla data storage I need to collect information from
another database, som sounds more complicated...hmm

What do you thing ?
Am I on the wrong way? I mean does it arms if I go first frm the Buisness
Logic layer ( myBuisnessLogic.dll ) , then the datalayer ( SQL syntax querry )

thnaks for your comemnts
regrds
serge

Jim Anderson said:
Also, if your transaction is to a single SQL database, can't you implement
the transaction in the database rather than the component?
--
Jim Anderson, MCSD
Consultant
Columbus, Ohio


Miha Markic said:
Are you using .net (ado.net)?
BTW, if you have to manage transaction that spawns a single database then
DAO (or whatever database provider technology) is just fine and you should
avoid serviced component transactions.

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/


calderara said:
Dear all,

I am building a multi tiers application.
I have a remote object hosted by a Windows Service which is charge to
store
certain data in an SQL databse. Works great.

After this operation I need to dispatch store data to some other tables.
for
that opertaion I need database transaction.
The doubt that I have is , do I have to manage my transaction directly
using
DAO or should I go for a serviced Component using automatique transaction
??

Any comments will be appreciate..
PS my databas is not a huge database like you might have for a bank or
market database but still have to manage transactionnal stuff

Regards
serge
Click to expand...
Click to expand...
Click to expand...
 
Back
Top