private bool CheckIfRowExists()
{
try
{
List <ISQLiteRow> rowsToCompare = ExecuteOnTable.GetAll();
foreach (ISQLiteRow row in rowsToCompare)
{
if (RowToInsert.Equals(row))
{
return(true);
}
}
return(false);
}
catch
{ return(false); }
}
private void CodeToExecute()
{
var connection = ExecuteOnTable.Provider.CreateConnection();
connection.Open();
SQLiteCommand cmd = new SQLiteCommand($"INSERT INTO '{ExecuteOnTable.TableName}' ({RowToInsert.GetPropertiesToString()}) VALUES ({RowToInsert.GetValuesToString()});", (SQLiteConnection)connection);
cmd.ExecuteNonQuery();
SQLiteCommand getID = new SQLiteCommand("SELECT last_insert_rowid();", (SQLiteConnection)connection);
int lastID = Convert.ToInt32(getID.ExecuteScalar());
RowToInsert.Id = lastID;
connection.Close();
}
