C# DbCommand.ExecuteNonQuery方法代码示例

    public datacontrol(String path)
    {
        bool flag;
        if(File. Exists(path)){
            flag=false;
        }else{
            flag=true;
        }
        SQLiteConnection con = new SQLiteConnection ("Data Source="+path);
        str = path;
        con.Open();
        connection=con;
        cmd=new SQLiteCommand(con);
        if(flag){
            cmd.CommandText="create table driver(driverid varchar PRIMARY KEY,personid varchar not null,sex bool not null,name varchar not null,birthday char(8) not null,password varchar not null)";
            cmd.ExecuteNonQuery();

            cmd.CommandText="create table adminstrator (id varchar PRIMARY KEY,password varchar not null)";
            cmd.ExecuteNonQuery();
            cmd.CommandText="insert into adminstrator values(\'adminstrator\',\'1234\')";
            cmd.ExecuteNonQuery();

            cmd.CommandText="create table car(carid varchar primary key,caryear int,avaliable bool,insurancen bool,yearcheck bool)";
            cmd.ExecuteNonQuery();

            cmd.CommandText="create table contract(carid varchar,driverid varchar,startdate int,enddate int,isagree bool,isvalid bool,PRIMARY KEY(carid,driverid,startdate))";
            cmd.ExecuteNonQuery();
            //TODO create the table
        }
    }

        /// <summary>
        /// 初次使用创建数据库
        /// </summary>
        public static void CreateDataBase()
        {
            try
            {
                bool isExist = File.Exists(DataPath);
                if (!isExist)
                {
                    SQLiteConnection.CreateFile(DataPath);
                }
                conn = new SQLiteConnection(ConnStr);
                conn.Open();
                comm = conn.CreateCommand();
                if (!isExist)
                {
                    String sql = "Create table ReceiveData(DeviceNum INTEGER , Temperature INTEGER , Humidity INTEGER , Tyrere INTEGER , MotorState INTEGER , ErrorNum INTEGER , CreateDate DateTime);";
                    comm.CommandText = sql;
                    comm.CommandType = CommandType.Text;
                    comm.ExecuteNonQuery();
                }
            }
            catch (Exception e)
            {

            }
        }

        /// <summary>
        /// Drops the DemoTable.
        /// </summary>
        /// <param name="command">A command attached to a connection</param>
        private void ExecuteDropDemoTable(DbCommand command)
        {
            Console.WriteLine("Removing DemoTable..");

            command.CommandText = "DROP TABLE DemoTable";
            command.ExecuteNonQuery();
        }

 // execute an update, delete, or insert command
 // and return the number of affected rows
 public static int ExecuteNonQuery(DbCommand command)
 {
     // The number of affected rows
     int affectedRows = -1;
     // Execute the command making sure the connection gets closed in the end
     try
     {
       // Open the connection of the command
       command.Connection.Open();
       // Execute the command and get the number of affected rows
       affectedRows = command.ExecuteNonQuery();
     }
     catch (Exception ex)
     {
       // Log eventual errors and rethrow them
       //Utilities.LogError(ex);
       throw ex;
     }
     finally
     {
       // Close the connection
       command.Connection.Close();
     }
     // return the number of affected rows
     return affectedRows;
 }

 public static int ExecuteNonQuery(DbCommand cmd)
 {
     using (DbConnection connection = GetConnection())
     {
         cmd.Connection = connection;
         return cmd.ExecuteNonQuery();
     }
 }

    public static int ExecuteNonQuery(DbCommand command)
    {
        int result = -1;

        command.Connection.Open();
        result = command.ExecuteNonQuery();

           return result;
    }

        // insert update delete command
        // return no of affected rows
        public static int ExecuteNonQuery(DbCommand command)
        {
            int affectedRows = -1;

            command.Connection.Open();
            affectedRows = command.ExecuteNonQuery();

            return affectedRows;
        }

        public int ExecNonQuery(DbCommand cm)
        {
            //OnExecuting(ExecTypes.NonQuery, cm);

            int r = cm.ExecuteNonQuery();

            //OnExecuted(ExecTypes.NonQuery, cm, r);
            return r;
        }

        /// <summary>
        /// Will execute the given command on the database
        /// </summary>
        /// <param name="command">The command to execute</param>
        protected void ExecuteCommand(DbCommand command)
        {
            bool doClose = InitializeConnection(ref command);

            command.ExecuteNonQuery();

            if (doClose)
                Connection.Close();
        }

 protected override object ExecuteResultInternal(IDbExecuteContext ctx, DbCommand command, Type resultType, object resultInstance)
 {
     var affectedRows = command.ExecuteNonQuery();
     //判断是否是存储过程，是则需要处理输出参数和返回参数
     if(command.CommandType == CommandType.StoredProcedure) {
         var result = this.HandleOutputOrReturnValue(ctx, resultType, resultInstance, command, affectedRows);
         return result;
     }
     return affectedRows;
 }

 public static int ExecuteNonQuery(DbCommand cmd)
 {
     using(SqlCeConnection conn = new SqlCeConnection(DBHelper.GetConnectionString()))
     {
         PrepareCommand(cmd, conn, null);
         int val = cmd.ExecuteNonQuery();
         cmd.Parameters.Clear();
         return val;
     }
 }

        public void ExecuteNonQuery(DbCommand command)
        {
            using (var connection = new SQLiteConnection(_connectionString))
            {
                command.Connection = connection;

                connection.Open();
                command.ExecuteNonQuery();
            }
        }

    public static bool ExecuteNonQuery(DbCommand comm)
    {
        int i = -1;

        comm.Connection.Open();
        i = comm.ExecuteNonQuery();
        comm.Connection.Close();

        return i > 0;
    }

        protected int ExecuteNonQuery(DbCommand command)
        {
            this.AbrirConexao();

            command.Connection = this.Conexao;

            var resultado = command.ExecuteNonQuery();

            this.FecharConexao();

            return resultado;
        }

        public int ExecuteNonQuery(DbCommand command)
        {
            DbConnection connection = null;
              try
            {
                connection = CreateOpenConnection();
                command.Connection = connection;

                return command.ExecuteNonQuery();
            }
            finally // is executed in case of exceptions as well
            {
                ReleaseConnection(connection);
            }
        }