tagged [transactions]
what does a using statement without variable do when disposing?
what does a using statement without variable do when disposing? I've always used using with variable and assignment. Now i have like this a class DbProviderConnection: ``` public class DbProviderConne...
- Modified
- 24 Feb at 12:55
NHibernate with Autofac within ASP.NET (MVC): ITransaction
NHibernate with Autofac within ASP.NET (MVC): ITransaction What is the best approach to managing NHibernate transaction using Autofac within web application? My approach to session is For `ITransactio...
- Modified
- 26 Oct at 17:48
Database.BeginTransaction vs Transactions.TransactionScope
Database.BeginTransaction vs Transactions.TransactionScope What is the difference between `System.Transactions.TransactionScope` and EF6's `Database.BeginTransaction`? Could someone give a small examp...
- Modified
- 21 Oct at 06:2
Pros and cons of READ_COMMITTED_SNAPSHOT
Pros and cons of READ_COMMITTED_SNAPSHOT What are the pros and cons of setting `READ_COMMITTED_SNAPSHOT ON` in SQL server 2008? Actually i was running through the the problem of transaction deadlockS,...
- Modified
- 24 Oct at 16:40
C# - System.Transactions.TransactionScope
C# - System.Transactions.TransactionScope I was curious about the TransactionScope class. For the most part, I assume it was intended for database connections (which is what I've used it for). My ques...
- Modified
- 16 Feb at 14:7
Does ServiceStack's OrmLite support nested transactions? If so, how?
Does ServiceStack's OrmLite support nested transactions? If so, how? I'm looking for a working example of an outer method containing a transaction calling an inner method which also contains a transac...
- Modified
- 17 Mar at 08:10
Use of TransactionScope with read uncommitted - is with (nolock) in SQL necessary?
Use of TransactionScope with read uncommitted - is with (nolock) in SQL necessary? I am using FluentNHibernate, and I have a list of records, mapped to an SQL Server 2008 view. Dirty reads are OK with...
- Modified
- 30 Sep at 19:58
Howto Ambient Transaction in ServiceStack.net
Howto Ambient Transaction in ServiceStack.net I am developing a server application using ServiceStack.net. The Database is accessed via EntityFramwork. Now I would like to have an Ambient Transaction ...
- Modified
- 14 Jan at 03:11
C#/SQL Database listener
C#/SQL Database listener I have a requirement to monitor the Database rows continuously to check for the Changes(updates). If there are some changes or updates from the other sources the Event should ...
- Modified
- 8 Jan at 12:52
How to find the Transaction Status
How to find the Transaction Status I am using 'TransactionScope', and I need to just do some DML within the C# Code, which I have successfully. I need to find out that , that is has it completed succe...
- Modified
- 29 Mar at 22:13
Difference Between Transaction and TransactionScope
Difference Between Transaction and TransactionScope I am developing an application which communicates with an SQL Server 2005 database to execute some stored procedures. My client demands that all tra...
- Modified
- 27 Jun at 12:58
Servicestack.redis Transactions and Hashes
Servicestack.redis Transactions and Hashes How can I get all the entries from a hash while in a transaction? I don't see an `onSuccessCallback` with the right type. I tried mapping it as a `byte[][]` ...
- Modified
- 15 Apr at 16:28
How to create a class that works with TransactionScope?
How to create a class that works with TransactionScope? Just wondering, if I want to create a class that does something and I want to be able to be used in a TransactionScope, what would I need to imp...
- Modified
- 10 Mar at 20:59
Is Explicit Transaction Rollback Necessary?
Is Explicit Transaction Rollback Necessary? Many examples out there advocate explicit rollback of database transactions, along the lines of: However, I te
- Modified
- 17 Feb at 13:24
TransactionScope With Files In C#
TransactionScope With Files In C# I've been using TransactionScope to work with the database and it feels nice. What I'm looking for is the following: but obviously this doesn't work -- if there are 2...
- Modified
- 18 Feb at 14:43
When does "SqlConnection does not support parallel transactions" happen?
When does "SqlConnection does not support parallel transactions" happen? I have a ton of rather working code that's been here for months and today I saw the following exception logged: ``` System.Inva...
- Modified
- 24 Oct at 07:34
Is SQL Server Bulk Insert Transactional?
Is SQL Server Bulk Insert Transactional? If I run the following query in SQL Server 2000 Query Analyzer: On a text file that conforms to OurTable's schema for 40 lines, but then changes format for the...
- Modified
- 3 Sep at 15:1
Using NHibernate transaction in SqlBulkCopy
Using NHibernate transaction in SqlBulkCopy I'm storing some data using NHibernate, and I need to insert huge amount of data as a part of this action - i.e. in the same transaction. Code looks like th...
- Modified
- 5 Jan at 12:42
Using Transactions or SaveChanges(false) and AcceptAllChanges()?
Using Transactions or SaveChanges(false) and AcceptAllChanges()? I have been investigating transactions and it appears that they take care of themselves in EF as long as I pass `false` to `SaveChanges...
- Modified
- 20 Mar at 11:20
TransactionScope: Avoiding Distributed Transactions
TransactionScope: Avoiding Distributed Transactions I have a parent object (part of a DAL) that contains, amongst other things, a collection (`List`) of child objects. When I'm saving the object back ...
- Modified
- 13 Jun at 10:53
SQL Server - transactions roll back on error?
SQL Server - transactions roll back on error? We have client app that is running some SQL on a SQL Server 2005 such as the following: It is sent by one long string command. If one of t
- Modified
- 17 Nov at 16:10
SQL Server, C#: Timeout exception on Transaction Rollback
SQL Server, C#: Timeout exception on Transaction Rollback I've got a strange problem. I have a .NET program and my process logic needs a long-running transaction (~20min) on a SQL Server 2005 database...
- Modified
- 20 Oct at 12:20
Will a using statement rollback a database transaction if an error occurs?
Will a using statement rollback a database transaction if an error occurs? I've got an IDbTransaction in a using statement but I'm unsure if it will be rolled back if an exception is thrown in a using...
- Modified
- 14 Mar at 00:52
"The operation is not valid for the state of the transaction" error and transaction scope
"The operation is not valid for the state of the transaction" error and transaction scope I am getting the following error when I try to call a stored procedure that contains a SELECT Statement: > The...
- Modified
- 2 May at 12:9
SQL Server snapshot isolation level issue
SQL Server snapshot isolation level issue I am studying snapshot isolation level of SQL Server 2008 from the below link. My confusion is, [http://msdn.microsoft.com/en-us/library/ms173763.aspx](http:/...
- Modified
- 12 Jul at 08:39