Move CSV file to SQL Server in C#

       private void MoveCSVToSQLServer()
        {
            string connectionString = "Specify your connection string here";
            string tablename = "Specify table name in SQL Server";

            SqlConnection conn = new SqlConnection(connectionString);
            conn.Open();
            SqlTransaction transaction = conn.BeginTransaction();
            try
            {
                using (StreamReader file = new StreamReader("Specify CSV file path here"))
                {
                    CsvReader csv = new CsvReader(file, true, ',');
                    SqlBulkCopy copy = new SqlBulkCopy(conn, SqlBulkCopyOptions.KeepIdentity, transaction);
                    copy.DestinationTableName = tablename;

                    copy.ColumnMappings.Add("_id", "_id");
                  .
                  .
                    till all columns mapping
                    copy.WriteToServer(csv);
                    transaction.Commit();
                }
            }
            catch (Exception ex)
            {
                transaction.Rollback();
            }
            finally
            {
                conn.Close();
            }
        }