Implemented SQLManager with access token authentication.

2 files changed, 38 insertions, 0 deletions

diff --git a/Software/Visual_Studio/Tango.Web/SQLServer/SQLServerManager.cs b/Software/Visual_Studio/Tango.Web/SQLServer/SQLServerManager.cs
new file mode 100644
index 000000000..55d18d119
--- /dev/null
+++ b/Software/Visual_Studio/Tango.Web/SQLServer/SQLServerManager.cs
@@ -0,0 +1,37 @@
+using Microsoft.IdentityModel.Clients.ActiveDirectory;
+using System;
+using System.Collections.Generic;
+using System.Data.SqlClient;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace Tango.Web.SQLServer
+{
+    public class SQLServerManager
+    {
+        private String _service_root = $"https://login.microsoftonline.com/{WebConfig.TENANT_ID}";
+
+        public String GetAccessToken()
+        {
+            var authContext = new AuthenticationContext(_service_root);
+            ClientCredential clientCredentials = new ClientCredential(WebConfig.CLIENT_ID, WebConfig.APP_SECRET);
+            AuthenticationResult authResult = authContext.AcquireToken("https://database.windows.net/", clientCredentials);
+            return authResult.AccessToken;
+        }
+
+        public SqlConnection CreateSqlConnection(String accessToken, String catalog)
+        {
+            SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
+            builder.DataSource = "twine.database.windows.net";
+            builder.InitialCatalog = catalog;
+            builder.MultipleActiveResultSets = true;
+            builder.ApplicationName = "EntityFramework";
+
+            SqlConnection sqlConnection = new SqlConnection(builder.ConnectionString);
+            sqlConnection.AccessToken = accessToken;
+
+            return sqlConnection;
+        }
+    }
+}
diff --git a/Software/Visual_Studio/Tango.Web/Tango.Web.csproj b/Software/Visual_Studio/Tango.Web/Tango.Web.csproj
index 0f04121d1..d9a1d1dd1 100644
--- a/Software/Visual_Studio/Tango.Web/Tango.Web.csproj
+++ b/Software/Visual_Studio/Tango.Web/Tango.Web.csproj
@@ -247,6 +247,7 @@
     <Compile Include="Authentication\TokensManager.cs" />
     <Compile Include="DeploymentSlot.cs" />
     <Compile Include="Logging\AzureCloudLogger.cs" />
+    <Compile Include="SQLServer\SQLServerManager.cs" />
     <Compile Include="Storage\ExtensionMethods.cs" />
     <Compile Include="Storage\StorageManager.cs" />
     <Compile Include="TangoWebApplication.cs" />