Serverless computing in Azure with .NET

Creating the TweetTextScore table

Since we didn't previously save the tweet scores at all, we will need to create a new SQL table.

Let's explore the following steps to create the TweetTextScore table:

1. Open the Visual Studio SQL Server Explorer and connect to the TextScoreDB database (alternatively, browse to Azure Portal and then navigate to SQL Databases -> TextScoreDB ->Tools -> Query Editor).
2. In the new query window, run the following code to create the TweetTextScore table that will store the tweet text and it's score:

        CREATE TABLE TweetTextScore        (          ID INT IDENTITY(1,1) PRIMARY KEY,          [Date] DATETIME NOT NULL DEFAULT GETUTCDATE(),          Username VARCHAR(255) NOT NULL,          TweetText VARCHAR(255) NOT NULL,          TextSentimentScore FLOAT NOT NULL       );