private static void DynamicQueryParser(
string serverAddress,
string database,
string UserId,
string Password,
string Query,
bool outputToCsv)
{
string ConnectionString = @"Data Source=" + serverAddress + ";Initial catalog=" + database + ";User ID=" +
UserId + ";Password="******";Persist Security Info=True;Impersonation Level=Impersonate";
var query = Query;
Console.WriteLine("About to connect to Analysis Services");
Console.WriteLine("{0} Date Time \n", DateTime.Now.ToString());
var adocon = new Microsoft.AnalysisServices.AdomdClient.AdomdConnection();
adocon.ConnectionString = ConnectionString;
var table = new System.Data.DataTable();
adocon.Open();
Console.WriteLine("Successfully Connected to Analysis Services");
Console.WriteLine("{0} Date Time \n", DateTime.Now.ToString());
var adoadapter = new Microsoft.AnalysisServices.AdomdClient.AdomdDataAdapter(query, adocon);
adoadapter.Fill(table);
var str = "";
foreach (System.Data.DataRow row in table.Rows)
{
var cnt = row.ItemArray.Count();
for (int i = 0; i < cnt; i++)
{
if (i == (cnt - 1))
{
str += row.ItemArray[i].ToString() + "\n";
}
else
{
str += row.ItemArray[i].ToString() + ",";
}
}
}
Console.WriteLine("Creating Stream Bytes");
Console.WriteLine("{0} Date Time \n", DateTime.Now.ToString());
byte[] bytes = Encoding.ASCII.GetBytes(str);
Console.WriteLine("Successfully created Stream Bytes");
Console.WriteLine("{0} Date Time \n", DateTime.Now.ToString());
var connectionstring = ConfigurationManager.ConnectionStrings["BlobStorage"].ConnectionString;
var dest = ConfigurationManager.AppSettings["dest"];
Task.Run(async() => await SaveTextAsBlobHelper(bytes, connectionstring)).Wait();
adocon.Close();
adocon.Dispose();
}
public void Dispose()
{
if (_type == AdomdType.AnalysisServices)
{
if (_conn != null)
{
_conn.Dispose();
_conn = null;
}
}
else
{
ExcelAdoMdConnections.VoidDelegate f = delegate
{
if (_connExcel != null)
{
_connExcel.Dispose();
_connExcel = null;
}
};
f();
}
}
public void Dispose()
{
if (_type == AdomdType.AnalysisServices)
{
if (_conn != null)
{
_conn.Dispose();
_conn = null;
}
}
else
{
void f()
{
if (_connExcel != null)
{
_connExcel.Dispose();
_connExcel = null;
}
}
f();
}
}