sib commented on "Entity Framework, TransactionScope and MSDTC"

sib — Thu, 19 May 2011 09:11:07 GMT

Thanks a lot! You saved my day. The main reason we do not want to use MS DTC is because it can be turned off on client servers or can lack network permissions and deployment becomes nightmare!

Unknown (myopenid) commented on "Entity Framework, TransactionScope and MSDTC"

Unknown (myopenid) — Tue, 24 Jan 2012 15:07:44 GMT

Hi, I am writing a serial transaction and had some troubles.
If I only execute one thread, it executes fast, no waiting.
If I execute two or more threads, the first thread that complete takes too much time but subsequent threads are fast, why?

If I run two process concurrently of this program, each process's first thread takes too much time to complete but subsequent are fast, is this normal?

I am using sql express 2008

tanks.

class Program
{
int numero;

Program(int numero)
{
this.numero = numero;
}

static void Main(string[] args)
{
Console.WriteLine("Puede presionar una tecla para salir en cualquier momento");

for (int i = 0; i < 10; i++)
{
Program p = new Program(i + 1);
Thread t = new Thread(p.Ejecutar);
t.Start();
}

Console.ReadKey();
}

public void Ejecutar()
{
bool esPosibleProseguir = true;
while (esPosibleProseguir)
{
Database1Entities cx = new Database1Entities();
TransactionOptions opts = new TransactionOptions();
opts.IsolationLevel = System.Transactions.IsolationLevel.Serializable;
System.Transactions.TransactionScope scope = new System.Transactions.TransactionScope(TransactionScopeOption.Required, opts);

try
{
//var mayor = cx.Numeracion.First();
//int nuevo = mayor.Numero + 1;
cx.Connection.Open();

int nuevo = cx.VistaNumero.First().Actual;

var per = new Persona();
per.Nombre = string.Format("Persona-{0}", nuevo);
per.Ci = (1000 + nuevo).ToString();
per.Numero = nuevo;
cx.Persona.AddObject(per);

//mayor.Numero = nuevo;

cx.SaveChanges();
scope.Complete();

Console.WriteLine("Hilo: {0}, Crea persona: {1}", this.numero, nuevo);
break;
}
catch (UpdateException ex1)
{
esPosibleProseguir = true;
}
catch (TransactionAbortedException ex2)
{
esPosibleProseguir = true;
}
catch (Exception ex)
{
Console.WriteLine("Hilo: {0}, Excepción: {1}, Mensaje: {2}", this.numero, ex.GetType().Name, ex.Message);
esPosibleProseguir = false;
}
finally
{
DisponerObjeto(scope);
DisponerObjeto(cx);
}
}
}

private void DisponerObjeto(IDisposable obj)
{
try
{
obj.Dispose();
}
catch (Exception ex)
{
Console.WriteLine("Hilo: {0}, Excepción: {1}, Mensaje: {2}", this.numero, ex.GetType().Name, ex.Message);
}
}
}

Comments on "Entity Framework, TransactionScope and MSDTC"

sib commented on "Entity Framework, TransactionScope and MSDTC"

Unknown (myopenid) commented on "Entity Framework, TransactionScope and MSDTC"