var client = new MongoClient("mongodb+srv://user:password@cluster.mongodb.net");
var database = client.GetDatabase("PTITSCurve");
var collection = database.GetCollection<BsonDocument>("PlanningData");
var filter = Builders<BsonDocument>.Filter.Eq("WSID", WSId);
var projection = Builders<BsonDocument>.Projection.Exclude("_id");
System.Collections.Generic.IEnumerable<MongoDB.Bson.BsonDocument> bsonResult = collection.Find<BsonDocument>(filter).Project(projection).ToList();
sorry the db is sombodys , he is not allowing to change the collation , so if i can set some thing in connection string or with out collation , then it would be help full, pls give example i am new and do not have time as i have to delever.