FDO .NET API Reference Feature Data Objects

mgISQLCommand.h

Go to the documentation of this file.
00001 /*
00002 * Copyright (C) 2004-2006  Autodesk, Inc.
00003 * 
00004 * This library is free software; you can redistribute it and/or
00005 * modify it under the terms of version 2.1 of the GNU Lesser
00006 * General Public License as published by the Free Software Foundation.
00007 * 
00008 * This library is distributed in the hope that it will be useful,
00009 * but WITHOUT ANY WARRANTY; without even the implied warranty of
00010 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
00011 * Lesser General Public License for more details.
00012 * 
00013 * You should have received a copy of the GNU Lesser General Public
00014 * License along with this library; if not, write to the Free Software
00015 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA
00016 *
00017 */
00018 
00019 #pragma once
00020 
00021 #include "FDO\Commands\mgICommand.h"
00022 
00023 BEGIN_NAMESPACE_OSGEO_FDO_COMMANDS_SQL
00024 public __gc __interface ISQLDataReader;
00025 
00026 /// \ingroup (OSGeoFDOCommandsSQL)
00027 /// \interface OSGeo::FDO::Commands::SQL::ISQLCommand
00028 /// \brief
00029 /// The ISQLCommand interface defines the SQL command, which supports the
00030 /// execution of a SQL statement against an underlying RDBMS. Two execute
00031 /// methods are provided to distinguish between statements that return table data
00032 /// versus those that execute non query type operations.
00033 public __gc __interface ISQLCommand : public NAMESPACE_OSGEO_FDO_COMMANDS::ICommand
00034 {
00035 public:
00036     /// \brief
00037     /// Gets the SQL statement to be executed as a string.
00038     /// 
00039     /// \return
00040     /// Returns the SQL statement.
00041     /// 
00042     __property System::String* get_SQLStatement();
00043 
00044     /// \brief
00045     /// Sets the SQL statement to be executed as a string.
00046     /// 
00047     /// \param value 
00048     /// Input the SQL statement.
00049     /// 
00050     /// \return
00051     /// Returns nothing
00052     /// 
00053     __property System::Void set_SQLStatement(System::String* value);
00054 
00055     /// \brief
00056     /// Executes the SQL statement against the connection object and returns
00057     /// the number of rows affected.
00058     /// 
00059     /// \return
00060     /// Returns the number of rows affected.
00061     /// 
00062     System::Int32 ExecuteNonQuery();
00063 
00064     /// \brief
00065     /// Executes the SQL statement against the connection object and returns
00066     /// an ISQLDataReader.
00067     /// 
00068     /// \return
00069     /// Returns the data reader.
00070     /// 
00071     NAMESPACE_OSGEO_FDO_COMMANDS_SQL::ISQLDataReader* ExecuteReader();
00072 };
00073 
00074 END_NAMESPACE_OSGEO_FDO_COMMANDS_SQL
00075 
00076 

Comments or suggestions? Send us feedback.