Azure Autocomplete

This project shows how to create a .net core webapi and Azure Function backend to suggest addresses in a textbox using JQuery UI Autocomplete

There are three backend data stores:

• Microsoft SQL
• CosmosDB using the SQL API
• CosmosDB using the Mongo API (not used in the Azure Function)

The settings in appsettings.Development.json in the WebAPI and local.settings.json in the function contain settings to use a localdb for SQL and the Azure CosmosDB Emulator.

There is sample data in the Data directory. To load into each of the data stores:

1. For MS SQL, connect to a localdb (e.g. with Visual Studio SQL Server Object Explorer) and create a database called Addresses. Then in a query window, run the AddressData.sql file to create the table and add the sample data.
2. For CosmosDB with the SQL API, open the CosmosDB data explorer from the emulator, create a new container called StreetAddresses in a database called StreetAddressDb and then click the items under the new container, choose Upload Item and upload the AddressesData.json file from the Data directory.
3. For CosmosDB with the Mongo API, navigate to api/AddressValidator/cmongo in the web app which will create the database and table and then load the data found in AddressData.txt in the Data directory. For localhost in IIS this would be https://localhost:44316/api/AddressValidator/cmongo

To deploy to Azure,

1. Create CosmosDB SQL, CosmosDB Mongo, and Azure SQL databases and load the data as above.
2. Create a new App Service and then add App Settings in the Configuration settings for the connection strings to each of the datasources:
3. SqlConnectionString
4. CosmosSqlConnectionString
5. CosmosMongoConnectionString
6. Deploy the WebAPI code to the App Service (e.g. using Visual Studio)
7. Create a new Azure Functions resource and add App Settings in the Configuration settings for the connection strings to each of the datasources:
8. SqlConnectionString
9. CosmosSqlConnectionString
10. Enable CORS for * in the Function
11. Deploy the function code to the Azure Function (e.g. using Visual Studio)

To switch the UI between using the WebAPI and the Function, edit this line in index.html to either be empty (to use the WebAPI hosted with the html page) or to point to the Azure Function URL.

var apiUrl = "http://localhost:7071";