Changing Connections On The Fly

using (SharedDbConnectionScope scope = new SharedDbConnectionScope("new connectionstring "))
{
    //do stuff using new connection string}

// returns to default provider connection string

using (SharedDbConnectionScope sharedConnectionScope = new SharedDbConnectionScope())

using (TransactionScope ts = new TransactionScope())
{
    Product p = new Product(1);
    p.Title = "new title";

    Product p2 = new Product(2);
    p.Title = "another new title";

    // ...

    p.Save();
    p2.Save();
    ts.Close();
}