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