public async Task <TermNetworkDto> TermNetwork(string word, double grade)
{
using (var db = new StackoverflowDbContext())
{
var conn = (MySqlConnection)db.Database.GetDbConnection();
conn.Open();
var cmd = new MySqlCommand
{
Connection = conn
};
cmd.Parameters.Add("@w", DbType.String);
cmd.Parameters.Add("@n", DbType.Double);
cmd.Parameters["@w"].Value = word;
cmd.Parameters["@n"].Value = grade;
cmd.CommandText = "call term_network(@w, @n)";
var result = new TermNetworkDto();
var sb = new StringBuilder();
using (var reader = await cmd.ExecuteReaderAsync())
{
await reader.ReadAsync();
while (await reader.ReadAsync())
{
sb.Append((string)reader["var graph = "]);
}
}
result.Graph = sb.ToString();
return(result);
}
}
private TermNetworkModel CreateTermNetworkModel(TermNetworkDto dto)
{
var model = _Mapper.Map <TermNetworkModel>(dto);
return(model);
}
