Persist object to SQLCE row

[David Webb]

I have a number of classes that I would like to be able to persist to an
SQLCE database table row. The table structures match the classes exactly
for all public members. For now, I am writing load() and save() methods in
the classes that generate the necessary INSERT, UPDATE, and SELECT
statements. I was wondering if there may be a simpler way to do this - a
bit more automatically, maybe. I don't want to serialize the objects and
just have them stored as a large XML strings.

Any Suggestions?

Thanks,
Dave

 

[Lloyd Dupont]

I don't know about that.
But you might be interested in this product:

http://www.db4o.com

I'm using it since, uh.. 2 weeks now, but I found it great!

 

[David Webb]

That looks great, but I need to stick with the free runtime programs (SQLCE)
for now.

-Dave