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 vote121 views1 answer
Percentage random c#
C#
10 votes119 views5 answers
C# string[] to string
C#
2 votes150 views2 answers
Unity get all components in gameobject
C#Unity
-1 vote113 views1 answer
Page refresh on button click in c#
C#
0 vote160 views1 answer
How to use navmeshagent in unity
C#Unity
0 vote160 views1 answer
How to update custom package in unity
C#
28 votes115 views3 answers
C# system.io check if file exists
C#
2 votes76 views1 answer
How to add reference to rigidbody 2d
C#
0 vote119 views1 answer
Unity camera.main.screentoworldpoint(input.mouseposition) not working
C#
0 vote116 views1 answer
Windows 10 see how long a program has been running
C#