public static int DoQuery(this string sql, string connStr, ClientType type) { var result = -1; switch (type) { case ClientType.SqlSever: { result = DbUtility.ExecuteNonQueryForSqlSever(sql, connStr); } break; case ClientType.Oracle: { result = DbUtility.ExecuteNonQueryForOracle(sql, connStr); } break; case ClientType.MySql: { result = DbUtility.ExecuteNonQueryForMySql(sql, connStr); } break; default: { throw new NotSupportedExceptionInCoreException(); } } return(result); }