c# - How to get a byte array length using LINQ to Entities?

Question

I have a Document class that stores the data of that document as a byte array. I need to check the size of the array, using LINQ to Entities.

I have tried the following:

[long Linq query here...] o.Data.Length < 800000)

The problem is I get the following exception:

The LINQ expression node type 'ArrayLength' is not supported in LINQ to Entities."

Is there any other way to check the size of the byte array?

Answer 1

Use SqlFunctions.DataLength Method (Byte[]) to compare length.

yourquery..... SqlFunctions.DataLength(o.Data) < 800000)

See: Linq2EF pitfall: Using Length property causes System.NotSupportedException