[ Edited Version ]
Note : I don't want to use open source CMS , and want to write my own here , This is a Designing Question
[ The question at first wasn't vague like this , because I wrote a numbered , styled , step-by-step question , but I don't know why the site didn't add the question , I shocked ! , and this question is a vague , simple version of it for a test or maybe a path to follow , ]
Here I explain the question in other form , Really I want to target both , first the idea ( the general algorithm ) and second the more detailed & advanced loot into this case ,
I want to make a site with articles that offered , something like DeveloperFusion.com 's Articles section Some Info
database : Sql Server
Unicode : yes
Pictures : Yes
Styles : yes
Steps & Issues
- After inserting a new article via a web editor , How to store the new item e.g : add that as a new record in the articles table in a html formatted version with using Server.HtmlEncode method
2a. In this way , what should be the data format NCLOB - Text - NVarChar(Max) or ...
2b. I dont know is this a common pattern or silly one , but instead of passing it to a database make a webpage with the name of the desired page and add the article-contents to it
3.the way that the client can reach the address e.g domain.com/articles/6643/ if the storage option be SQL how can we pass the code of this article & show that as a webpage
this question isn't for getting code , is specially for knowing the strategy , algorithm and format