Comparing Byte Arrays in LINQ to Objects

Question

In a LINQ query:

from c in results
where c.ByteField == byteData
select c;

I'm getting no results from this even though the bytes are the same:

byte[5] = 49, 50, 51, 52, 53

How do I compare bytes properly in LINQ to Objects?

Thanks.

Answer 1

In LINQ to Objects (as your post suggests in the title), you can use IEnumerable.SequenceEqual():

from c in results
where c.ByteField.SequenceEqual(byteData)
select c;

Unfortunately, it looks like you're using LINQ to SQL (or Entity Framework) based on your use of context. There's no SQL equivalent of SequenceEqual so this won't work in that case.