'"SQLite warning (28): double-quoted string literal" in VisualStudio C#
Im using SQLite database System.Data.SQLite (NuGet package version 1.0.115.5). Every time i execute a database query, for example:
SELECT * FROM tasks WHERE parent_task=1073 LIMIT 1;
got 2 warnings in debug log:
SQLite warning (28): double-quoted string literal: "L"
SQLite warning (28): double-quoted string literal: "P"
But im not even using double quotes in my query. Is it a problem with sqlite or im missing something? Or maybe there is a way to disable sqlite warnings, because it generates a lot of garbage in my log.
Edit
c# code:
public static DataTable AsDataTable(this SelectWhere_Extends_SelectFrom q)
{
AASqlite sqlite = new();
SQLiteDataAdapter da = new($@"SELECT {q.column_list} FROM {q.table_name} WHERE {q.where} {q.limit};", sqlite.connection);
Debug.WriteLine(da.SelectCommand.CommandText);
DataTable ds = new();
da.Fill(ds);
return ds;
}
// AASQLite class
...
public AASqlite() => connection = new($"Data Source={G.DB_PATH}");
Edit 2
Edit 3
Tested it with simple static query. Even this throw warnings.
SQLiteConnection connection = new($"Data Source={G.DB_PATH}");
connection.Open();
new SQLiteCommand("select * from tasks", connection).ExecuteReader();
connection.Close();
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|


