B3.Extensions.Data

B3.Extensions.Data includes data extensions for Entity Framework Core

DbContextExtensions

ExecuteQuery

Execute raw sql query without casting any type.

public async Task<IActionResult> Get()
{
   var sql = "SELECT type, SUM(length) FROM ways GROUP BY type";
   var queryResult = await _context.ExecuteQueryAsync(sql);
            
   return Ok(response);
}