I am very interested in using Sitefinity but have a couple of questions
1) Would you recommend building a web application (not just website) using sitefinity as the base?
2) I am in the process of developing my db for my application. Would you recommend that I add my desired tables to the existing sitefinity database or use a seperate database for my app? So in short seperating the cms database with my app database.
3) My new app has a blogging feature. The table structure is similar to Sitefinity blogging table but requires some additional fields. Would you recommend that I add the required fields to the current SF blog table or create a new table entirely?
4) I have noticed that the db structure in SF does not have any relationships (Foreign Key) set up in the actual database. I was wondering why and if there are arguments for this approach and any against.
5)I have no experiance with the provider model so are there any tutorials you could direct me to with regards to extending the core modules with my own features? For instance i need additional fields for the forum so how would I go about extending the basic sitefinity forums for my needs. Please note I just need additional fields to extend the database.
6) I have two types of users for my web application. administrators that will be editing the contents of the site and members that will be utilising some of the mini apps that I will be building on my web site. So currently the idea is that the administrators login via the sitefinity login to administer the site and the members login through a custom login form but using a totally different table and custom code for authentication. Would you recommed that I use the built in membership provider instead? If so how would I go about doing this noting that the general members must have no access to the sitefinity cms side. I guess its the same logic that you run on your own Sitefinity website. I am a member and can participate on the forums but I guess there is no chance of me being able to login to SF and edit site content. Basically how did you approach this?