Q:

LinqPad connect two azure databases on same server

Per the FAQ (1), I can add additional databases to my existing connection in a number of ways.  I have tried them all, and none work for SQL Azure.  
In fact, SQL Azure as a provider, doesn't even include the option to "Include additional databases."
Can someone please tell me a workaround for LinqPad to connect two databases?  I am trying to create a migration linqpad script to sync data from one database to another.

http://www.linqpad.net/FAQ.aspx#cross-database

A:

This fails because SQL Azure does not let you create linked servers. See
Can linked server providers be installed on a SQL Azure Database instance?
If you simply want to copy data from one database to another, and the schemas are the same, a workaround is to create a separate connection using the same TypedDataContext class:
void Main()
{
    CopyFrom<Customer>("<source connection string>");
}

void CopyFrom<TTable> (string sourceCxString) where TTable : class
{
    // Create another typed data context for the source. Note that it must have compatible schema:
    using (var sourceContext = new TypedDataContext (sourceCxString) { ObjectTrackingEnabled = false })
    {
        // Delete the rows currently in our table:
        ExecuteCommand ("delete " + Mapping.GetTable (typeof (TTable)).TableName);

        // Insert the rows from the source table into the target table and submit changes:
        GetTable<TTable>().InsertAllOnSubmit (sourceContext.GetTable<TTable>());
        SubmitChanges();
    }
}

Simple Select Example:
void Main()
{
    SimpleSelect("<your conn string>");
}

void SimpleSelect (string sourceCxString)
{
    // Create another typed data context for the source. Note that it must have compatible schema:
    using (var sourceContext = new TypedDataContext (sourceCxString) { ObjectTrackingEnabled = false })
    {
        sourceContext.Assignee.OrderByDescending(a => a.CreateTimeStamp).Take(10).Dump();
        Assignee.OrderByDescending(a => a.CreateTimeStamp).Take(10).Dump();
    }
}

