private static string GetConnectionString(Guid organizationId)
{
string connectionString = null;
DatabaseTableAdapter adapter = null;
MasterDataSet.DatabaseDataTable table = null;
MasterDataSet.DatabaseRow row = null;
try
{
adapter = new DatabaseTableAdapter();
table = adapter.GetDatabaseByOrganizationId(organizationId);
row = table[0];
connectionString = CreateConnectionString(row.DatabaseName, row.UserName, row.Password, row.ServerName, row.ServerInstanceName, row.Port);
}
finally
{
if (adapter != null)
{
adapter.Dispose();
}
if (table != null)
{
table.Dispose();
}
}
return(connectionString);
}
private static MasterDataSet.DatabaseRow GetDatabaseRowByOrganizationId(Guid organizationId)
{
using (DatabaseTableAdapter adapter = new DatabaseTableAdapter())
{
MasterDataSet.DatabaseDataTable table = adapter.GetDatabaseByOrganizationId(organizationId);
return((table.Count > 0) ? table[0] : null);
}
}