Geo coords for address line via Yandex API

coords.cs

const string cs = "<CONNECTION_STRING>";
const string key = "<YANDEX_API_CODE>";
const string requestUrlTemplate = 
    "http://geocode-maps.yandex.ru/1.x/" + 
    "?geocode={0}&key={1}&&results=1";

var addresses = new List<string>();
using (var connection = new SqlConnection(cs))
using (var select = connection.CreateCommand())
{
    select.CommandText = 
        "select distinct AddressLine from FacilityCoords";

    connection.Open();
    using (var reader = select.ExecuteReader())
    while (reader.Read())
    { 
        addresses.Add((string)reader["AddressLine"]);
    }
}

using (var browser = new WebClient())
{
    browser.Encoding = Encoding.UTF8;
    foreach(var address in addresses)
    {
        var requestUrl = string.Format(
            requestUrlTemplate,
            HttpUtility.UrlPathEncode(address),
            HttpUtility.UrlPathEncode(key));

        var geo = browser.DownloadString(requestUrl);
        using (var sr = new StringReader(geo))
        {
            sr.ReadLine(); // skip xml declaration
            geo = sr.ReadToEnd();
        }

        using (var connection = new SqlConnection(cs))
        using (var update = connection.CreateCommand())
        {
            connection.Open();
            update.CommandText = 
                "update FacilityCoords set GeoObjectXML = @GeoObjectXML " + 
                "where AddressLine = @AddressLine";
                        
            update.Parameters.Add("@GeoObjectXML", geo);
            update.Parameters.Add("@AddressLine", address);
            update.ExecuteNonQuery();
        }
    }
}

geopoint.sql

create view FacilityGeoPoint
as
  select FacilityID, Point = GeoObjectXML.value(N'
  declare namespace gml="http://www.opengis.net/gml";
  (//gml:pos/text())[1]', 'nvarchar(50)') from FacilityCoords