fixed a runtime error that happens when the format of the date is not the same as the current culture’s date format - added entry to IBatisNet.DataMapper.Test.dll.config called dateTimeFormat

mikhaild908@gmail.com · mikhaild908@gmail.com · commit 1620455e21b8 · 2013-06-20T19:40:46.000Z
diff --git a/src/IBatisNet.DataMapper.Test/bin/Debug/IBatisNet.DataMapper.Test.dll.config b/src/IBatisNet.DataMapper.Test/bin/Debug/IBatisNet.DataMapper.Test.dll.config
@@ -28,6 +28,7 @@
 		<!-- To test via Odbc provider (any database) value="Odbc"  -->
     <!-- To test via SQLIte 3 value=SQLite3 -->
 		<add key="providerType" value="SQLClient"/>
+    <add key="dateTimeFormat" value="yyyy-MM-dd H:mm:ss" />
 	</appSettings>
 
 	<iBATIS>
diff --git a/src/IBatisNet.DataMapper/Commands/DataReaderDecorator.cs b/src/IBatisNet.DataMapper/Commands/DataReaderDecorator.cs
@@ -26,6 +26,8 @@
 using System;
 using System.Data;
 using IBatisNet.DataMapper.Scope;
+using System.Configuration;
+using System.Globalization;
 
 namespace IBatisNet.DataMapper.Commands
 {
@@ -248,6 +250,13 @@ string IDataRecord.GetDataTypeName(int i)
         /// <exception cref="System.IndexOutOfRangeException">The index passed was outside the range of 0 through <see cref="P:System.Data.IDataRecord.FieldCount"></see>. </exception>
         DateTime IDataRecord.GetDateTime(int i)
         {
+            string dateTimeFormat = ConfigurationManager.AppSettings["dateTimeFormat"];
+
+            if (!string.IsNullOrWhiteSpace(dateTimeFormat))
+            {
+                return DateTime.ParseExact(_innerDataReader.GetString(i), dateTimeFormat, CultureInfo.InvariantCulture);
+            }
+            
             return _innerDataReader.GetDateTime(i);
         }
 
