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()); }