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 ?
1 Answer, 1 is accepted
answered on 30 Sep 2009, 07:58 AM
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.