My Blog

All about my activities, Ideas and everything.

Month: September, 2008

Oracle with GUID

Have you ever wanted to know that how Oracle generate GUID? This is the answer. I found this website shows how to use Oracle to generate GUID for us. http://feuerthoughts.blogspot.com/2006/02/watch-out-for-sequential-oracle-guids.html This is the code SQL Package CREATE OR REPLACE PACKAGE guid_pkg IS SUBTYPE guid_t IS RAW (16); SUBTYPE formatted_guid_t IS VARCHAR2 (38); – Example: {34DC3EA7-21E4-4C8A-BAA1-7C2F21911524} [...]

NHibernate : Improving performance

Just add the key into App.config CODE <add key=”hibernate.default_schema” value=”trinop.dbo”/> This key will help NHibernate not to look which is the schema of the database again.