deepikamm (1/31/2012)
To be more precise,I am expecting blogs or articles on these topics.(plz don't direct me to microsoft blogs:w00t:)
Every msdn article has provided well written examples also so they are the primary source to read. However, the third link in my first post is a good article about SP_ExecuteSQL. A good article on the same topic is todays topic on the SQLServerCentral home page (you missed :-P).
http://www.sqlservercentral.com/articles/nHibernate/86913/