Azavea.Open.DAO.SQL.SqlConnectionUtilities.XSafeStringQuery C# (CSharp) Method

SqlConnectionUtilities Class Documentation Datei anzeigen Open project: azavea/net-dao

XSafeStringQuery() public static method

Similar to the "XSafeQuery" method, except this executes a query that returns a single string.

public static XSafeStringQuery ( AbstractSqlConnectionDescriptor connDesc, SqlTransaction transaction, string sql, IEnumerable sqlParams ) : string
connDesc	AbstractSqlConnectionDescriptor	The database connection descriptor. This is used both as /// a key for caching connections/commands as well as for /// getting the actual database connection the first time.
transaction	SqlTransaction	The transaction to do this as part of.
sql	string	The SQL query to execute.
sqlParams	IEnumerable	A list of objects to use as parameters /// to the SQL statement. The list may be /// null if there are no parameters.
return	string

        public static string XSafeStringQuery(AbstractSqlConnectionDescriptor connDesc,
            SqlTransaction transaction, string sql, IEnumerable sqlParams)
        {
            string retVal = null;
            object retObj = XSafeScalarQuery(connDesc, transaction, sql, sqlParams);
            try
            {
                // If it's null, retVal will stay null.
                if (retObj != null)
                {
                    retVal = retObj.ToString();
                }
            }
            catch (Exception e)
            {
                throw new UnableToProcessSqlResultsException("Result was not ToStringable. ",
                                                             connDesc, sql, sqlParams, e);
            }
            return retVal;
        }