Exemplo n.º 1
0
        public virtual void PurgeLog()
        {
            //Because event log is run on application end, app may not be fully installed, so check for the sproc first
            string sql = "IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'" + DatabaseOwner + ObjectQualifier +
                         "PurgeEventLog') AND OBJECTPROPERTY(id, N'IsProcedure') = 1) " + " BEGIN " +
                         "    EXEC " + DatabaseOwner + ObjectQualifier + "PurgeEventLog" + " END ";

            PetaPocoHelper.ExecuteNonQuery(ConnectionString, CommandType.Text, sql);
        }
Exemplo n.º 2
0
 public override void ExecuteNonQuery(string procedureName, params object[] commandParameters)
 {
     PetaPocoHelper.ExecuteNonQuery(ConnectionString, CommandType.StoredProcedure, DatabaseOwner + ObjectQualifier + procedureName, commandParameters);
 }
 public override void ExecuteNonQuery(string connectionString, CommandType commandType, int commandTimeout, string procedure, object[] commandParameters)
 {
     PetaPocoHelper.ExecuteNonQuery(connectionString, commandType, commandTimeout, procedure, commandParameters);
 }