MVC: PetaPoco Example

peta_poco.cs

[PetaPoco.TableName("People")]
[PetaPoco.PrimaryKey("Id")]
public class Person 
{
  public int Id { get; set; }
  // .. some other fields 
}

public ActionResult Create( Person person ) 
{
  var databaseContext = new PetaPoco.Database("QuantechConnectionString");

  databaseContext.Insert( person );

  return RedirectToAction("Index");
}

public ActionResult Update() 
{
  return View();
}

[HttpPost]
public ActionResult Update( int id, Person person )
{

  var databaseContext = new PetaPoco.Database("QuantechConnectionString");

  databaseContext.Update( person, id );

  // if you don't have attributes on models then you have to:
  databaseContext.Update("people", "id", person);

  return RedirectToAction("Index");
}