public void PostGresSelectModel()
{
var conn = new Npgsql.NpgsqlConnection(ConfigurationManager.ConnectionStrings["postgres"].ConnectionString);
var scriptBuilder = conn.GetScriptBuild();
var cliente = new Cliente()
{
Nome = "Miranda"
};
var createTableScript = scriptBuilder.GetCreateTableCommand <Cliente>();
conn.Execute(createTableScript);
var id = conn.InsertReturningId <Cliente>(cliente);
var clientes = conn.GetAll <Cliente>();
Assert.AreEqual(1, clientes.Count());
Assert.AreEqual("Miranda", clientes.ToList()[0].Nome);
conn.Execute("drop table \"Cliente\"");
}