public string ExecuteScalarString(IDbCommand command) { if (AutoOpenClose) { Open(); } command.Connection = SqlConnection; command.CommandTimeout = CommandTimeout; string result = DatabaseConverter.ToString(command.ExecuteScalar()); if (AutoOpenClose) { Close(); } return(result); }
public string ExecuteDataTableString(IDbCommand command) { DataTable dataTable = ExecuteDataTable(command); return(!HasRows(dataTable) ? string.Empty : DatabaseConverter.ToString(dataTable.Rows[0][0])); }