public string[] Process() { var connection = DataSource.InitializeConnection(_dataPath); SQLiteCommand command = null; if (connection != null) { command = connection.CreateCommand(); } var result = new string[0]; if (command != null) { command.CommandText = @" select word from autocompletion WHERE word LIKE @INPUT || '%' ORDER BY count DESC, word LIMIT @amount "; command.Parameters?.AddWithValue("@INPUT", _input); command.Parameters?.AddWithValue("@amount", 5); connection.Open(); using (var reader = command.ExecuteReader()) { if (reader != null) { var resultSet = new List <string>(); while (reader.Read()) { resultSet.Add(reader.GetString(0)); } result = resultSet.ToArray(); } } connection.Close(); } return(result); }
protected void SetupConnection(string dataPath) { _connection = DataSource.InitializeConnection(dataPath); }