#r "nuget: Microsoft.DotNet.Interactive.SqlServer, *-*"

var connectionString = Environment.GetEnvironmentVariable("TEST_MSSQL_CONNECTION_STRING");

#!connect mssql --kernel-name adventureworks @csharp:connectionString 

#!value --name country_region_code --from-value @input:country_region_code

#!sql-adventureworks
#!share --from value country_region_code

select * from Sales.SalesPerson left join Sales.SalesTerritory on Sales.SalesPerson.TerritoryID = Sales.SalesTerritory.TerritoryID
  where CountryRegionCode = @country_region_code

#!share --from sql-adventureworks territories
territories

#r "nuget: SandDance.InteractiveExtension, 1.0.45"

adventureworks.SalesPeople.ExploreWithSandDance()

territories