Re: Simple transaction question ????

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" wrote:

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" wrote:

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" <calderara@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FE9D66E5-7E56-48C0-9A00-F56C6489B628@xxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • Re: Problems with querying date field
    ... >> If you want to put a database somewhere for safekeeping, ... database - SQL isn't about persistence, ... says nothing about the physical storage media to be used. ... store data on a tape, or a disk, or a CD, or a file, or any physical ...
    (microsoft.public.sqlserver.programming)
  • Re: Exchange 2003 Transaction Logs Growing Too Quickly
    ... The version store is used by Extensible Storage Engine to track and to ... changes that are made to the database. ... Therefore, if a transaction is open for a long time, the transaction ... prevents version store cleanup. ...
    (microsoft.public.exchange.admin)
  • Re: Storing docs in database vs storing in file system
    ... > the file system and simply keeping a pointer to each file in the database. ... I personally found the storage in sql method ... the files when they were stored in the directory structure. ... directory structure to store all the files. ...
    (microsoft.public.sqlserver.programming)
  • Re: How do you store .JPG in ACCESS using VB.NET
    ... I thought if I could find a solution hear in VBA land I could convert to .NET ... > You've mistakenly posted your question in the Microsoft Access (the database ... Jet SQL or any SQL dialect of the database server the front end is ... >>I have written a program to store images. ...
    (microsoft.public.access.modulesdaovba)
  • Re: C#, ADO.NET and MS-SQL
    ... a transaction should surround a set of operations on a database ... Allow the user to create a supplier on the client without checking ... > Store, Item, Qty, UnitPrice ...
    (microsoft.public.dotnet.languages.csharp)