System.Data.SQLite
Check-in [1045ef98f0]
Not logged in

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Change the default base schema name from 'sqlite_schema_stub' to 'sqlite_default_schema'.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | tkt-343d392b51
Files: files | file ages | folders
SHA1: 1045ef98f0d1db8b1063de67a75ad78dba1f3c7d
User & Date: mistachkin 2011-10-09 04:08:02
Context
2011-10-09
04:13
Add comments to the getDateTimeFormat unit testing infrastructure procedure to clarify how the default format was chosen. check-in: 1b25ba72a3 user: mistachkin tags: tkt-343d392b51
04:08
Change the default base schema name from 'sqlite_schema_stub' to 'sqlite_default_schema'. check-in: 1045ef98f0 user: mistachkin tags: tkt-343d392b51
03:56
Add test to check if SQLiteCommandBuilder generates correct SQL when attached databases are being used and more than one database contains the same table name. check-in: 74a9c16715 user: mistachkin tags: tkt-343d392b51
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to System.Data.SQLite/SQLiteConnection.cs.

    61     61     /// <item>
    62     62     /// <description>BaseSchemaName</description>
    63     63     /// <description>Some base data classes in the framework (e.g. those that build SQL queries dynamically)
    64     64     /// assume that an ADO.NET provider cannot support an alternate catalog (i.e. database) without supporting
    65     65     /// alternate schemas as well; however, SQLite does not fit into this model.  Therefore, this value is used
    66     66     /// as a placeholder and removed prior to preparing any SQL statements that may contain it.</description>
    67     67     /// <description>N</description>
    68         -  /// <description>sqlite_schema_stub</description>
           68  +  /// <description>sqlite_default_schema</description>
    69     69     /// </item>
    70     70     /// <item>
    71     71     /// <description>BinaryGUID</description>
    72     72     /// <description><b>True</b> - Store GUID columns in binary form<br/><b>False</b> - Store GUID columns as text</description>
    73     73     /// <description>N</description>
    74     74     /// <description>True</description>
    75     75     /// </item>
................................................................................
   166    166     /// </list>
   167    167     /// </remarks>
   168    168     public sealed partial class SQLiteConnection : DbConnection, ICloneable
   169    169     {
   170    170       /// <summary>
   171    171       /// The default "stub" (i.e. placeholder) base schema name to use when
   172    172       /// returning column schema information.  Used as the initial value of
   173         -    /// the BaseSchemaName property.
          173  +    /// the BaseSchemaName property.  This should start with "sqlite_*"
          174  +    /// because those names are reserved for use by SQLite (i.e. they cannot
          175  +    /// be confused with the names of user objects).
   174    176       /// </summary>
   175         -    private const string DefaultBaseSchemaName = "sqlite_schema_stub";
          177  +    private const string DefaultBaseSchemaName = "sqlite_default_schema";
   176    178   
   177    179       private const int SQLITE_FCNTL_WIN32_AV_RETRY = 9;
   178    180   
   179    181       private const string _dataDirectory = "|DataDirectory|";
   180    182       private const string _masterdb = "sqlite_master";
   181    183       private const string _tempmasterdb = "sqlite_temp_master";
   182    184