Pragmatic Programmer

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]; }

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

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

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;

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

1) 오라클 환경변수 조회하기 select * from v$nls_parameters; 2) 날짜형식 변경하기 alter session set nls_date_format = 'YYYY-MM-DD'; //datefromat변경 alter session set nls_timestamp_format = 'YYYY-MM-DD HH:MI:SS'; // timestamp_format변경 3) 정상적으로 변경되었는지 확인 select * from emp where hiredate = '1981-02-22'; /*alter [session/system]  1. session : 현재접속한 session(쿼리)에서만 변경  2. system : database자체를 변경   scope=[both/spfile]   -both : 바로적용 또는 재시작(오류날 가능성이 높다)   -spfile : DB를 재시작후에 변경 */ **SQL Command Line으로 들어가서 system계정으로 접속해서 바꿔야 한다.(영구적 변경) alter system  set nls_date_format = 'YYYY-MM-DD'   scope=spfile; alter system  set nls_timestamp_format = 'YYYY-MM-DD HH:MI:SS'   scope=spfile; 4)sqlplus에 sys as sysdba 로 접속해서, shutdown immediate;startup; 실행

ODP.NET Tool for VS2015 설치 프로젝트에서 Install-Package Oracle.ManagedDataAccess.EntityFramework 설치 Model 추가 <참고> https://www.nuget.org/packages/Oracle.ManagedDataAccess.EntityFramework/ https://csharp.today/entity-framework-6-database-first-with-oracle/