SQL Server INSERT INTO SELECT

var rows = DbContext.Database.Execute((Customers customer, Addresses address) =>
{
    var set = address.@using((address.Street, address.City, address.State, address.ZipCode));

    INSERT().INTO(set);
    SELECT((customer.Street, customer.City, customer.State, customer.ZipCode));
    FROM(customer);
});

Console.WriteLine($"{rows} rows affected");

var cities = new[] { "Santa Cruz", "Baldwin" };

var rows = DbContext.Database.Execute((Stores stores, Addresses address) =>
{
    var set = address.@using((address.Street, address.City, address.State, address.ZipCode));

    INSERT().INTO(set);
    SELECT((stores.Street, stores.City, stores.State, stores.ZipCode));
    FROM(stores);
    WHERE(cities.Contains(stores.City));
});

Console.WriteLine($"{rows} rows affected");

var rows = DbContext.Database.Execute((Customers customer, Addresses address) =>
{
    var set = address.@using((address.Street, address.City, address.State, address.ZipCode));

    INSERT(TOP(10)).INTO(set);
    SELECT((customer.Street, customer.City, customer.State, customer.ZipCode));
    FROM(customer);
});

Console.WriteLine($"{rows} rows affected");

var rows = DbContext.Database.Execute((Customers customer, Addresses address) =>
{
    var set = address.@using((address.Street, address.City, address.State, address.ZipCode));

    INSERT(TOP(10).PERCENT()).INTO(set);
    SELECT((customer.Street, customer.City, customer.State, customer.ZipCode));
    FROM(customer);
});

Console.WriteLine($"{rows} rows affected");