public async Task PostGeoJson(QueryCommandOption queryOption)
{
Response.ContentType = "application/json; charset=utf-8";
using var qe = new SqlJsonQueryStreamWriter(ApiConstants.MASTER_REF_CONNECT_STRING);
// var query =
//@"
//SELECT TOP 1000 [PostalCode]
// ,[PlaceName]
// ,[AdminName1]
// ,[AdminCode1]
// ,[AdminName2]
// ,[AdminCode2]
// ,[Latitude]
// ,[Longitude]
// ,[Accuracy]
//FROM [dbo].[USGeoName]
//";
var ms = await qe.ExecuteJsonQueryAsync(queryOption) as MemoryStream;
await Response.Body.WriteAsync(ms.ToArray(), 0, (int)ms.Length);
// https://localhost:5001/api/geoname/geojson
}
public async Task <Stream> ExecuteJsonQueryAsync(QueryCommandOption queryCommand)
{
m_SqlCommand = new SqlCommand(queryCommand.CommandText);
m_SqlCommand.CommandTimeout = queryCommand.CommandTimeout;
m_SqlCommand.CommandType = queryCommand.CommandType;
// TODO: add parameter create logic here
return(await ExecuteJsonQueryAsync(m_SqlCommand));
}
