System.Data.SQLite

Check-in [64d79942dc]
Login

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

Overview
Comment:no message
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | sourceforge
Files: files | file ages | folders
SHA1: 64d79942dc1b7688f5e05304aebad2c6eeac9ac2
User & Date: rmsimpson 2006-02-14 03:07:29.000
Context
2006-02-14
14:46
no message check-in: 7c412389c2 user: rmsimpson tags: sourceforge
03:07
no message check-in: 64d79942dc user: rmsimpson tags: sourceforge
2006-02-13
04:54
no message check-in: 3269002736 user: rmsimpson tags: sourceforge
Changes
Unified Diff Ignore Whitespace Patch
Changes to SQLite.Designer/SQLiteDataSourceInformation.cs.
32
33
34
35
36
37
38


39
40
41
      AddProperty(CatalogSupported, true);
      AddProperty(CatalogSupportedInDml, true);
      AddProperty(SchemaSupported, false);
      AddProperty(SchemaSupportedInDml, false);
      AddProperty(SchemaSeparator, "");
      AddProperty(ParameterPrefix, "@");
      AddProperty(ParameterPrefixInName, true);


    }
  }
}







>
>



32
33
34
35
36
37
38
39
40
41
42
43
      AddProperty(CatalogSupported, true);
      AddProperty(CatalogSupportedInDml, true);
      AddProperty(SchemaSupported, false);
      AddProperty(SchemaSupportedInDml, false);
      AddProperty(SchemaSeparator, "");
      AddProperty(ParameterPrefix, "@");
      AddProperty(ParameterPrefixInName, true);
      AddProperty("DeskTopDataSource", true);
      AddProperty("LocalDatabase", true);
    }
  }
}
Changes to System.Data.SQLite/SQLiteCommandBuilder.cs.
233
234
235
236
237
238
239




















240
241
242
243
244
245
246
        return base.QuoteSuffix;
      }
      set
      {
        base.QuoteSuffix = value;
      }
    }





















    /// <summary>
    /// Overridden to hide its property from the designer
    /// </summary>
#if !PLATFORM_COMPACTFRAMEWORK
    [Browsable(false)]
#endif







>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>







233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
        return base.QuoteSuffix;
      }
      set
      {
        base.QuoteSuffix = value;
      }
    }

    /// <summary>
    /// Not implemented
    /// </summary>
    /// <param name="unquotedIdentifier"></param>
    /// <returns></returns>
    public override string QuoteIdentifier(string unquotedIdentifier)
    {
      return unquotedIdentifier;
    }

    /// <summary>
    /// Not implemented
    /// </summary>
    /// <param name="quotedIdentifier"></param>
    /// <returns></returns>
    public override string UnquoteIdentifier(string quotedIdentifier)
    {
      return quotedIdentifier;
    }

    /// <summary>
    /// Overridden to hide its property from the designer
    /// </summary>
#if !PLATFORM_COMPACTFRAMEWORK
    [Browsable(false)]
#endif
Changes to System.Data.SQLite/SQLiteConnection.cs.
1153
1154
1155
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167

                      row["TABLE_CATALOG"] = strCatalog;
                      row["TABLE_NAME"] = rdTables.GetString(2);
                      row["INDEX_CATALOG"] = strCatalog;
                      row["INDEX_NAME"] = rd.GetString(1);
                      row["UNIQUE"] = rd.GetBoolean(2);
                      
                      if (rd.GetString(1).StartsWith(primaryKey, true, CultureInfo.InvariantCulture) == true)
                        row["PRIMARY_KEY"] = true;

                      tbl.Rows.Add(row);
                    }
                  }
                }
              }







|







1153
1154
1155
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167

                      row["TABLE_CATALOG"] = strCatalog;
                      row["TABLE_NAME"] = rdTables.GetString(2);
                      row["INDEX_CATALOG"] = strCatalog;
                      row["INDEX_NAME"] = rd.GetString(1);
                      row["UNIQUE"] = rd.GetBoolean(2);
                      
                      if (rd.GetString(1).StartsWith(primaryKey, StringComparison.InvariantCultureIgnoreCase))
                        row["PRIMARY_KEY"] = true;

                      tbl.Rows.Add(row);
                    }
                  }
                }
              }
Changes to System.Data.SQLite/SQLiteDataReader.cs.
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573

                      _command.Connection._sql.ColumnMetaData(
                (string)row[SchemaTableOptionalColumn.BaseCatalogName],
                (string)row[SchemaTableColumn.BaseTableName],
                strColumn,
                out dataType, out collSeq, out bNotNull, out bPrimaryKey, out bAutoIncrement);

                      if (bNotNull) row[SchemaTableColumn.AllowDBNull] = false;

                      row[SchemaTableColumn.IsKey] = bPrimaryKey;
                      row[SchemaTableOptionalColumn.IsAutoIncrement] = bAutoIncrement;

                      if (String.IsNullOrEmpty(dataType) == false)
                        row["DeclaredType"] = dataType;








|







559
560
561
562
563
564
565
566
567
568
569
570
571
572
573

                      _command.Connection._sql.ColumnMetaData(
                (string)row[SchemaTableOptionalColumn.BaseCatalogName],
                (string)row[SchemaTableColumn.BaseTableName],
                strColumn,
                out dataType, out collSeq, out bNotNull, out bPrimaryKey, out bAutoIncrement);

                      if (bNotNull || bPrimaryKey) row[SchemaTableColumn.AllowDBNull] = false;

                      row[SchemaTableColumn.IsKey] = bPrimaryKey;
                      row[SchemaTableOptionalColumn.IsAutoIncrement] = bAutoIncrement;

                      if (String.IsNullOrEmpty(dataType) == false)
                        row["DeclaredType"] = dataType;