Unable to read binary data stored in VARBINARY (n) type fields

[alexluozf]

Hello,
Unable to read binary data stored in field BlockData VARBINARY (32,765) .

SortedDictionary<short, byte[]> result = [];
foreach (DataRow dataRow in dataTable.Rows)
{
if (dataRow["BlockNo"] is not short blockNo) { continue; }
object objVal = dataRow["BlockData"];
if(objVal is not byte[] blockData) { continue; }
//if (dataRow["BlockData"] is not byte[] blockData) { continue; }
result[blockNo] = blockData;
}
The value of objVal is always the string 'System. Byte []', the value of blockData is always the null.

Thanks a lot.
Alex

[alexluozf]

It's no problem if using FbDbDataReader.

SortedDictionary<short, byte[]> result = [];
while (reader.ReadAsync().Result)
{
short blockNo = reader.GetFieldValue("BlockNo");
byte[] blockData = reader.GetFieldValue<byte[]>("BlockData");
if (blockData != null)
{
result[blockNo] = blockData;
}
}

Thanks a lot.
Alex

[cincuranet]

Please provide self-contained runnable code.

[alexluozf]

Hello cincuranet,
Please use my test project.
Thanks a lot.
Alex

How to use.zip

FbBinaryFieldAccess.zip