public abstract object ExecuteScalar();
// execute a select command, return single result as a string public static string ExecuteScalar(DbCommand command) { string result = ""; command.Connection.Open(); result = command.ExecuteScalar().ToString(); return result; }