I'm looking for the best (easiest, cheapest, fastest, most flexible) way
to implement object persistence in .NET 3.5.
The object data is native XML, so serialization is a good option as well
as SQL Server.
In memory objects will have a state modifier that indicates some sort of
progress on the object. In a file-system persistence solution, the state
modifier would place have the object move through some number of
different folders. That advantage here is easy simple access to data
throughout it's life-cycle; and even after its death, as it's final
state would be an archive state that would have the object saved in some
archive folder.
The business logic for some SQL Server solution would be simpler at the
expense of loosing the "openness" of a file system solution.
So, I'm looking for some open-source or other solution to implement this.
Ideas?
Thanks,
Bill