A beautiful poem

BlogEngine is a powerful blogging engine and there may be situation in which you would like to use it for multiple websites but one database. One straight solution is to use different table prefix and specify the same in web.config file in appsettings. But I personally don’t like the idea of storing data in two different tables. Given the fact that I am using Asp.Net membership provider, I would like to leverage built in capabilities of membership provider to run two different applications having one single database. So here are the steps involved in running multiple sites with one database, assuming you are using Asp.Net membership provider.

Step1: Configure BlogEngine to use MSSQL and Asp.net membership provider

Users already using MSSQL provider can move to step 2 directly.

If you can access your hosted database remotely you can directly use the aspnet_regsql tool to install all required tables, views, storedprocedure etc. Otherwise use aspnet_regsql tool to create the database locally and then create a script necessary to create the tables, views and stored procedures etc so that the same may be run on the remote hosted site. To see step by step guide see this video

http://nyveldt.com/misc/BE13SQLMembership.html

After you have successfully configured to use MSSQL provider you will be able to see following page.

Step2: Configure BlogEngine to use ApplicationId across the application.

  2.1 Run the MultipleInstanceScript.Sql file. Be sure to check the application name by default it has name ‘BlogEngine’ If you have different application name change the string. The scripts add ApplicationId column to all the tables of BlogEngine.

  2.2 Include DbMultiBlogProvider.cs in your BlogEngine.Core/Providers/ Folder.

Change following settings in web.config file.

Note the extra applicationId attribute of DbMultiBlogProvider. Just check your aspnet_applications table and put the same applicationId value here. Well being lazy I have use ApplicationId instead of application name.

Add following values in Appsettings values

Here IsPrivateBlog attribute is used to identify if anonymous access is allowed or not. Comment explains everything.

That’s it.

If you want to deploy the same application with a different address Just create a new application through visual studio site administration tool and change the applicationId to the newly created applicationId. The script file and class file is attached with the post. In case you have any difficulty in setting up website do let me know.

Hope this helps.

Noesispedia_MultipleInstance_BlogEngine.zip (8.41 kb)

Session is very important state management tool in asp.net. You fill in this object with lots of user specific information when user requests a certain page e.g. Logged in user information like name, emailId etc can be stored after the sucessfull login. However for better performance we must make sure that all the objects are removed from the session when we don't need them. So question arises what's the best way to end user's session in case user logs out. Session object have two method implemented to straight away clear all the objects in session. those are...

 Session.Clear(), Session.RemoveAll()

 Eventually these two methods are serving the same purpose but I am still not able to figure out what's the difference between the two. Seems there is some legecy code left by microsoft developers :-). If you know the difference do let me know.

There is one other method called Abandon() which must be used in case user logs out. Abondon method marks the current session for deletion as soon as user moves to next page. So it is always good to use Session.Abandon() in the logout event. In this way the same session object can not be reused in subsequent request. Let's take an example

   1:   

   2:  Session["UserId"] = "user@noesispedia.com"

   3:  Session.Abandon()

   4:  Response.Write((string)Session["UserId"] )

Session is still accesible in this page however if you try to acess userId in next page it won't be available.

One more point I would like to make here i.e. Session_Start event will be raised in case session is abandoned however if you don't call abandon method and just use Clear() session object won't be destroyed even after logout and Session_Start event will not be fired as session still exists in memory. To summarize use

   1:   

   2:  Session.Clear()

   3:  Session.Abandon() 

   4:  //Redirect to logout page. 

This is part 2 of the Mantras for startup product presentation. The original link is

 http://www.techcrunch.com/2008/09/01/how-to-demo-your-startup-part-two/

and key points are

1. Show your product functionality instead of just telling what it does.
2. Use 'We' instead of 'You'
3. One driver, one navigator i.e. Presenter should have one other person to change slides/presentation
4. Know How to handle technical issues
5. Initial Setup, starting the presentation
6. How not to start your presentation
7. Describe your product n times.
8. Change your tone time to time

India is thrilled with the news about winning gold medal in Olympic Beijing 2008. Mr Abhinav Bindra bagged gold medal in the men's 10m air rifle event at the Beijing Olympics. He has become first indian to win a gold medal in Olympic games. I am so excited and so the whole nation. Kudos to Abhinav for his excellent performance and making the whole nation proud.

More about the golden man can be found at

http://en.wikipedia.org/wiki/Abhinav_Bindra

His personal blog

http://abhinavbindra.blogspot.com/