Browse by Tags

Related Posts

  • ADO.NET: Use Database Transactions

    Database transactions are used to control data commitment to databases. For example, in standard account procedures, it is necessary to debit one account and credit another at the same time. Since computers break down on occasion (power outages, network outages, and so on) there is the potential for...
    Posted to Tips & Tricks (Forum) by vinayak_s_h on 05-25-2007, 12:00 AM
    Filed under: ADO.Net, transactions, Database
  • Best Practices to Build Reference Data Editors?

    I'm at a fork in the road about a programming choice and hope the community can share some wisdom with me. It simply involves this: Suppose you have a web app that has a number of reference data editors for the administrators of the app. Think of an e-commerce site where assorted data has to be edited...
    Posted to Architecture (Forum) by rmdw on 06-24-2007, 12:00 AM
    Filed under: database, transactions
  • NON-DB TRANSACTIONS in ASP.NET

    Hello there! This is thread is related to XML Web Services Transactions in ASP.NET. I have a web service called Orchestration which calls other web services like Flight, Hotel and Payment. All the web services have web methods with TransactionOption=Required and AutoComplete attribute including the Orchestration...
    Posted to Enterprise Services Integration (Forum) by hkbetchoo on 07-28-2007, 12:00 AM
    Filed under: XML Web Services, COM+, Transactions
  • Nested transaction scopes

    I have a set of objects: Person, Address, Phone, Subscription, Inventory, InventoryItem, Item, Parameters, ParameterValues, Delivery, etc. Subscription is defined as having a two different collections of Persons as well as one person. It also contains an Inventory and a Delivery. Inventory has inventoryItems...
    Posted to Architecture (Forum) by imhobbes on 09-10-2007, 12:00 AM
    Filed under: N-Tier, transactions, dalc, nested
  • Re: TransactionScope

    Try moving your Complete() outside of the Using statement for the SqlConnection: Using ts As New TransactionScope Using sqlConnection sqlConnection.Open() Try dbCommand.ExecuteNonQuery() Console.WriteLine("Success") Catch ex As SqlException Console.WriteLine(ex.Message) Finally dbCommand.Dispose...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by foreachbiscuit on 10-23-2007, 12:00 AM
    Filed under: transactions
  • Does TransactionScope work really with MySql ?

    Hi, you've got a .Net SOA (Framework 2.0) and we want to migrate from MsSQL to MySql for persistance considerations. I tried following sample with MsSql2005 (System.Data.SqlClient) and MySql5.x (MySql.Data.MySqlClient 5.0.3, 5.1.2->5.1.5, 5.2.1). I try to use TransactionScope feature with MySql...
    Posted to MySQL (Forum) by MisterT on 03-28-2008, 12:00 AM
    Filed under: mysql, .NET 2.0, transactionscope, transactions
  • Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction

    I'm using TransactionScope object and it is giving me problems. The situation is like this. I've 2 tables in sql server express, say student and courses and other one studentcourse for courses a student has opted for. An aspx page displays list of users in listbox, when user chooses student,...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by techmail on 04-11-2008, 12:00 AM
    Filed under: ASP.NET, transactions, sql express
  • Transaction problems between XP SP2 client and SQL2000/Win2000 server

    When I run the following code: (InsertNew inserts several rows into the database) using (TransactionScope tc = new TransactionScope()) { ETMR.InsertNew(ETMRList); tc.Complete(); } I get the following error: Server Error in '/' Application. The transaction has already been implicitly or explicitly...
    Posted to Data Access and ObjectDataSource Control (Forum) by pens on 06-12-2008, 12:00 AM
    Filed under: TransactionScope, Transactions
  • Re: Linq and Transactions

    Take a look at my article on CodeProject or on my Blog. I have created a Linq DataContext class that makes setting Transaction levels a snap. http://www.codeproject.com/KB/linq/DataContextTransactions.aspx http://ablogonbothyourhouses.blogspot.com/
    Posted to Data Access and ObjectDataSource Control (Forum) by Michael.Piccolo on 04-04-2008, 12:00 AM
    Filed under: Linq, DataContext, Transactions
  • Transactions in Sql Server

    I am using ADO.Net for data access and was wondering if anyone knows a good resource for information of sql transactions? Also, do you know if the ForEach statement can be made in sql transactions?
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by johnpwooton on 05-09-2007, 12:00 AM
    Filed under: transactions
Page 1 of 1 (10 items)