Index: Doc/Extra/Provider/version.html
==================================================================
--- Doc/Extra/Provider/version.html
+++ Doc/Extra/Provider/version.html
@@ -46,10 +46,11 @@
1.0.93.0 - June XX, 2014 (release scheduled)
- Updated to SQLite 3.8.4.3.
- Add support for mapping transaction isolation levels to their legacy default values. Pursuant to [56b42d99c1].
- Add support for setting the default DbType and type name used for mappings on a per-connection basis. Pursuant to [3c00ec5b52].
+ - Add DetectTextAffinity connection flag to enable automatic detection of column affinities, when necessary. Pursuant to [3c00ec5b52].
- Add SetChunkSize method to the SQLiteConnection class. Pursuant to [d1c008fa0a].
- Make the ISQLiteSchemaExtensions interface public. ** Potentially Incompatible Change **
- Have the SQLiteProviderFactory class (in the System.Data.SQLite.Linq assembly) implement the IServiceProvider interface.
- Fix bug in documentation generator automation that prevented some internal documentation links from working.
Index: System.Data.SQLite/SQLiteBase.cs
==================================================================
--- System.Data.SQLite/SQLiteBase.cs
+++ System.Data.SQLite/SQLiteBase.cs
@@ -1064,18 +1064,18 @@
/// closest supported transaction isolation level.
///
MapIsolationLevels = 0x1000000,
///
- /// When returning column values, attempt to map textual values
- /// onto fully conforming values of
+ /// When returning column values, attempt to detect the affinity of
+ /// textual values to see if they fully conform to those of the
/// ,
/// ,
/// ,
- /// or .
+ /// or types.
///
- MapTextToAffinity = 0x2000000,
+ DetectTextAffinity = 0x2000000,
///
/// When binding parameter values or returning column values, always
/// treat them as though they were plain text (i.e. no numeric,
/// date/time, or other conversions should be attempted).
Index: System.Data.SQLite/SQLiteDataReader.cs
==================================================================
--- System.Data.SQLite/SQLiteDataReader.cs
+++ System.Data.SQLite/SQLiteDataReader.cs
@@ -1134,12 +1134,12 @@
return _keyInfo.GetValue(i - VisibleFieldCount);
SQLiteConnectionFlags flags = SQLiteCommand.GetFlags(_command);
SQLiteType typ = GetSQLiteType(flags, i);
- if (((flags & SQLiteConnectionFlags.MapTextToAffinity) == SQLiteConnectionFlags.MapTextToAffinity) &&
- (typ != null) && (typ.Affinity == TypeAffinity.Text))
+ if (((flags & SQLiteConnectionFlags.DetectTextAffinity) == SQLiteConnectionFlags.DetectTextAffinity) &&
+ ((typ == null) || (typ.Affinity == TypeAffinity.Text)))
{
typ = GetSQLiteType(
typ, _activeStatement._sql.GetText(_activeStatement, i));
}
@@ -1430,11 +1430,11 @@
///
///
/// The SQLiteType structure.
///
private SQLiteType GetSQLiteType(
- SQLiteType oldType,
+ SQLiteType oldType, /* PASS-THROUGH */
string text
)
{
if (SQLiteConvert.LooksLikeNull(text))
return new SQLiteType(TypeAffinity.Null, DbType.Object);
Index: readme.htm
==================================================================
--- readme.htm
+++ readme.htm
@@ -213,10 +213,11 @@
- Updated to SQLite 3.8.4.3.
- Add support for mapping transaction isolation levels to their legacy default values. Pursuant to [56b42d99c1].
- Add support for setting the default DbType and type name used for mappings on a per-connection basis. Pursuant to [3c00ec5b52].
+ - Add DetectTextAffinity connection flag to enable automatic detection of column affinities, when necessary. Pursuant to [3c00ec5b52].
- Add SetChunkSize method to the SQLiteConnection class. Pursuant to [d1c008fa0a].
- Make the ISQLiteSchemaExtensions interface public. ** Potentially Incompatible Change **
- Have the SQLiteProviderFactory class (in the System.Data.SQLite.Linq assembly) implement the IServiceProvider interface.
- Fix bug in documentation generator automation that prevented some internal documentation links from working.
Index: www/news.wiki
==================================================================
--- www/news.wiki
+++ www/news.wiki
@@ -7,10 +7,11 @@
- Updated to SQLite 3.8.4.3.
- Add support for mapping transaction isolation levels to their legacy default values. Pursuant to [56b42d99c1].
- Add support for setting the default DbType and type name used for mappings on a per-connection basis. Pursuant to [3c00ec5b52].
+ - Add DetectTextAffinity connection flag to enable automatic detection of column affinities, when necessary. Pursuant to [3c00ec5b52].
- Add SetChunkSize method to the SQLiteConnection class. Pursuant to [d1c008fa0a].
- Make the ISQLiteSchemaExtensions interface public. ** Potentially Incompatible Change **
- Have the SQLiteProviderFactory class (in the System.Data.SQLite.Linq assembly) implement the IServiceProvider interface.
- Fix bug in documentation generator automation that prevented some internal documentation links from working.