public Airport GetAirport(long id)
{
return((Airport)AdoTemplate.QueryForObject(CommandType.Text,
"SELECT * FROM airport WHERE id = @id",
airportMapper, "id", DbType.Int32, 0, id));
//
//return (Airport) QueryForEntity("SELECT * FROM airport WHERE id = @id", id, this.airportMapper);
}
public User get(int id)
{
IDbParametersBuilder builder = CreateDbParametersBuilder();
builder.Create().Name("id").Type(DbType.Int32).Value(id);
return(AdoTemplate.QueryForObject(CommandType.Text, @"SELECT * FROM tb_user WHERE id = :id", new Tb_userRowMapper(), builder.GetParameters()) as User);
}
public Airport GetAirport(string code)
{
return((Airport)AdoTemplate.QueryForObject(CommandType.Text,
"SELECT * FROM airport WHERE code = @code",
airportMapper, "code", DbType.String, 0, code));
/*
* IDbCommand command = GetCommand("SELECT * FROM airport WHERE code = @code");
* IDbDataParameter parameter = command.CreateParameter();
* parameter.ParameterName = "@code";
* parameter.DbType = DbType.String;
* parameter.Value = code;
* command.Parameters.Add(parameter);
* return (Airport) QueryForEntity(command, this.airportMapper);
*/
}
public TestObject FindOne()
{
return(AdoTemplate.QueryForObject(CommandType.Text,
"",
new TestObjectRowMapper()));
}
public Customer GetCustomer(string contactName)
{
return(AdoTemplate.QueryForObject(CommandType.Text, cmdText,
new CustomerRowMapper <Customer>(),
"ContactName", DbType.String, 30, contactName));
}
public Aircraft GetAircraft(long id)
{
return((Aircraft)AdoTemplate.QueryForObject(CommandType.Text, SingleAircraftById, aircraftMapper,
"id", DbType.Int32, 0, id));
}