C# byte array contains string inside linq where

Question

I need to check if my byte array contains string in LinQ Where() method. At the moment I have something like:

public static bool ContainsSequence(byte[] toSearch, byte[] toFind)
{
    for (var i = 0; i + toFind.Length < toSearch.Length; i++)
    {
        var allSame = true;
        for (var j = 0; j < toFind.Length; j++)
        {
            if (toSearch[i + j] != toFind[j])
            {
                allSame = false;
                break;
            }
        }

        if (allSame)
        {
            return true;
        }
    }

    return false;
}
var data = MyCollection.Where(x => ContainsSequence(x.ByteArrayValue, myStringToByteArray);

but I'm getting exception:

LINQ to Entities does not recognize the method ContainsSequence

I've read somewhere that I can rewrite ContainsSequence method to Linq.Extensions.Extension but I have no idea how. Can someone direct me to a solution?

Why not just fetch the entire collection by doing MyCollection.AsEnumerable() and then doing .Where() on that? Unless your collection is extremely large then doing it in memory shouldn't be a problem. — steliosbl
– steliosbl, Commented Jul 10, 2017 at 7:08
Did you mean: var data = MyCollection.AsEnumerable().Where(x => ContainsSequence(x.ByteArrayValue, myStringToByteArray); //? I'm getting null reference exception when I do this — d3st1ny
– d3st1ny, Commented Jul 10, 2017 at 7:12
This should work: var data = MyCollection.AsEnumerable().Where(x => ContainsSequence(x.ByteArrayValue, myStringToByteArray); — steliosbl
– steliosbl, Commented Jul 10, 2017 at 7:13
It's DataSet from my Entity Framework Database. Collection is set of data which I want to load to memory. I didn't realise that is important. — d3st1ny
– d3st1ny, Commented Jul 10, 2017 at 7:19

steliosbl · Accepted Answer · 2017-07-10 07:19:15Z

EntityFramework only allows you to use a limited selection of LINQ methods, because, unless you explicitly tell it otherwise, EF doesn't execute them in memory, but converts them into a query and has the SQL provider do it instead. If you want to use your own custom method you will have to do the following:

var data = MyCollection.AsEnumerable().Where(x => ContainsSequence(x.ByteArrayValue, myStringToByteArray);

What we are doing here is we are casting the collection (which should be a DbSet or IQueryable) into an IEnumerable, on which we can use the custom method.

Be advised however, this has the side effect of loading the entire set into memory. This shouldn't be a problem unless you're dealing with very large amounts of data, but it is something to keep in mind.

You can read more about AsEnumerable() and exactly what it does and when to use it here.

pitersmx · Accepted Answer · 2017-07-21 11:02:20Z

0

try this:

foreach (var item in MyCollection.ToArray())
{
   var data = item.Where(x => x.ContainsSequence(x.ByteArrayValue, myStringToByteArray));
}

edited Jul 21, 2017 at 11:02

answered Jul 10, 2017 at 7:13

pitersmx

95711 silver badges29 bronze badges

Collectives™ on Stack Overflow

C# byte array contains string inside linq where

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related