Post reply

Can I store object or object''s information in database (SQL Server 2005)?

  • March 30, 2006 at 4:21 am

    #91619

    Dear All

    Can I store object or object's information in database (SQL Server 2005)?

    In any data type or any other method

    Please Help me

    Regards

    Qaiser

  • March 30, 2006 at 6:07 am

    #629795

    Please do not cross post to multiple forums.

    You can store anything in SQL (anything that can be expressed digitally I mean ) . If by object you mean a "file", use the IMAGE datatype (SQL 2000) or VARBINARY(MAX) (SQL 2005).

    If you mean object in the OO context, you can certainly serialize it in those datatypes or even in XML. If you don't want serialization, but just to persist your object properties in the datastore, you have work to do since this is an OO problem not a SQL problem. There are O/R mappers and various other techniques. O/R mapping is a complex subject with many unsatisfactory answers (that work nonetheless).

     

    Hope that helps...

     

    L

  • March 31, 2006 at 1:03 am

    #630021

    Hello Rookie

    What you mean by O/R mapping subject. I have an object of Formating in which store font, colr, size etc. Now i want to store the all object information.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply