Pattern design for Webapi project

Question

I need to create a project with Webapi to consume some procedures of a remote SQL database, for example: sp_retornaProdutos(1) turning that into /produtos/1 and returning the result in JSON.

I thought of creating models of request and sponse, thus:

// Model para envio de parâmetros
public class ProdutoReq
{
    int id;
}

// Model para retorno do resultado
public class ProdutoRes
{
    int id;
    string nome;
    string descricao;
    decimal preco;
}

I would like to know how you indicate to build this application, what design standard to use?

Answer 1

You can use the Slim Framework it is a micro framework developed in php.

Example of use:

$app = new \Slim\Slim();
$app->get('/hello/:name', function ($name) {
    echo "Hello, $name";
});

$app->run();

Where this echo you can put your SQL to give a return. when calling the api, more documentation on: Docs.Slim

and a how to Learn how to use Restful with PHP and Slim Framework