Styjun

Im facing a litle problem in Deserializing BsonDocuments type, I couldn't find the reason, but I have some clues, maybe, it's about 0 fields, because the error tel me about the column I have 0 fields. I also realised that its a (empty array).

MY MONGO QUERY ON ROBO 3T AND THE RESULT

MY C# MONGO QUERY

 var connString = "mongodb+srv";
 var client = new MongoClient(connString);
 var database = client.GetDatabase("Base");
 var collection = database.GetCollection<BsonDocument>("collection");

 var match1 = new BsonDocument("$match", new BsonDocument("PartnerId", "2021"));
 var match2 = new BsonDocument("$match", new BsonDocument("CD_CLIENTE", codCond));

 var project = new BsonDocument "$project", new BsonDocument "_id", 0 , "CD_CLIENTE", 1 , "CD_ACESSO", 1 ,
 "ID_ACESSO", 1 , "NOME", 1 , "NU_TELEFONE", 1 , "EMAIL", 1 , "NU_KIPER_RF", 1 , "NU_KIPER_TAG", 1 ,
 "FG_KIPER_MOBILE", 1 , "KEY_HASH", 1 ,; MY MONGO AND RESULT

 var sort = new BsonDocument("$sort", new BsonDocument("NOME", 1));

 var pipeline = new[] match1, match2, project, sort ;
 var result = collection.Aggregate<BsonDocument>(pipeline).ToList();

 var lista = JsonConvert.DeserializeObject<List<UsuariosAcessos>>(result.ToJson());

The error is here:

 var lista = JsonConvert.DeserializeObject<List<UsuariosAcessos>>(result.ToJson());

Exatly when I try to Deserialise an that "empty array" to Model int?. I found a work around, because I just need to know if, we have or dont not something in NU_KIPER_TAG and NU_KIPER_RF, so, I did this new Mongo query.
NEW MONGO QUERY USING $COND

db.dbACESSO.aggregate([


 $match: PartnerId: "2021", CD_CLIENTE: 4003
,


 $project: _id:0, CD_CLIENTE:1, CD_ACESSO:1, ID_ACESSO:1, NOME:1, NU_TELEFONE:1,EMAIL:1, FG_KIPER_MOBILE:1,
 TAG:$cond: [ $eq: [ "$NU_KIPER_TAG", ], 0, 1 ], CONTROLE:$cond: [ $eq: [ "$NU_KIPER_RF", ], 0, 1 ], 
 APPATIVO:$cond: [ $eq: [ "$KEY_HASH", ], "", "$KEY_HASH" ]



])

I couldnt translate it to C#, I tried hard, but i'm not familiarized with the sintaxe. I also googled for a sample with no success.

I think its something like:

var project = new BsonDocument 
 
 "$project", new BsonDocument "_id", 0 , "CD_CLIENTE", 1 , "CD_ACESSO", 1 , "ID_ACESSO", 1 , "NOME", 1 
 , "NU_TELEFONE", 1 , "EMAIL", 1 , "NU_KIPER_RF", 1 , "NU_KIPER_TAG", 1 , "FG_KIPER_MOBILE", 1 , "KEY_HASH", 1 ,


 "TAG", new BsonDocument"$cond", new BsonDocument "$eq", "$NU_KIPER_TAG", "", 0, 1 ], 
 
 
 ; 

What about using the fluent C# like this:

 var connString = "mongodb+srv";
 var client = new MongoClient(connString);
 var database = client.GetDatabase("Base");
 var collection = database.GetCollection<UsuariosAcessos>("collection"); //Here you put you Model

 var filter = Builders<UsuariosAcessos>.Filter.Eq(x => x.PartnerId, cliente) 
 & Builders<UsuariosAcessos>.Filter.Eq(x => x.CD_CLIENTE, codCond); 

 var lista = collection.Aggregate().Match(filter).Project(x => new UsuariosAcessos
 
 CD_CLIENTE = x.CD_CLIENTE,
 ID_ACESSO = x.ID_ACESSO,
 CD_ACESSO = x.CD_ACESSO,
 NOME = x.NOME,
 NU_TELEFONE = x.NU_TELEFONE,
 EMAIL = x.EMAIL,
 NU_KIPER_RF = x.NU_KIPER_RF,
 NU_KIPER_TAG = x.NU_KIPER_TAG,
 FG_KIPER_MOBILE = x.FG_KIPER_MOBILE,
 KEY_HASH = x.KEY_HASH
 ).ToList();

About your problem at Deserialization time, I think it's not possible to translate (empty array) to int or int?, it's appear to be the reason your deserialization is not working, try to change your model.

FROM:

public int? NU_KIPER_TAG get; set; 
public int? NU_KIPER_RF get; set; 

TO:

public object NU_KIPER_TAG get; set; 
public object NU_KIPER_RF get; set; 

Its not you are looking for, but, maybe your Deserialization are going to Work. After that, you can convert the data. Hope this helps.

I'm not sure about how to represent that empty array on the C# Driver. Try this way:

var project = new BsonDocument 
 
 "$project", new BsonDocument "_id", 0 , "CD_CLIENTE", 1 , "CD_ACESSO", 1 , "ID_ACESSO", 1 , "NOME", 1 
 , "NU_TELEFONE", 1 , "EMAIL", 1 , "NU_KIPER_RF", 1 , "NU_KIPER_TAG", 1 , "FG_KIPER_MOBILE", 1 , "KEY_HASH", 1 ,


 "TAG", new BsonDocument "$cond", new BsonArray new BsonDocument "$eq", new BsonArray "$NU_KIPER_TAG", "",1,0,
 
 
 ;