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)); }