serialized to blob

Thread is closed for posting
2 posts, 0 answers
  1. amir sherafatian
    amir sherafatian avatar
    42 posts
    Member since:
    Aug 2009

    Posted 29 Sep 2009 Link to this post

    i have a field of type byte[] , to mapp this field i select type Blob and varbinary(max) sql type
    about the check box of serialize to blob,what is its benefit and harms??? and when it should be use ?


  2. Zoran
    Zoran avatar
    534 posts

    Posted 30 Sep 2009 Link to this post

    Hi amir sherafatian,

    The blob serialization should be used in cases when there is a field of a type which does not have a corresponding type in the database server( or the corresponding type is not supported by OpenAccess). Arrays as in your case are one of the typical examples of such fields. The benefit is that the field is stored in the same table as the other fields from the persistent type. Otherwise there would be an additional table required to store the array values. The disadvantage of course is that you can not build a query based on such field. There are no means of filtering or ordering your data by it.

    All the best,
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Back to Top