This SqlTransaction has completed; it is no longer usable ?

I am facing a problem with sqlbulk .

I have a list of PersonModel and trying to insert or save the data into SQL server but i am getting an exeption

private static List PersonModels { get; set; }

AsDataTable is an Extention Method

its throwing an exception on transaction.Commit().... System.InvalidOperationException "This SqlTransaction has completed; it is no longer usable "

using (SqlConnection connection = new SqlConnection(CS))
{
connection.Open();
SqlTransaction transaction = connection.BeginTransaction();
using (var bulkCopy = new SqlBulkCopy(connection, SqlBulkCopyOptions.Default, transaction))
{
bulkCopy.BatchSize = 100;
bulkCopy.DestinationTableName = "dbo.Person";
try
{
bulkCopy.WriteToServer(PersonModels.AsDataTable());
}
catch (Exception ex)
{
transaction.Rollback();
Console.WriteLine("Rollback Exception Type: {0}", ex.GetType());
Console.WriteLine(" Message: {0}", ex.Message);
}
}
transaction.Commit();
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.