public when_querying_with_more_columns_than_what_is_being_mapped()
{
TestingUtils.PostgresCommand("DROP TABLE IF EXISTS skinny_testing");
TestingUtils.PostgresCommand("CREATE TABLE skinny_testing (title varchar(100), not_being_mapped varchar(200))");
TestingUtils.PostgresCommand("INSERT INTO skinny_testing (title) VALUES ('some testing')");
var connection = new Connection(Settings.ConnectionString);
var query = "SELECT * FROM skinny_testing where title = @title";
var parameters = new Dictionary <string, object>()
{
{ "title", "some testing" }
};
actual = connection.Query <SkinnyTestingDatabaseRecord>(query, parameters);
}
public when_executing_a_command_with_parameters()
{
var connection = new Connection(Settings.ConnectionString);
var dropTableCommand = "DROP TABLE IF EXISTS skinny_testing";
connection.Command(dropTableCommand, new Dictionary <string, object>());
var createTableCommand = "CREATE TABLE skinny_testing (title varchar(100))";
connection.Command(createTableCommand, new Dictionary <string, object>());
var insertCommand = "INSERT INTO skinny_testing (title) VALUES (@title)";
var parameters = new Dictionary <string, object>()
{
{ "title", "some testing" }
};
actual = connection.Command(insertCommand, parameters);
writtenToDatabase = TestingUtils.PostgresQuery("SELECT * FROM skinny_testing");
}
