public async Task GetJsonContent()
{
Response.ContentType = "application/json; charset=utf-8";
using var qe = new SqlJsonQueryStreamWriter(ApiConstants.TEST_CONNECT_STRING);
var query =
@"
SELECT TOP (1000) [AccessFailedCount]
,[UserName]
,[PasswordHash]
,[PasswordExpiration]
,[ConcurrencyStamp]
,[IsBlocked]
,[IsDeleted]
,[LockoutEnabled]
,[LockoutEnd]
,[SecurityStamp]
,[Data]
,[ModifiedBy]
,[ModifiedDate]
FROM [dbo].[UserAuthentication]
";
Response.ContentType = MediaTypeNames.Application.Json;
var ms = await qe.ExecuteJsonQueryAsync(query) as MemoryStream;
await Response.Body.WriteAsync(ms.ToArray(), 0, (int)ms.Length);
// https://localhost:5001/api/geoname/json
}
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
}
private async Task <MemoryStream> GetJsonStreamAsync()
{
using var qe = new SqlJsonQueryStreamWriter(ApiConstants.TEST_CONNECT_STRING);
var query =
@"
SELECT TOP (1000) [PostalCode]
,[PlaceName]
,[AdminName1]
,[AdminCode1]
,[AdminName2]
,[AdminCode2]
,[Latitude]
,[Longitude]
,[Accuracy]
FROM [junk].[dbo].[USGeoName]
";
//var firstPass = await qe.ExecuteJsonQueryAsync(query) as MemoryStream;
return(await qe.ExecuteJsonQueryAsync(query) as MemoryStream);
}
