Hello!
While writing to both Oracle and SQL Server I've noticed that when I use a Guid and send it to Oracle via ToByteArray() that the actual array being sent has the first 4 bytes reversed in the 16 byte block. So when I have preloaded values
in Oracle and I send this request, it swaps the Guid and does not return properly.
Example:
Guid sampleGuid = new Guid("11110000-0000-0000-0000-000000001111");
// This will have [0][0][17][17] instead of [17][17][0][0]
Byte[] bArray = sampleGuid.ToByteArray();
Now, when passing this byte array into the Guid constructor, it returns fine (ie, swaps it back).
I was just wondering why this was as I cannot seem to figure it out.
Thanks,
Eric