private List <Dictionary <string, Object> > RetriveFromTableInternal(string tableName, int id, AdditionalDataFlags additionalDataFlag)
{
List <Dictionary <string, Object> > ret = new List <Dictionary <string, Object> >();
Action act = () =>
{
_connection.Open();
if (id > -1)
{
_command.CommandText = $"SELECT * FROM {tableName} WHERE ID = {id}";
}
else
{
_command.CommandText = $"SELECT * FROM {tableName}";
}
using (SqliteDataReader reader = _command.ExecuteReader())
{
while (reader.Read())
{
var dict = BuildDictionary(reader);
ret.Add(dict);
if (id > -1)
{
break;
}
}
};
_connection.Close();
};
ProcessExceptions(act);
return(ret);
}
public List <Dictionary <string, Object> > RetriveAllFromTableWithAdditionalData(string tableName, int ID, AdditionalDataFlags additionalDataFlag)
{
return(RetriveFromTableInternal(tableName, ID, additionalDataFlag));
}
