To use IIS as redmine proxy

이미지
You should reboot pc after installing URLRewrite. Origin

Tips about .net XmlSerialization with derived types

If types are scattered over assemblies, impose same namespace with XmlRootAttribute If derived types are, supply XmlSerializer with ExtraTypes information.

From DataTable to POCO via AutoMapper

http://stackoverflow.com/questions/16222313/how-to-use-automapper-to-map-a-datarow-to-an-object-in-a-wcf-service public static Customer GetSingle(DataTable dt) { if (dt.Rows.Count > 0) return null; List<Customer> c = AutoMapper.Mapper.DynamicMap<IDataReader, List<Customer>>(dt.CreateDataReader()); return c[0]; }

Check Oracle's collation

SELECT * from NLS_DATABASE_PARAMETERS WHERE parameter IN ( 'NLS_LANGUAGE', 'NLS_TERRITORY', 'NLS_CHARACTERSET', 'NLS_SORT', 'NLS_LANG');

Setting Account in asp.net and IIS

http://www.iis.net/learn/manage/configuring-security/application-pool-identities

Create linked server to Oracle

EXEC master.dbo.sp_MSset_oledb_prop N'OraOLEDB.Oracle', N'AllowInProcess', 1; EXEC sp_addlinkedserver @server = 'XE', @srvproduct = 'Oracle', @provider = 'OraOLEDB.Oracle', @datasrc = '//localhost/orcl'; Exec sp_serveroption 'XE' , 'rpc' , TRUE; Exec sp_serveroption 'XE' , 'data access' , TRUE; Exec sp_serveroption 'XE' , 'rpc out' , TRUE; EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'XE', @useself = N'False', @rmtuser = N'jjs', @rmtpassword = N'jjs'; SELECT * FROM OPENQUERY(XE,'SELECT * FROM test_Tbl where p2  < 1000 and reg_dt >=' || '2012-10-01'); select * from [XE]..JJs.TEST_TBL;

Oracle NLS_LANG

Arabic  ARABIC_UNITED ARAB EMIRATES.AR8MSWIN1256 Windows면 registry에 기본값 설정 할 수 있다. https://docs.oracle.com/cd/B28359_01/win.111/b32010/registry.htm https://docs.oracle.com/cd/A83908_02/NT816EE/DOC/nt.816/a73010/apb.htm