use regex mongo c# to find in list

Question

can i do this in one function or in more short way of one query instead of that? i am trying to get email with a regex but i need to check each email in the list.

public ObjectId? GetEntityIdByEmail(string email)
{
    var projection = Builders<Entity>.Projection.Include(x=>x._id);
    var filter = Builders<Entity>.Filter.Regex("Email", new BsonRegularExpression(new Regex(email, RegexOptions.IgnoreCase | RegexOptions.IgnorePatternWhitespace)));
    var id = _entitiesStorage.SelectAsSingleOrDefault(filter,projection);
    if (id == null)
        return null;
    return (ObjectId)id["_id"];
}

public List<ObjectId> GetEntitiesIdsByEmail(IList<string> emails)
{
    var result = new List<ObjectId>();
    foreach (var email in emails)
    {
        var id = GetEntityIdByEmail(email);
        if (id != null)
            result.Add(id.Value);
    }
    return result;
}

rnofenko · Accepted Answer · 2015-12-14 19:13:07Z

1

You can extend you regex query

public async Task<List<ObjectId>> GetEntitiesIdsByEmail(IList<string> emails)
{
     var regexFilter = "(" + string.Join("|", emails) + ")";
     var projection = Builders<Entity>.Projection.Include(x => x.Id);
     var filter = Builders<Entity>.Filter.Regex("Email",
           new BsonRegularExpression(new Regex(regexFilter, RegexOptions.IgnoreCase | RegexOptions.IgnorePatternWhitespace)));
     var entities = await GetCollection().Find(filter).Project(projection).ToListAsync();
     return entities.Select(x=>x["_id"].AsObjectId).ToList();
}

answered Dec 14, 2015 at 19:13

rnofenko

9,5932 gold badges55 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

use regex mongo c# to find in list

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related