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

0 vote175 views1 answer
C# console app how to run another program
C#
0 vote197 views1 answer
OIUJHKJHSKAL::KSAJ
C#
29 votes230 views5 answers
Random string generator c#
C#
3 votes133 views2 answers
Remove duplicate char from string c#
C#
0 vote188 views1 answer
C# moq task return null
C#
40 votes205 views5 answers
C# foreach dictionary
C#
2 votes227 views4 answers
C# Base64 Decode
C#
0 vote199 views1 answer
Add css class based on model value razor
C#
1 vote177 views1 answer
Search a value into a list int list in c#
C#
1 vote187 views1 answer
.net create ienumerable of strings
C#