gistfile1.cs

public static string GetProductDetails(string id)
{
   var reader = blahBlahBlah();
   
   var list = new List<object>();
   while(reader.Read())
   {
      list.Add(new {
          Id = reader["Id"],
          Name = reader["Name"],
          etc...
      });
   }

    var serializer = new JavaScriptSerializer();
    serializer.Serialize(list);
}