Form a text search vector (tsvector) with dbcontext / ado.net

PostgresFullTextSearchApi.cs

public async Task<NpgsqlTsVector> ToTsVector(DbContext dbContext, string content)
{
    var connection = dbContext.Database.GetDbConnection() as NpgsqlConnection;

    await using var cmd = new NpgsqlCommand("select to_tsvector('english', @content)", connection );

    cmd.CommandType = CommandType.Text;

    if (connection!.State != ConnectionState.Open) connection.Open();
    cmd.Parameters.Add(new NpgsqlParameter("content", content));

    var value = await cmd.ExecuteScalarAsync();
    var tsVector = value == DBNull.Value || value == null ? null : value as NpgsqlTsVector;

    return tsVector;
}