Dapper bulk inserts are taking longer than planned.

I made the decision to examine more closely at how I was using Dapper after reading this piece.

I ran this code on a blank database.

var members = new List<Member>();
for (int i = 0; i < 50000; i++)
{
    members.Add(new Member()
    {
        Username = i.toString(),
        IsActive = true
    });
}

using (var scope = new TransactionScope())
{
    connection.Execute(@"
insert Member(Username, IsActive)
values(@Username, @IsActive)", members);

    scope.Complete();
}

About 20 seconds passed. That is 2500 inserts per second. Given that the blog was averaging 45k entries per second, not terrible, but also not excellent. Is there a faster method to do this with Dapper?

Aside: It took 3+ minutes long! to run this code via the debugger in Visual Studio. I expected the debugger would slow things down a bit, but I wasn't expecting it to slow it down that much.

UPDATE

then this

using (var scope = new TransactionScope())
{
    connection.Execute(@"
insert Member(Username, IsActive)
values(@Username, @IsActive)", members);

    scope.Complete();
}

also that

    connection.Execute(@"
insert Member(Username, IsActive)
values(@Username, @IsActive)", members);

each need 20 seconds.

nonetheless, it took 4 seconds!

SqlTransaction trans = connection.BeginTransaction();

connection.Execute(@"
insert Member(Username, IsActive)
values(@Username, @IsActive)", members, transaction: trans);

trans.Commit();