Ícono de mensaje
Saltar al pie de página
  1. IronPDF
  2. Blog de IronPDF
  3. .NET Ayuda
  4. csharp-devart-data-oracle
.NET AYUDA

C# Devart.Data.Oracle (Cómo Funciona para Desarrolladores)

Curtis Chau
Curtis Chau
Actualizado:

Welcome to our complete solution tutorial on integrating C# Devart.Data.Oracle with IronPDF to create comprehensive applications, focusing on Oracle-based database applications. This tutorial describes a guide designed for beginners interested in leveraging the power of Oracle databases in their .NET Framework and .NET Core projects. Devart.Data.Oracle is a powerful data provider that enables direct access to Oracle databases.

C# Devart.Data.Oracle is a library that simplifies Oracle database operations. It's for developers who need to interact with Oracle databases. This library offers advanced features. It streamlines database connectivity. It enhances data manipulation. This makes it a valuable tool for C# developers.

Explore IronPDF's Features for PDF Generation as a tool that allows C# developers to create, edit, and read PDF files. It integrates easily with .NET applications. IronPDF helps in generating PDFs from HTML. It provides a way to work with PDF files programmatically.

Both tools serve different purposes. C# Devart.Data.Oracle focuses on Oracle database interactions. IronPDF focuses on PDF file manipulation. Together, they enhance the capabilities of C# developers. They address two distinct needs in software development. This article will primarily focus on C# Devart.Data.Oracle.

Getting Started with C# Devart.Data.Oracle

Setting Up C# Devart.Data.Oracle in .NET Projects

To start using C# Devart.Data.Oracle, a renowned Oracle Database Provider, you first need to add it to your .NET Core project through Visual Studio's Solution Explorer. This process is straightforward. Go to the NuGet Package Manager. Search for "Devart.Data.Oracle". Install the package to leverage DotConnect for Oracle and Dataset tools. This action adds the library to your project. Now you can begin using its features.

C# Devart.Data.Oracle (How It Works For Developers): Figure 1 - Searching for Devart.Data.Oracle through NuGet Package Manager in Visual Studio

A Basic Code Example

Let's look at a simple example. This will demonstrate how to connect to an Oracle database. We'll execute a query. Here's a basic example:

using Devart.Data.Oracle;
using System;

class Program
{
    static void Main()
    {
        // Define the connection string with placeholders for your specific database information
        var connectionString = "User Id=myUsername;Password=myPassword;Server=myServer;";

        // Establish a connection to the Oracle database
        using (var connection = new OracleConnection(connectionString))
        {
            connection.Open();

            // Execute a SQL command
            using (var command = new OracleCommand("SELECT * FROM myTable", connection))
            {
                using (OracleDataReader reader = command.ExecuteReader())
                {
                    // Read and print each row of the result set
                    while (reader.Read())
                    {
                        Console.WriteLine(reader["myColumn"].ToString());
                    }
                }
            }
        }
    }
}
using Devart.Data.Oracle;
using System;

class Program
{
    static void Main()
    {
        // Define the connection string with placeholders for your specific database information
        var connectionString = "User Id=myUsername;Password=myPassword;Server=myServer;";

        // Establish a connection to the Oracle database
        using (var connection = new OracleConnection(connectionString))
        {
            connection.Open();

            // Execute a SQL command
            using (var command = new OracleCommand("SELECT * FROM myTable", connection))
            {
                using (OracleDataReader reader = command.ExecuteReader())
                {
                    // Read and print each row of the result set
                    while (reader.Read())
                    {
                        Console.WriteLine(reader["myColumn"].ToString());
                    }
                }
            }
        }
    }
}
Imports Devart.Data.Oracle
Imports System

Friend Class Program
	Shared Sub Main()
		' Define the connection string with placeholders for your specific database information
		Dim connectionString = "User Id=myUsername;Password=myPassword;Server=myServer;"

		' Establish a connection to the Oracle database
		Using connection = New OracleConnection(connectionString)
			connection.Open()

			' Execute a SQL command
			Using command = New OracleCommand("SELECT * FROM myTable", connection)
				Using reader As OracleDataReader = command.ExecuteReader()
					' Read and print each row of the result set
					Do While reader.Read()
						Console.WriteLine(reader("myColumn").ToString())
					Loop
				End Using
			End Using
		End Using
	End Sub
End Class
$vbLabelText   $csharpLabel

This code snippet is enhanced with proper connection strings. It selects data from a table and prints a column value to the console. Replace myUsername, myPassword, myServer, myTable, and myColumn with your actual database details. This is how you perform a basic database operation using C# Devart.Data.Oracle.

Implement Features of Devart.Data.Oracle

Direct Mode

One of the standout features of Devart.Data.Oracle, a crucial part of any application architecture, is Direct Mode. This allows your application to work with Oracle databases without Oracle Client. It simplifies deployment. It reduces the application's overall footprint.

var connectionString = "User Id=myUsername; Password=myPassword; Direct=True; Server=myServer;";
using (var connection = new OracleConnection(connectionString))
{
    connection.Open();
    // Use the connection
}
var connectionString = "User Id=myUsername; Password=myPassword; Direct=True; Server=myServer;";
using (var connection = new OracleConnection(connectionString))
{
    connection.Open();
    // Use the connection
}
Dim connectionString = "User Id=myUsername; Password=myPassword; Direct=True; Server=myServer;"
Using connection = New OracleConnection(connectionString)
	connection.Open()
	' Use the connection
End Using
$vbLabelText   $csharpLabel

This example shows how to enable Direct Mode. Add Direct=True to your connection string.

Advanced Entity Framework Support

Devart.Data.Oracle enhances Entity Framework (EF) operations. It provides better performance and supports both EF Core and EF6. It offers a wide range of Oracle-specific features.

// Example assumes EF Core setup
using (var context = new MyDbContext())
{
    var data = context.MyEntities.Where(e => e.Property > 0).ToList();
    foreach (var item in data)
    {
        Console.WriteLine(item.Name);
    }
}
// Example assumes EF Core setup
using (var context = new MyDbContext())
{
    var data = context.MyEntities.Where(e => e.Property > 0).ToList();
    foreach (var item in data)
    {
        Console.WriteLine(item.Name);
    }
}
' Example assumes EF Core setup
Using context = New MyDbContext()
	Dim data = context.MyEntities.Where(Function(e) e.Property > 0).ToList()
	For Each item In data
		Console.WriteLine(item.Name)
	Next item
End Using
$vbLabelText   $csharpLabel

This code fetches data using EF Core. Replace MyDbContext, MyEntities, and Property with your actual context and entity names.

Bulk Operations

Bulk operations are crucial for high-performance data manipulation. Devart.Data.Oracle offers bulk copy functionality. This is useful for large data transfers.

using (var connection = new OracleConnection(connectionString))
{
    connection.Open();
    using (var bulkCopy = new OracleBulkCopy(connection))
    {
        bulkCopy.DestinationTableName = "targetTable";
        bulkCopy.WriteToServer(dataTable);
    }
}
using (var connection = new OracleConnection(connectionString))
{
    connection.Open();
    using (var bulkCopy = new OracleBulkCopy(connection))
    {
        bulkCopy.DestinationTableName = "targetTable";
        bulkCopy.WriteToServer(dataTable);
    }
}
Using connection = New OracleConnection(connectionString)
	connection.Open()
	Using bulkCopy = New OracleBulkCopy(connection)
		bulkCopy.DestinationTableName = "targetTable"
		bulkCopy.WriteToServer(dataTable)
	End Using
End Using
$vbLabelText   $csharpLabel

This code demonstrates bulk data insertion. Replace targetTable with your destination table name. dataTable should be your data source.

Integrated Performance Monitoring

Performance monitoring is built into Devart.Data.Oracle. It allows you to track and optimize database interactions.

using System;
using Devart.Data.Oracle;

class Example
{
    static void Main()
    {
        // Enable monitoring
        using (var monitor = new OracleMonitor() { IsActive = true })
        {
            // Perform database operations here
            // Monitoring will log interactions
        }
    }
}
using System;
using Devart.Data.Oracle;

class Example
{
    static void Main()
    {
        // Enable monitoring
        using (var monitor = new OracleMonitor() { IsActive = true })
        {
            // Perform database operations here
            // Monitoring will log interactions
        }
    }
}
Imports System
Imports Devart.Data.Oracle

Friend Class Example
	Shared Sub Main()
		' Enable monitoring
		Using monitor = New OracleMonitor() With {.IsActive = True}
			' Perform database operations here
			' Monitoring will log interactions
		End Using
	End Sub
End Class
$vbLabelText   $csharpLabel

Enable OracleMonitor and set IsActive to true. This starts monitoring your database operations.

Enhanced LINQ to SQL Support

LINQ to SQL transforms complex queries into efficient SQL. Devart.Data.Oracle provides optimized LINQ to SQL capabilities. It supports complex queries and transformations.

using (var context = new MyDbContext())
{
    var query = from e in context.MyEntities
                where e.PropertyName == "Value"
                select e;

    foreach (var item in query)
    {
        Console.WriteLine(item.Property);
    }
}
using (var context = new MyDbContext())
{
    var query = from e in context.MyEntities
                where e.PropertyName == "Value"
                select e;

    foreach (var item in query)
    {
        Console.WriteLine(item.Property);
    }
}
Using context = New MyDbContext()
	Dim query = From e In context.MyEntities
		Where e.PropertyName = "Value"
		Select e

	For Each item In query
		Console.WriteLine(item.Property)
	Next item
End Using
$vbLabelText   $csharpLabel

Replace MyDbContext, MyEntities, PropertyName, and Property with your actual context, entity, and property names. This example queries the database using LINQ.

Each of these features enhances your application. They make your work with Oracle databases more efficient. You have direct access, advanced EF support, bulk operations, performance monitoring, and enhanced LINQ to SQL at your disposal.

Integrate IronPDF and Devart.Data.Oracle

Introduction to IronPDF

C# Devart.Data.Oracle (How It Works For Developers): Figure 2 - IronPDF homepage

Learn About IronPDF's Capabilities as a library that serves a simple yet powerful purpose: it allows developers to create, edit, and extract PDF content within their .NET applications. The real charm of IronPDF lies in its ease of use, offering straightforward methods to convert HTML to PDF - a common requirement for reports, invoices, and documentation in web applications.

IronPDF excels in HTML to PDF conversion, ensuring precise preservation of original layouts and styles. It's perfect for creating PDFs from web-based content such as reports, invoices, and documentation. With support for HTML files, URLs, and raw HTML strings, IronPDF easily produces high-quality PDF documents.

using IronPdf;

class Program
{
    static void Main(string[] args)
    {
        // Initialize IronPDF's renderer
        var renderer = new ChromePdfRenderer();

        // 1. Convert HTML String to PDF
        var htmlContent = "<h1>Hello, IronPDF!</h1><p>This is a PDF from an HTML string.</p>";
        var pdfFromHtmlString = renderer.RenderHtmlAsPdf(htmlContent);
        pdfFromHtmlString.SaveAs("HTMLStringToPDF.pdf");

        // 2. Convert HTML File to PDF
        var htmlFilePath = "path_to_your_html_file.html"; // Specify the path to your HTML file
        var pdfFromHtmlFile = renderer.RenderHtmlFileAsPdf(htmlFilePath);
        pdfFromHtmlFile.SaveAs("HTMLFileToPDF.pdf");

        // 3. Convert URL to PDF
        var url = "http://ironpdf.com"; // Specify the URL
        var pdfFromUrl = renderer.RenderUrlAsPdf(url);
        pdfFromUrl.SaveAs("URLToPDF.pdf");
    }
}
using IronPdf;

class Program
{
    static void Main(string[] args)
    {
        // Initialize IronPDF's renderer
        var renderer = new ChromePdfRenderer();

        // 1. Convert HTML String to PDF
        var htmlContent = "<h1>Hello, IronPDF!</h1><p>This is a PDF from an HTML string.</p>";
        var pdfFromHtmlString = renderer.RenderHtmlAsPdf(htmlContent);
        pdfFromHtmlString.SaveAs("HTMLStringToPDF.pdf");

        // 2. Convert HTML File to PDF
        var htmlFilePath = "path_to_your_html_file.html"; // Specify the path to your HTML file
        var pdfFromHtmlFile = renderer.RenderHtmlFileAsPdf(htmlFilePath);
        pdfFromHtmlFile.SaveAs("HTMLFileToPDF.pdf");

        // 3. Convert URL to PDF
        var url = "http://ironpdf.com"; // Specify the URL
        var pdfFromUrl = renderer.RenderUrlAsPdf(url);
        pdfFromUrl.SaveAs("URLToPDF.pdf");
    }
}
Imports IronPdf

Friend Class Program
	Shared Sub Main(ByVal args() As String)
		' Initialize IronPDF's renderer
		Dim renderer = New ChromePdfRenderer()

		' 1. Convert HTML String to PDF
		Dim htmlContent = "<h1>Hello, IronPDF!</h1><p>This is a PDF from an HTML string.</p>"
		Dim pdfFromHtmlString = renderer.RenderHtmlAsPdf(htmlContent)
		pdfFromHtmlString.SaveAs("HTMLStringToPDF.pdf")

		' 2. Convert HTML File to PDF
		Dim htmlFilePath = "path_to_your_html_file.html" ' Specify the path to your HTML file
		Dim pdfFromHtmlFile = renderer.RenderHtmlFileAsPdf(htmlFilePath)
		pdfFromHtmlFile.SaveAs("HTMLFileToPDF.pdf")

		' 3. Convert URL to PDF
		Dim url = "http://ironpdf.com" ' Specify the URL
		Dim pdfFromUrl = renderer.RenderUrlAsPdf(url)
		pdfFromUrl.SaveAs("URLToPDF.pdf")
	End Sub
End Class
$vbLabelText   $csharpLabel

Merging IronPDF with Devart.Data.Oracle

Imagine you're working on a project where you need to generate a report from data stored in an Oracle database and then present that report as a PDF file. Here's where the combination of IronPDF and Devart.Data.Oracle comes into play. Devart.Data.Oracle is a high-performance ADO.NET provider that gives developers an efficient way to access Oracle databases from .NET applications.

Code Example of Use Case

Let's dive into a practical example to illustrate this process. Suppose we have a table named SalesReport in our Oracle database, and we want to generate a PDF report that summarizes this data. First, you'll need to install IronPDF and Devart.Data.Oracle packages via NuGet. This can be done using the NuGet Package Manager or via the Package Manager Console:

Install-Package IronPdf
Install-Package Devart.Data.Oracle
Install-Package IronPdf
Install-Package Devart.Data.Oracle
SHELL

Next, here's how you could write the code to fetch data from the SalesReport table and generate a PDF:

using Devart.Data.Oracle;
using IronPdf;
using System;

class Program
{
    static void Main(string[] args)
    {
        // Connection string to Oracle Database
        var oracleConnectionString = "User Id=your_user;Password=your_password;Direct=True;Sid=your_sid;Server=your_server;";

        // SQL query to fetch data
        var sqlQuery = "SELECT * FROM SalesReport";

        // Initialize the Oracle connection
        using (var oracleConnection = new OracleConnection(oracleConnectionString))
        {
            oracleConnection.Open();

            // Execute the query
            using (var oracleCommand = new OracleCommand(sqlQuery, oracleConnection))
            {
                using (var reader = oracleCommand.ExecuteReader())
                {
                    // Initialize HTML content for PDF generation
                    var htmlContent = "<h1>Sales Report</h1><p>Generated on " + DateTime.Now + "</p>";

                    // Append database data to the HTML content
                    while (reader.Read())
                    {
                        htmlContent += $"<p>{reader["ItemName"]} - {reader["SaleAmount"]}</p>";
                    }

                    // Create a PDF from the HTML content using IronPDF
                    var renderer = new ChromePdfRenderer();
                    var pdf = renderer.RenderHtmlAsPdf(htmlContent);

                    // Save the PDF to a file
                    pdf.SaveAs("SalesReport.pdf");
                }
            }
        }

        Console.WriteLine("PDF generated successfully.");
    }
}
using Devart.Data.Oracle;
using IronPdf;
using System;

class Program
{
    static void Main(string[] args)
    {
        // Connection string to Oracle Database
        var oracleConnectionString = "User Id=your_user;Password=your_password;Direct=True;Sid=your_sid;Server=your_server;";

        // SQL query to fetch data
        var sqlQuery = "SELECT * FROM SalesReport";

        // Initialize the Oracle connection
        using (var oracleConnection = new OracleConnection(oracleConnectionString))
        {
            oracleConnection.Open();

            // Execute the query
            using (var oracleCommand = new OracleCommand(sqlQuery, oracleConnection))
            {
                using (var reader = oracleCommand.ExecuteReader())
                {
                    // Initialize HTML content for PDF generation
                    var htmlContent = "<h1>Sales Report</h1><p>Generated on " + DateTime.Now + "</p>";

                    // Append database data to the HTML content
                    while (reader.Read())
                    {
                        htmlContent += $"<p>{reader["ItemName"]} - {reader["SaleAmount"]}</p>";
                    }

                    // Create a PDF from the HTML content using IronPDF
                    var renderer = new ChromePdfRenderer();
                    var pdf = renderer.RenderHtmlAsPdf(htmlContent);

                    // Save the PDF to a file
                    pdf.SaveAs("SalesReport.pdf");
                }
            }
        }

        Console.WriteLine("PDF generated successfully.");
    }
}
Imports Devart.Data.Oracle
Imports IronPdf
Imports System

Friend Class Program
	Shared Sub Main(ByVal args() As String)
		' Connection string to Oracle Database
		Dim oracleConnectionString = "User Id=your_user;Password=your_password;Direct=True;Sid=your_sid;Server=your_server;"

		' SQL query to fetch data
		Dim sqlQuery = "SELECT * FROM SalesReport"

		' Initialize the Oracle connection
		Using oracleConnection As New OracleConnection(oracleConnectionString)
			oracleConnection.Open()

			' Execute the query
			Using oracleCommand As New OracleCommand(sqlQuery, oracleConnection)
				Using reader = oracleCommand.ExecuteReader()
					' Initialize HTML content for PDF generation
					Dim htmlContent = "<h1>Sales Report</h1><p>Generated on " & DateTime.Now & "</p>"

					' Append database data to the HTML content
					Do While reader.Read()
						htmlContent &= $"<p>{reader("ItemName")} - {reader("SaleAmount")}</p>"
					Loop

					' Create a PDF from the HTML content using IronPDF
					Dim renderer = New ChromePdfRenderer()
					Dim pdf = renderer.RenderHtmlAsPdf(htmlContent)

					' Save the PDF to a file
					pdf.SaveAs("SalesReport.pdf")
				End Using
			End Using
		End Using

		Console.WriteLine("PDF generated successfully.")
	End Sub
End Class
$vbLabelText   $csharpLabel

In this example, we start by setting up a connection to our Oracle database using the Devart.Data.Oracle OracleConnection class. Then, we fetch data from the SalesReport table using a simple SQL query. For the sake of demonstration, the data fetched is transformed into an HTML string (in a real-world scenario, you'd build up a more complex HTML document based on your data). Finally, we use IronPDF's ChromePdfRenderer class to convert the HTML string into a PDF document, which is then saved locally.

Conclusion

C# Devart.Data.Oracle (How It Works For Developers): Figure 3 - IronPDF licensing page

In wrapping up this tutorial, it's clear that the integration of Entity Framework Core with Devart.Data.Oracle enriches the development of Oracle-based applications. The fusion of these technologies in your development environment, guided through Visual Studio, opens the door to a lot of possibilities for creating robust, scalable applications. For developers aiming to dive deeper into Oracle-based database applications, leveraging the comprehensive features of Entity Framework Core alongside DotConnect for Oracle provides a solid foundation. You can try IronPDF with a free demo or review pricing that starts from $799.

Preguntas Frecuentes

¿Cómo puedo integrar C# Devart.Data.Oracle con IronPDF en mi proyecto .NET?

Para integrar C# Devart.Data.Oracle con IronPDF en un proyecto .NET, primero instale ambas bibliotecas a través del Gestor de Paquetes NuGet en Visual Studio. Use Devart.Data.Oracle para conectar y obtener datos de bases de datos Oracle, luego emplee IronPDF para convertir los datos obtenidos en documentos PDF.

¿Cuáles son las ventajas de usar el Modo Directo en Devart.Data.Oracle?

El Modo Directo en Devart.Data.Oracle permite a las aplicaciones conectarse a bases de datos Oracle sin la necesidad de software cliente de Oracle, lo que simplifica la implementación y reduce la huella general de la aplicación.

¿Cómo puedo convertir contenido HTML a PDF usando .NET?

Puede convertir contenido HTML a PDF en .NET utilizando IronPDF. Utilice la clase ChromePdfRenderer para renderizar cadenas HTML, archivos o URLs en documentos PDF de alta calidad sin esfuerzo.

¿Cuál es el papel de Entity Framework en la integración de Devart.Data.Oracle?

Entity Framework, cuando se integra con Devart.Data.Oracle, mejora el rendimiento al soportar características avanzadas específicas de Oracle. Permite a los desarrolladores utilizar características como consultas complejas y transformaciones para operaciones eficientes de bases de datos.

¿Cómo realizo operaciones de datos masivas con Devart.Data.Oracle?

Devart.Data.Oracle admite operaciones masivas como la copia masiva, lo que es útil para transferir grandes volúmenes de datos de manera eficiente. Estas operaciones ayudan a optimizar las tareas de manipulación de datos dentro de sus aplicaciones .NET.

¿Qué pasos están involucrados en la generación de un informe PDF desde datos de bases de datos Oracle?

Para generar un informe PDF desde datos de bases de datos Oracle, utilice Devart.Data.Oracle para recuperar los datos necesarios y luego aplique IronPDF para formatear y convertir los datos en un informe PDF.

¿Cómo puedo mejorar el monitoreo del rendimiento de la base de datos usando Devart.Data.Oracle?

Mejore el monitoreo del rendimiento en Devart.Data.Oracle usando la clase OracleMonitor. Establezca su propiedad IsActive en true para comenzar a rastrear interacciones con la base de datos y optimizar el rendimiento.

¿Cuál es el proceso para agregar Devart.Data.Oracle a un proyecto .NET?

Para agregar Devart.Data.Oracle a un proyecto .NET, utilice el Gestor de Paquetes NuGet de Visual Studio. Busque 'Devart.Data.Oracle' e instálelo para habilitar funcionalidades de bases de datos Oracle en su aplicación.

¿Por qué los desarrolladores deberían considerar usar LINQ to SQL con Devart.Data.Oracle?

Los desarrolladores deberían considerar usar LINQ to SQL con Devart.Data.Oracle porque proporciona capacidades de consulta optimizadas y soporta transformaciones de datos complejas, mejorando la eficiencia y el rendimiento de las interacciones con bases de datos.

¿Cómo se puede renderizar HTML como PDF en una aplicación .NET?

En una aplicación .NET, HTML se puede renderizar como PDF usando el método RenderHtmlAsPdf de IronPDF. Este método permite a los desarrolladores convertir cadenas o archivos HTML en PDFs sin problemas.

Curtis Chau
Curtis Chau
  Chatea con el equipo de ingeniería ahora
Escritor Técnico

Curtis Chau tiene una licenciatura en Ciencias de la Computación (Carleton University) y se especializa en el desarrollo front-end con experiencia en Node.js, TypeScript, JavaScript y React. Apasionado por crear interfaces de usuario intuitivas y estéticamente agradables, disfruta trabajando con frameworks modernos y creando manuales bien ...

Leer más

Artículos Relacionados

Prueba de 30 días → Producto completo. Sin límites. Sin tarjeta. Comenzar prueba gratuita