Web API returns empty json array

Question

I've traced through the my method (below) at run time. Below the code I've included a screenshot of the Debug examination of the Portfolios list just before the return statement. I've expanded a couple of the list entries. As you can see, each Portfolio object contains bona fide data - a numeric Id and a string name.

Yet, here's what comes back to the Chrome browser, or postman, no difference.

[{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{}]

What's happening to all the data? Thanks for your help!

 // GET: api/Portfolio
 [HttpGet]
 public List<Portfolio> Get()
 {
 List<Portfolio> Portfolios = new List<Portfolio>();
 using (SqlConnection cn = new SqlConnection(conn))
 {
 SqlCommand cmd = cn.CreateCommand();
 cmd.CommandText = sqlSelectPortfolios;
 cn.Open();
 SqlDataReader rdr = cmd.ExecuteReader();
 Portfolio pf;
 while (rdr.Read())
 {
 pf = new Portfolio
 {
 id = (int)rdr["PortfolioId"],
 name = (string)rdr["PortfolioName"]
 };
 Portfolios.Add(pf);
 }
 }
 return Portfolios;
 }

Debug:

Debug Screenshot

• tmaj: If id and name are fields and you're using System.Text.Json.JsonSerialiser than it won't serialise them as of Nov 2019.
• tmaj: Does this answer your question? How to use class fields with System.Text.Json.JsonSerializer?
• Herohtar: What is your Portfolio class code?

Answer 1

The id and name need to be public and properties. As of 3.0 System.Text.Json.JsonSerializer does not serialize fields.

public class Portfolio 
{
public int id {get; set;}
public string name {get; set;}
}

• Yossi G.: Thank you!! I had them as public but not defined as properties. As soon as I redefined these as properties I got the expected results.
• tmaj: The issue is logged as JsonSerializer should support field as well as properties #36505