wkaczurba

SQL server

Setup -> TODO: record + provide a link

Connecting -> TODO: paste code

Connection strings:

Generating a connection string

Getting a connection string:

How to get connection string? using C#:

var _builder = new SqlConnectionStringBuilder();
_builder.DataSource = db_source;
_builder.UserID = db_user;
_builder.Password = db_password;
_builder.InitialCatalog = db_database;

return new SqlConnection(_builder.ConnectionString);

Or simply:

Or: "Data Source="+db_source+";Initial Catalog="+db_database+";User ID="+db_user+";Password=" + db_password;

Or: Data Source may be Server?:

"Server=tcp:"+db_source+"," + db_port + ";Initial Catalog="+db_database+";User ID="+db_user+";Password=" + db_password;

Setting connection string in WebApp:

https://www.udemy.com/course/azure-certification-1/learn/lecture/31939988#overview

Go into Application / Web App itself
Settings/Configuration blade

Setting connection string

Gotcha 1: Make sure you click this save button!

In the application itself:

Inject IConfiguration from Microsoft.Extensions.Configuration.Abstarct... and execute .getConnectionString(name-of-key)

Gotcha 2:

you need to deploy it as call from localhost to Azure portal will not work as expected!

Elastic pools

elastic pools are on a single server and share a se t number of resources at as set price

https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview?view=azuresql