lucamozzo / dbdatareadermapper Goto Github PK

public static List<T> RawSqlQuery<T>(this DbContext context, string query)
{
    var command = context.Database.GetDbConnection().CreateCommand();
    command.CommandText = query;
    command.CommandType = CommandType.Text;

    context.Database.OpenConnection();

    DbDataReader result = command.ExecuteReader();

    List<T> entities = new();

    while (result.Read())
    {
        T entity = result.MapToObject<T>(); //ERROR 

        entities.Add(entity);
    }

    return entities;
}