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

3 votes116 views2 answers
How to move mouse in c#
C#
0 vote166 views1 answer
How to disable all other components in gameobject in unity
C#Unity
0 vote124 views1 answer
How to declare variables in c#
C#
0 vote122 views2 answers
1.1 0da14962afa287e5ba55c7d30c902392.cloudfront.net w
C#
0 vote133 views1 answer
Dadar pincode
C#
3 votes123 views3 answers
C# array max
C#
0 vote127 views1 answer
How to round to nearest number in array c#
C#
1 vote128 views1 answer
Set particle system start colour + random between two
C#
2 votes118 views1 answer
How to change the position of a gameobject in c# unity
C#
5 votes133 views3 answers
Return view mvc
C#