'How do i convert OracleDataReader to a List object that i can store in my model MVC

I have managed to connect to the OracleDb and use the OracleDataReader to retrieve the data from the DB. The problem i have is that i now want to insert the retrieved data in my model (Invoice). The problem right now is that i cant convert the retrieved data to a type that is accepted by the model. Is there a way to convert the OracleDataReader reader to a type that is accepted by the model so i can fil the model (IEnumerable) with data?

public ViewResult search_btn(object sender, EventArgs e, string docno){

OracleConnection OC = new OracleConnection("SOMECONNECTIONSTRING");
OracleCommand getBlobRecord = new OracleCommand("select * from xx where invoice_no=:invoiceId", OC);
getBlobRecord.Parameters.Add(new OracleParameter("invoiceId", docno));
OC.Open();

using (OracleDataReader reader = getBlobRecord.ExecuteReader(CommandBehavior.SequentialAccess))
{
    try
    {
        while (reader.Read())
        {
            var x = reader["invoice_no"];
            var y = reader["supplier_id"];
            new Invoice
            {
                Invoice_No = (int)x,
                Supplier_Id = (int)y
            };
        }
        reader.Close();
        reader.Dispose();
        return View("Index");
    }
    finally
    {
        reader.Close();
        OC.Close();
    }
}}


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source