Hi programmer's,

Using Transactions in Windows application is more effective or using transaction in Web Application is More effective ?

Thanks in Advance

The question is not clear.

are you talking about database transactions? Please make it clear

Regards
Ganesh
http://ganeshprof.blogspot.com
Find your solution here...

Using Transaction In Windows Application Or In Web Application where it work more Efficiently, using C# For Windows/Web using Transaction Process In SQL

SQL transaction works at the SQL Server side and not at the client side. Therefore it might not make a difference, whether it is being used in a web application or from a windows application.

This is same with most of the databases. If you are using SQL Server, use SqlClient namespace to access the database.

Regards
Ganesh
http://ganeshprof.blogspot.com
Find your solution here...

Ganash Thanks For Your Reply,

Ya I Did All The Thinks For Transaction, and i inserted data using SQL table my question not about how to use transaction, my doubt is about where that transaction can work effieciently in Windows Application Or In Web Application

Hi there,

First of all, I don't understand the question. Or in fact, I don't understand how the answer can help you.

Transactions work best where they are needed. So, even if a transaction would perform 20 times faster in a desktop application (it doesn't), how would that benefit you when you're building a web application? What's the point in knowing where it performs better?

That said, I think that's what Ganesh said too. He didn't tell you how to use transaction but said: Isn't that the answer to your question?

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Thanks For Your Reply Imar,

We Can Use Transaction In Windows Application And In Web Application too,My Doubt is Where it work more Effectively, You meantion that in Your Reply that Transaction Work 20 times faster in Windows Application,how about the Web Application, thats my doubt Imar,

Guide Me,

Thanks In Advance

Hi windows_mss

Just try to focus on what Imar and r_ganesh76 are trying to explain, Imar just gave an example about 20 times faster in desktop application, he never confirmed it, read the post carefully.

For a basic understanding, there won't be any difference between web and desktop applications, as r_ganesh76 said, transactions are carried by SQL Server, so it won't consider whether you are requesting from a desktop or webapplication.

If you wanna use transactions in SQL Server, use the namespace SqlClient.

Regards
Mike

Fortune favours the brave, so don't regret on missed oppurtunities.

Yes, exactly. Couldn't agree with you more, Mike.

windows_mss: take a look at this: This effectively says that a transaction in a web app isn't 20 times faster. But it also says that even if it *were* 20 times faster, it still wouldn't make a difference.

Who cares if transactions were 20 times faster in a desktop application when you are building a web application? IMO, you can't or shouldn't compare things like this....

Can you explain why you want to know the answer to this question? What does it matter to you?


Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Thanks Imar,

The Reason For My Post is as follows,Desktop Applcation are mostly standalone or within a LAN Network, But when talk about Web Application it Use various network across the geographic area, we can use transaction in both the cases so only i got his Query