wasCSharpSQLite – Rev 1

?pathlinks?

Go to most recent revision – Blame – Last modification – View Log – Download

//
// System.Data.Common.DbCommand
//
// Author:
//   Tim Coleman (tim@timcoleman.com)
//
// Copyright (C) Tim Coleman, 2003
//

//
// Copyright (C) 2004 Novell, Inc (http://www.novell.com)
//
// Permission is hereby granted, free of charge, to any person obtaining
// a copy of this software and associated documentation files (the
// "Software"), to deal in the Software without restriction, including
// without limitation the rights to use, copy, modify, merge, publish,
// distribute, sublicense, and/or sell copies of the Software, and to
// permit persons to whom the Software is furnished to do so, subject to
// the following conditions:
// 
// The above copyright notice and this permission notice shall be
// included in all copies or substantial portions of the Software.
// 
// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
// EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
// MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
// NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
// LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
// OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
// WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
//



using System.ComponentModel;
using System.Data;

namespace System.Data.Common {
        public abstract class DbCommand : IDbCommand, IDisposable
        {
                protected DbCommand ()
                {
                }

                #region Properties

                [DefaultValue ("")]
                public abstract string CommandText { get; set; }

                public abstract int CommandTimeout { get; set; }

                [DefaultValue (CommandType.Text)]
                public abstract CommandType CommandType { get; set; }

                [DefaultValue (null)]
#if !(WINDOWS_PHONE || NETFX_CORE)
                [Browsable (false)]
#endif
                public DbConnection Connection {
                        get { return DbConnection; }
                        set { DbConnection = value; }
                }

                protected abstract DbConnection DbConnection { get; set; }
                protected abstract DbParameterCollection DbParameterCollection { get; }
                protected abstract DbTransaction DbTransaction { get; set; }

                [EditorBrowsable (EditorBrowsableState.Never)]
#if !(WINDOWS_PHONE || NETFX_CORE)
                [Browsable (false)]
#endif
                [DefaultValue (true)]
                public abstract bool DesignTimeVisible { get; set; }

                IDbConnection IDbCommand.Connection {
                        get { return Connection; }
                        set { Connection = (DbConnection) value; }
                }

                IDataParameterCollection IDbCommand.Parameters {
                        get { return Parameters; }
                }

                IDbTransaction IDbCommand.Transaction {
                        get { return Transaction; }
                        set { Transaction = (DbTransaction) value; }
                }
#if !(WINDOWS_PHONE || NETFX_CORE)
                [Browsable (false)]
#endif
                public DbParameterCollection Parameters {
                        get { return DbParameterCollection; }
                }
#if !(WINDOWS_PHONE || NETFX_CORE)
                [Browsable (false)]
#endif
                [DefaultValue (null)]
                public DbTransaction Transaction {
                        get { return DbTransaction; }
                        set { DbTransaction = value; }
                }

        //[DefaultValue (UpdateRowSource.Both)]
        //public abstract UpdateRowSource UpdatedRowSource { get; set; }

                #endregion // Properties

                #region Methods

                public abstract void Cancel ();
                protected abstract DbParameter CreateDbParameter ();

                public DbParameter CreateParameter ()
                {
                        return CreateDbParameter ();
                }

                protected abstract DbDataReader ExecuteDbDataReader (CommandBehavior behavior);
                public abstract int ExecuteNonQuery ();
                
                public DbDataReader ExecuteReader ()
                {
                        return ExecuteDbDataReader (CommandBehavior.Default);
                }

                public DbDataReader ExecuteReader (CommandBehavior behavior)
                {
                        return ExecuteDbDataReader (behavior);
                }

                public abstract object ExecuteScalar ();

                IDbDataParameter IDbCommand.CreateParameter ()
                {
                        return CreateParameter ();
                }

                IDataReader IDbCommand.ExecuteReader ()
                {
                        return ExecuteReader ();
                }

                IDataReader IDbCommand.ExecuteReader (CommandBehavior behavior)
                {
                        return ExecuteReader (behavior);
                }

                public abstract void Prepare ();

        public void Dispose()
        {
            Dispose(true);
            GC.SuppressFinalize(this);
        }

        // <summary>
        //   Controls disposal of resources used by this.
        // </summary>
        //
        // <param name="release_all"> Controls which resources are released</param>
        //
        // <remarks>
        //   if release_all is set to true, both managed and unmanaged
        //   resources should be released.  If release_all is set to false,
        //   only unmanaged resources should be disposed
        // </remarks>
        protected virtual void Dispose(bool release_all)
        {
            //if (release_all)
            //{
            //    if (mySite != null && mySite.Container != null)
            //        mySite.Container.Remove(this);
            //    EventHandler eh = (EventHandler)Events[disposedEvent];
            //    if (eh != null)
            //        eh(this, EventArgs.Empty);
            //}
        }

                
                #endregion // Methods

        }
}