public async Task <string> GetConnectionString()
{
var builder = new SqlConnectionStringBuilder();
#region Build data source
var dataSouceBuilder = new StringBuilder(dbServerOptions.Server.Length + 10);
if (dbServerOptions.Protocol != null)
{
// Add protocol if configured
dataSouceBuilder.Append(dbServerOptions.Protocol);
dataSouceBuilder.Append(':');
}
dataSouceBuilder.Append(dbServerOptions.Server);
if (dbServerOptions?.Protocol == "tcp")
{
// Add port if configured
dataSouceBuilder.Append(',');
dataSouceBuilder.Append(dbServerOptions.TcpPort ?? 1433);
}
builder.DataSource = dataSouceBuilder.ToString();
builder.InitialCatalog = dbServerOptions.Database;
builder.UserID = dbServerOptions?.DbUser ?? "demo";
#endregion
if (keyVaultReader != null && keyVaultReader.IsAvailable)
{
builder.Password = await keyVaultReader.GetSecretAsync("DbPassword");
}
else
{
builder.Password = dbServerOptions.DbPassword;
}
return(builder.ToString());
}
public async Task SendRentalEndResult(RentalEndResult result)
{
var topicClient = new TopicClient(await keyVaultReader.GetSecretAsync("ServiceBus"), "bike-rental-end");
var message = new Message(Encoding.UTF8.GetBytes(JsonConvert.SerializeObject(result)));
await topicClient.SendAsync(message);
}