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 vote117 views2 answers
System.Data.Entity.Core.EntityException: The underlying provider failed on Open
C#
0 vote114 views1 answer
C# handle single quote inside string
C#
1 vote96 views2 answers
C# for
C#
8 votes132 views2 answers
How to get parent gameobject in unity
C#
0 vote88 views1 answer
Close Form After fixed time
C#
1 vote106 views2 answers
Merge xml files into one c#
C#
0 vote94 views1 answer
C# datatable current row
C#
0 vote98 views1 answer
Finding minimum in c#
C#
4 votes95 views1 answer
Unity round float to nearest 10
C#
6 votes130 views1 answer
Unity call function on animation finish
C#Unity