private void DoListTables(string[] tokens)
{
// use DatabaseName (not needed)
// select distinct name from sysobjects where xtype='U'
SqlConnection cn = DataModelBase.GetConnection();
SqlCommand cmd = new SqlCommand("select distinct name from sysobjects where xtype='U'", cn);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
PrintLine(rdr[0].ToString());
}
rdr.Close();
DataModelBase.FinishedWithConnection(cn);
}
private void DoSqlNonQueryCommand(string sqlCommand)
{
if (sqlCommand == null)
{
return;
}
Int32 rowsAffected;
SqlConnection cn = DataModelBase.GetConnection();
using (SqlCommand sqlCmd = cn.CreateCommand())
{
sqlCmd.CommandText = sqlCommand;
rowsAffected = sqlCmd.ExecuteNonQuery();
}
DataModelBase.FinishedWithConnection(cn);
OutputSqlNonQuery(rowsAffected != 0);
}
private void DoSqlReaderCommand(string sqlCommand)
{
if (string.IsNullOrEmpty(sqlCommand))
{
return;
}
var list = new List <SqlModel>();
SqlConnection cn = DataModelBase.GetConnection();
SqlCommand cmd = new SqlCommand(sqlCommand, cn);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
list.Add(new SqlModel(rdr));
}
rdr.Close();
DataModelBase.FinishedWithConnection(cn);
OutputSqlQuery(list.ToArray());
}
