DataTable.Select with byte[]

[SlantyOD]

Hi all,

I have a DataTable that has been taken from a SQL Server table that makes extensive use of the binary datatype for primary and foreign keys. It appears that when it is brought into the ADO.NET DataTable, binary values are treated as byte arrays (byte[]). Is there a way to use DataTable.Select to find a row based on a byte[] value? I don't seem to be able to get it to work.

Thanks.

 

[SlantyOD]

For the record, the only way I've been able to get around this so far is to convert all the byte[] fields into strings when I do my initial Select. I take a pretty big performance hit on the select statement, but it pays off when I can use .Select to navigate through the data later on.