2

I am trying to implement a system that could store any kind of features for an object, the object can be any class of object. For each object i will save it's features using xml into the database. For each class of objects i will use a validation (DTD or XSD) constructed dynamically constructed by user, in order to validate the product before it's saved into database. A feature of the object can be any type of data : string, char, int,double, picture, video,etc.

Can you point me in some articles, examples, code snippets or best code oriented approach in order to obtain the goals i stated before?

From a previous question I've seen that this is the best approach.

Thanks,

Improve this question

1 Answer 1

Reset to default
4

I would say: toss the DTD and upgrade to the 21st century! Use XSD (XML schema) instead.

SQL Server 2005 and newer offers support for XML schema collections in your database, so you can "enforce" your XML columns to comply with a collection of possible XML schemata.

Read more about SQL Server XML schema collections here:

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Great answer, too bad i cannot give you more than one vote for it

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.