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\""); }