SIPSorcery.Persistence.StorageLayer.ExecuteNonQuery C# (CSharp) Method

ExecuteNonQuery() public method

public ExecuteNonQuery ( StorageTypes storageType, string dbConnString, string query ) : void
storageType StorageTypes
dbConnString string
query string
return void
        public void ExecuteNonQuery(StorageTypes storageType, string dbConnString, string query)
        {
            QuerySecurityCheck(query);

            try
            {
                using (IDbConnection dbConn = GetDbConnection(storageType, dbConnString)) {
                    dbConn.Open();
                    IDbCommand command = GetDbCommand(storageType, dbConn, query);
                    command.ExecuteNonQuery();
                }
            }
            catch(Exception excp)
            {
                logger.Error("Exception ExecuteNonQuery. " + excp.Message);
                throw excp;
            }
        }

Same methods

StorageLayer::ExecuteNonQuery ( StorageTypes storageType, string dbConnString, string query, object>.Dictionary parameters ) : void
StorageLayer::ExecuteNonQuery ( string query ) : void
StorageLayer::ExecuteNonQuery ( string query, object>.Dictionary parameters ) : void

Usage Example

 public void DBExecuteNonQuery(string dbType, string dbConnStr, string query)
 {
     try
     {
         //if (!IsAppAuthorised(m_dialPlanContext.SIPDialPlan.AuthorisedApps, "dbexecutenonquery"))
         //{
         //    Log("You are not authorised to use the DBExecuteNonQuery application, please contact [email protected].");
         //}
         if (ServiceLevel == CustomerServiceLevels.Free)
         {
             Log("Your service level of " + ServiceLevel + " is not authorised to use the " + System.Reflection.MethodBase.GetCurrentMethod().Name + " method.");
         }
         else
         {
             StorageTypes storageType = GetStorageType(dbType);
             if (storageType != StorageTypes.Unknown)
             {
                 StorageLayer storageLayer = new StorageLayer(storageType, dbConnStr);
                 storageLayer.ExecuteNonQuery(storageType, dbConnStr, query);
                 Log("DBExecuteNonQuery successful for " + query + ".");
             }
             else
             {
                 Log("Exception DBExecuteNonQuery did not recognise database type " + dbType + ".");
             }
         }
     }
     catch (Exception excp)
     {
         Log("Exception DBExecuteNonQuery. " + excp.Message);
     }
 }
All Usage Examples Of SIPSorcery.Persistence.StorageLayer::ExecuteNonQuery