Does anyone have a reliable way of storing serialized data into a table which does not use direct SQL on the client side? I am using Stored Procedures and simply need to be able to read out of the table the object written in.
Inserting appears fine, but reading only seems to come back with 16 bytes of data and I just can't figure out why. Whats the recommended way of doing this?
Matt.You're not reading the byte array properly. See if this article helps:
http://www.dotnetbips.com/displayarticle.aspx?id=60|||just thought I would let everyone know that I solved my serialization problem...
...I was creating a SqlParameter object with a SqlDbType.Image and giving it a size of 16, which meant every time I performed a DB op with that entry I got no more than 16 bytes of data back. very annoying.
anyway, Iv'e removed that from the new SqlParameter() and it works.
I had even read in various places that it's not possible to do serialization to the db using things like SQL, but I may have been just very paranoid by then...
cheers folks,
m.
No comments:
Post a Comment