I believe Table Value Parameter is good option for this case. Have a look at a sample code below in SQL Server.

-- Your table
CREATE TABLE SampleTable
(
    ID          INT
)

INSERT INTO SampleTable VALUES
(1010),
(2010),       
(3010),
(4010),
(5010),      
(6010),      
(7010),      
(8030)
GO

-- Create a TABLE type in SQL database which you can fill from front-end code
CREATE TYPE ParameterTableType AS TABLE  
(
    ParameterID INT
    --, some other columns
)
GO

-- Create a stored proc using table type defined above
CREATE PROCEDURE ParameterArrayProcedure
(
    @ParameterTable AS ParameterTableType READONLY
)
AS
BEGIN

    SELECT
        S.*
    FROM SampleTable S
    INNER JOIN @ParameterTable P ON S.ID = P.ParameterID

END
GO

-- Populated table type variable
DECLARE @ParameterTable AS ParameterTableType
INSERT INTO @ParameterTable (ParameterID) VALUES (1010), (4010), (7010)

EXECUTE ParameterArrayProcedure @ParameterTable

DROP PROCEDURE ParameterArrayProcedure
DROP TYPE ParameterTableType
DROP TABLE SampleTable
GO

Apart from Table Value Parameter, you can also use Json or XML values as SQL parameter but yes, it will definitely change your execution plan accordingly.

Oracle

In other languages (i.e. Java) you can pass an SQL collection as a bind parameter and directly use it in an SQL statement.

However, C# does not support passing SQL collections and only supports passing OracleCollectionType.PLSQLAssociativeArray (documentation link) which is a PL/SQL only data-type and cannot be used (directly) in SQL statements.

To pass an array, you would need to pass a PLSQLAssociativeArray to a PLSQL stored procedure and use that to convert it to an SQL collection that you can use in an SQL statement. An example of a procedure to convert from a PL/SQL associative array to an SQL collection is:

CREATE TYPE IntList AS TABLE OF INTEGER
/

CREATE PACKAGE tools IS
  TYPE IntMap IS TABLE OF INTEGER INDEX BY BINARY_INTEGER;

  FUNCTION IntMapToList(
    i_map IntMap
  ) RETURN IntList;
END;
/

CREATE PACKAGE BODY tools IS
  FUNCTION IntMapToList(
    i_map IntMap
  ) RETURN IntList
  IS
    o_list IntList := IntList();
    i      BINARY_INTEGER;
  BEGIN
    IF i_map IS NOT NULL THEN
      i := o_list.FIRST;
      WHILE i IS NOT NULL LOOP
        o_list.EXTEND;
        o_list( o_list.COUNT ) := i_map( i );
        i := i_map.NEXT( i );
      END LOOP;
    END IF;
    RETURN o_list;
  END;
END;
/

I use a stringified XML and pass it inside SQL where I convert it to the collection to use in "IN":

//rawSql
SELECT
    ...
FROM
    EVENTS
WHERE
    (:EVENTTYPES IS NULL OR EVENT_TYPE IN (SELECT value FROM (SELECT XMLTYPE(:EVENTTYPES) AS xml FROM dual), XMLTABLE('/Values/Value' PASSING xml COLUMNS value NUMBER PATH '.')))

//C#
using (var command = dbContext.Database.GetDbConnection().CreateCommand())
{
    command.CommandText = rawSql;
    command.CommandType = CommandType.Text;
    var dbParameter = command.CreateParameter();
    dbParameter.ParameterName = "EVENTTYPES";
    dbParameter.DbType = DbType.String;
    dbParameter.Value = new XElement("Values", from value in new int[] { 1, 2, 3 } select new XElement("Value", value)).ToString();            
    command.Parameters.Add(dbParameter);
}