System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: ff163eb3d8a7cfa4a2497e5b5ecd4344686d6629
Title: Documentation for SQLiteConnection.Schema_Columns() faulty
Status: Closed Type: Documentation
Severity: Minor Priority: Blocker
Subsystem: Connection Resolution: Fixed
Last Modified: 2017-10-19 17:27:07
Version Found In:
User Comments:
anonymous added on 2017-10-19 13:02:10:
I think that the doc comment "<param name="strTable">The table to retrieve schema information for, must not be null</param>" of SQLiteConnection.Schema_Columns(string strCatalog, string strTable, string strColumn) is not correct, as strTable *can* be null. 
The check happens here:
if (String.IsNullOrEmpty(strTable) || String.Compare(strTable, rdTables.GetString(2), StringComparison.OrdinalIgnoreCase) == 0)
{ 
    ....
So the method call mySQLiteConnection.GetSchema("Columns", new string[] { null, null, "MY_COLUMN" }) works like most other ADO.NET implementations and returns information about every "MY_COLUMN" column in the database.

mistachkin added on 2017-10-19 17:27:07:
Fixed on trunk via check-in [7632e932f50e36d8].