/// <summary>
/// Creates a person via SQL.
/// </summary>
/// <param name="name">The name.</param>
/// <param name="birthday">The birthday.</param>
/// <param name="currentJob">The current job.</param>
/// <returns></returns>
static Person CreatePersonSQL(string name, DateTime?birthday, Job currentJob)
{
string sql = string.Format("INSERT INTO montyTPerson (Name, Birthday, CurrentJob) VALUES ('{0}', null, {1});SELECT last_insert_id() AS 'Identity';", name, currentJob.Id);
ActiveRecordMaster.ExecuteNonQuery(sql);
return(null);
}
/// <summary>
/// Removes the data.
/// </summary>
static void RemoveData()
{
Output("Removing data");
ActiveRecordMaster.ExecuteNonQuery("DELETE FROM montyTDocument");
ActiveRecordMaster.ExecuteNonQuery("DELETE FROM montyTPerson");
ActiveRecordMaster.ExecuteNonQuery("DELETE FROM montyTJob");
Output("Data removed");
}
