storing complex objects in a database.

[Guest]

Is there a standard way of storing a complex object as an item in a database?
Something like:

public class Foo
{
public Foo(){}
public double Size
{
get{return this.size;}
set{size = value;}
}
public double[] Depth
{
get {return this.depth;}
set{this.depth = value;}
}
public Hashtable FunHash
{
get{return this.funHash;}
set{this.funHash = value;}
}
...................etc
}

This would be a dependent table, with other columns containing external keys
by which these objects could be filtered. I have thought of just using
hashtables to store such objects in conjunction with the database, wherein
external keys would be used as keys for a hashtable, and the related value
items would be lists of complex object instances, instead of filtering a
table of these complex objects.

 

[Sahil Malik [MVP]]

The closest equivalent of the below is a UDT - SQL2k5 only.

Alternatively you can easily serialize the below object and store a binary
bytestream in a bytearray in the db.

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
----------------------------------------------------------------------------