public void SetCredentialOData(string url, string userName, string password)
{
DataSource dataSource = new DataSource("OData", url);
if (userName == null)
{
DataSourceSetting dataSourceSetting = new DataSourceSetting("Anonymous");
CredentialStore.SetCredential(dataSource, dataSourceSetting, null);
}
else
{
var dataSourceSetting = DataSourceSetting.CreateUsernamePasswordCredential(userName, password);
CredentialStore.SetCredential(dataSource, dataSourceSetting, null);
}
return;
}
public void SetCredentialSQL(string sql, string userName, string password)
{
DataSource dataSource = new DataSource("SQL", sql);
if (userName == null)
{
DataSourceSetting dataSourceSetting = new DataSourceSetting("Windows");
CredentialStore.SetCredential(dataSource, dataSourceSetting, null);
}
else
{
var dataSourceSetting = DataSourceSetting.CreateUsernamePasswordCredential(userName, password);
CredentialStore.SetCredential(dataSource, dataSourceSetting, null);
}
return;
}