Questions tagged [choetl]

Cinchoo ETL is an ETL framework for .NET. Simple, intuitive Extract, transform and load (ETL) library for .NET. It is a code-based ETL framework for extracting data from multiple sources, transforming, and loading into your very own data warehouse in .NET environment. Extremely fast, flexible, and easy to use.

Sample shows how to load below CSV (emp.csv) file

Id,Name
1,Tom
2,Carl
3,Mark

Load using iterator

foreach (dynamic e in new ChoCSVReader("Emp.csv").WithFirstLineHeader())
    Console.WriteLine("Id: " + e.Id + " Name: " + e.Name);

Load using loop

var reader = new ChoCSVReader("Emp.csv").WithFirstLineHeader();
dynamic rec;

while ((rec = reader.Read()) != null)
    Console.WriteLine("Id: " + e.Id + " Name: " + e.Name);

Load using POCO object

public class Employee
{
    public int Id { get; set; }
    public string Name { get; set; }
}
foreach (var e in new ChoCSVReader<Employee>("Emp.csv").WithFirstLineHeader())
    Console.WriteLine("Id: " + e.Id + " Name: " + e.Name);

References

• Product Source
• NuGet package