String to Json data conversion for Collections in mongodb

Question

When I query a Collection in mongodb, it returns a field of the string type.

[{"id":"1325","nome":produto1,"estoque":"10"}]

But I need to make this field a Json.

It is possible to do this in the query using Find()?

Collection.Find(_=>true).Sort(Builders<Model>.Sort.Descending("_Id")).FirstOrDefault();


class Model
{
        [BsonId]
        public ObjectId _Id { get; set; }

        [JsonIgnore]
        public string Mensagem { get; set; }
}

Answer 1

I imagine what you have explained is that this string is returned within a field of the consulted object. That said, I’ve prepared this little example for you to try.

Similar issue #470437

class Program
{
    static void Main(string[] args)
    {
        IList<Model> entities = new List<Model>
        {
            new Model { Mensagem = "[{\"id\":\"1325\",\"nome\":\"produto1\",\"estoque\":\"10\"}]" }
        };

        var productJson = JsonConvert.DeserializeObject<List<Product>>(entities.FirstOrDefault().Mensagem).FirstOrDefault();

        Console.WriteLine(productJson);
        Console.ReadKey();
    }
}

class Product
{
    [JsonProperty("id")]
    public int Id { get; set; }

    [JsonProperty("nome")]
    public string Nome { get; set; }

    [JsonProperty("estoque")]
    public int Estoque { get; set; }

    public override string ToString()
    {
        return string.Join(" ", this.GetType()
                            .GetProperties()
                            .Select(prop => prop.GetValue(this)));
    }
}

class Model
{
    
    [BsonId]
    public ObjectId _Id { get; set; }

    [System.Text.Json.Serialization.JsonIgnore]
    public string Mensagem { get; set; }
}