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 vote275 views1 answer
ASP.Net MVC 5 datalist event trap to perform action
C#
0 vote316 views1 answer
Using Linq to get the last N elements of a collection? C#
C#
10 votes290 views4 answers
Unity rotate around point
C#
11 votes316 views3 answers
C# unity detect any keyboard input
C#Unity
1 vote283 views1 answer
Access a local varible in a different function C#
C#
0 vote352 views1 answer
Button color uwp c#
C#
0 vote291 views1 answer
Unity animation length
C#Unity
11 votes310 views1 answer
C# How to write Hello World
C#
0 vote358 views1 answer
CS0234 compile error c# unity fix scene managment
C#Unity
3 votes311 views1 answer
C# merging two arrays
C#