private string getTables(string table)
{
var q = EmbeddedResourceHelper.GetResource("TableInfo.sql");
using (var conn = openConnection())
{
var cmd = new SqlCommand(q, conn);
if (!string.IsNullOrWhiteSpace(table))
{
cmd.Parameters.Add(new SqlParameter("TableQuery", table));
}
else
{
cmd.Parameters.Add(new SqlParameter("TableQuery", DBNull.Value));
}
var da = new SqlDataAdapter();
da.SelectCommand = cmd;
var dt = new DataTable();
da.Fill(dt);
return(dt.ToConsoleTable());
}
}
private string executeEmbedded(string filename)
{
var q = EmbeddedResourceHelper.GetResource(filename);
return(query(q).ToConsoleTable());
}
