Example on basic http authentication in a Web API

Example on basic http authentication in a Web API

Can you get me example of basic http authentication in a Web API. I have
SQL Express and I need that this example create itself (first call) the
table on MSSQL.