Hi, I have a simple linq query below that requires comparing 2 byte arrays (same size) in where clause. The framework returns error that SequenceEqual() is not supported by the linq provider. Please would you suggest an alternative (desperately needs this to work

Many thanks

        var metaData = new LinqMetaData(adapter);
        var q = from v in metaData.Table1
                join w in metaData.Table2 on v.Id equals w.Id
                where bytes16.SequenceEqual(w.bytes16)
                select v;

There is no SQL function mapping for SequenceEqual. Just use "==':

var metaData = new LinqMetaData(adapter);
            var q = from v in metaData.Table1
                    join w in metaData.Table2 on v.Id equals w.Id
                    where w.bytes16 == bytes16
                    select v;