Azavea.Open.DAO.SQL.AbstractSqlConnectionDescriptor.MakeLastAutoGeneratedIdQuery C# (CSharp) Method

MakeLastAutoGeneratedIdQuery() public method

Gets the last id generated in an ID column for a table. Some databases can do this more efficiently or correctly than the default way ("select max idcol from table").
public MakeLastAutoGeneratedIdQuery ( string tableName, string idCol ) : string
tableName string The table the ID column belongs to.
idCol string The ID column for which to get the last generated ID value.
return string
        public virtual string MakeLastAutoGeneratedIdQuery(string tableName, string idCol)
        {
            StringBuilder sql = DbCaches.StringBuilders.Get();
            sql.Append("SELECT MAX(");
            sql.Append(idCol);
            sql.Append(") FROM ");
            sql.Append(tableName);
            string retVal = sql.ToString();
            DbCaches.StringBuilders.Return(sql);
            return retVal;
        }