public void InsertRow(string tableName, string columnNames, string values)
{
if (UnderlayingDatabase == null)
{
throw new InvalidOperationException("The Database is not created.");
}
UnderlayingDatabase.ExecSQL($"INSERT INTO {tableName} ({columnNames}) VALUES ({values});");
}
public void CreateTable(string tableName, string tableMap)
{
if (UnderlayingDatabase == null)
{
throw new InvalidOperationException("The Database is not created.");
}
UnderlayingDatabase.ExecSQL($"CREATE TABLE {tableName}({tableMap});");
}
public SQLiteCursor GetItem(string tableName, string command, string predicate = "")
{
if (UnderlayingDatabase == null)
{
throw new InvalidOperationException("The Database is not created.");
}
return((SQLiteCursor)UnderlayingDatabase.RawQuery($"SELECT {command} FROM {tableName}"
+ predicate == string.Empty ? ";" : ($" WHERE {predicate};"), null));
}
