// A customer DTO 
public class CustomerDTO
 {	 
	public string Surname{get;set;}
	public string FirstName{get;set;}
	public string EmailAddress{get;set;} 	
 }
  

public class OracleDbConnector
 {
		private OracleConnection oracleConnection;
		private OracleConnectionStringBuilder stringBuilder;

		public OracleDbConnector(string dbUsername, string dbPassword, string dbServer)
		{
			stringBuilder = new OracleConnectionStringBuilder();
			stringBuilder.DataSource = dbServer;
			stringBuilder.UserID = dbUsername;
			stringBuilder.Password = dbPassword;
			oracleConnection = new OracleConnection();
			oracleConnection.ConnectionString = stringBuilder.ConnectionString;
		}
		
		public bool UploadBulkData(List<CustomerDTO> bulkData)
		{
			bool returnValue = false;
			try
			{

				string query = @"insert into PCMS.Customer ( surname, firstName, emailAddress) values 
								(:surname, :firstName, :emailAddress)";
				oracleConnection.Open();
				using (var command = oracleConnection.CreateCommand())
				{
					command.CommandText = query;
					command.CommandType = CommandType.Text;
					command.BindByName = true;
				  // In order to use ArrayBinding, the ArrayBindCount property
				  // of OracleCommand object must be set to the number of records to be inserted
					command.ArrayBindCount = bulkData.Count;
					command.Parameters.Add(":surname", OracleDbType.Varchar2, bulkData.Select(c => c.Surname).ToArray(), ParameterDirection.Input);
					command.Parameters.Add(":firstName", OracleDbType.Varchar2, bulkData.Select(c => c.FirstName).ToArray(), ParameterDirection.Input);
					command.Parameters.Add(":emailAddress", OracleDbType.Varchar2, bulkData.Select(c => c.EmailAddress).ToArray(), ParameterDirection.Input);
					int result = command.ExecuteNonQuery();
					if (result == bulkData.Count)
						returnValue = true;
				}

			}
			catch (OracleException ex)
			{
				//Log error thrown
			}
			finally
			{
				oracleConnection.Close();
			}
			return returnValue;
		}
 }
  

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using NUnit.Framework;

	[TestFixture]
	public class OracleDbConnectorTest
	{
		private OracleConnector oracleConnector;
		[TestFixtureSetUp]
		public void SetUpTest()
		{
			oracleConnector = new OracleConnector("UserId", "Password", "serverAddress");
		}

		[Test]
		public void TestUploadBulkData()
		{
			List<CustomerDTO> bulkData= new List<CustomerDTO>();
			bulkData.Add(new CustomerDTO("Ayobami","Adewole","[email protected]"));
			bulkData.Add(new CustomerDTO("John","Peter","[email protected]"));
			bulkData.Add(new CustomerDTO("Tunji","James","[email protected]"));
			Assert.IsTrue(oracleConnector.UploadBulkData(bulkData));
		}

		[TestFixtureTearDown]
		public void TearDownTest()
		{
			oracleConnector = null;
		}
	}
}