How to import log file into Asp.net mvc with Entity framework

Question

I would like to ask a question and I do not know how to structure my need..

I need to import/export a file with records, and depending on each record will be a different table, with its references and etc.. What file formats is ideal? . csv, xls, and etc..

In the file I separate each item with delimiter or with specific header for each item? Which is the best way?

What is the best way to create this file layout and import/export? So far I have no idea how to do it..

Answer 1

You can use the filehelpers.

Here are some examples of how to use it

Data delimited by comma

1732,Juan Perez,435.00,11-05-2002
554,Pedro Gomez,12342.30,06-02-2004
112,Ramiro Politti,0.00,01-02-2000
924,Pablo Ramirez,3321.30,24-11-2002

Mapping class

using FileHelpers;

[DelimitedRecord(",")]
public class Customer
{
    public int CustId;

    public string Name;

    public decimal Balance;

    [FieldConverter(ConverterKind.Date, "dd-MM-yyyy")]
    public DateTime AddedDate;

}

Reading and writing with the FileHelpers

var engine = new FileHelperEngine<Customer>();

// To Read Use:
var result = engine.ReadFile("FileIn.txt");
// result is now an array of Customer

// To Write Use:
engine.WriteFile("FileOut.txt", result);

Displaying the result

foreach (Customer cust in result)
{
    Console.WriteLine("Customer Info:");
    Console.WriteLine(cust.Name + " - " +
                      cust.AddedDate.ToString("dd/MM/yy"));
}

If I’m not mistaken the newer version already supports properties too.