C# sqlite query

public List<string> GetUsers()
{
	// Init return list
    List<string> users = new List<string>();

	// Set the path to sqlite file
    string solutionPath = Environment.CurrentDirectory;
	string dbPath = Path.Combine(solutionPath, "db.sqlite3");    

    SQLiteConnection connection = new SQLiteConnection(solutionPath);
    connect.Open();

	// Construct sql query
    SQLiteCommand command = connection.CreateCommand();
    command.CommandText = @"SELECT username FROM tableUsers";
    command.CommandType = CommandType.Text;

    SQLiteDataReader reader = command.ExecuteReader();

	// reader is treated like a array so call 
    while (reader.Read())
    	users.Add(Convert.ToString(reader["username"]));

	// Clean up no longer needed connection
	connection.Close();

    return users;
}

Similar codes

19 votes109 views6 answers
Property 'name' has no initializer and is not definitely assigned in the constructor.ts(2564)
C#
0 vote122 views1 answer
How to check if file contains image c#
C#
0 vote105 views1 answer
How to configure asp.net core on ionon 1&1 hosting
C#
1 vote103 views3 answers
Sort a dictionary by value in c#
C#
0 vote156 views1 answer
Unity occulision for hide something
C#Unity
0 vote108 views1 answer
Phone
C#
1 vote115 views1 answer
C# add time to datetime
C#
4 votes119 views2 answers
Dotnet install ef
C#
12 votes124 views2 answers
C# pick a random item from array
C#
0 vote117 views1 answer
Vb.net remove last comma from string
C#