public static Dictionary <string, sqlAvailableEndpoint> RefreshAvailableEndpoints()
{
var sql = sqlServerConnection.GetAppMetadataInstance();
var reader = sql.GetReader("odpdatasources", "Name,Description,Disclaimer", "");
var availableEndpoints = new Dictionary <string, sqlAvailableEndpoint>();
foreach (DataRow row in reader.Rows)
{
string desc = row[1].ToString();
string disc = row[2].ToString();
var endpoint = new sqlAvailableEndpoint {
alias = row[0].ToString(), description = !string.IsNullOrEmpty(desc) ? desc : "", disclaimer = !string.IsNullOrEmpty(desc) ? disc : "", storageaccountkey = "", storageaccountname = ""
};
availableEndpoints.Add(endpoint.alias, endpoint);
}
HttpContext.Current.Cache["AvailableEndpoints"] = availableEndpoints;
return(availableEndpoints);
}
public static Dictionary<string, sqlAvailableEndpoint> RefreshAvailableEndpoints()
{
var sql = sqlServerConnection.GetAppMetadataInstance();
var reader = sql.GetReader("odpdatasources", "Name,Description,Disclaimer", "");
var availableEndpoints = new Dictionary<string, sqlAvailableEndpoint>();
foreach (DataRow row in reader.Rows)
{
string desc = row[1].ToString();
string disc = row[2].ToString();
var endpoint = new sqlAvailableEndpoint { alias = row[0].ToString(), description = !string.IsNullOrEmpty(desc) ? desc : "", disclaimer = !string.IsNullOrEmpty(desc) ? disc : "", storageaccountkey = "", storageaccountname = "" };
availableEndpoints.Add(endpoint.alias, endpoint);
}
HttpContext.Current.Cache["AvailableEndpoints"] = availableEndpoints;
return availableEndpoints;
}
