Master Detail Easy Example

If you have a source file like this, separated by a |:

ALFKI|Alfreds Futterkiste|Maria Anders|Sales Representative|Obere Str. 57|Berlin|Germany 10248|ALFKI|5|04071996|01081996|16071996|3|32.38 10249|ALFKI|6|05071996|16081996|10071996|1|11.61 10251|ALFKI|3|08071996|05081996|15071996|1|41.34 ANATR|Ana Trujillo Emparedados y helados|Ana Trujillo|Owner|Avda. de la Constitución 2222|México D.F.|Mexico 10252|ANATR|4|09071996|06081996|11071996|2|51.3 ANTON|Antonio Moreno Taquería|Antonio Moreno|Owner|Mataderos 2312|México D.F.|Mexico ...............

where the lines that begins with letters are the Customers (master records) and the lines that begins with numbers are the Orders (details records)

The two Mapping Classes are:

[DelimitedRecord("|")] public class Customers { public string CustomerID; public string CompanyName; public string ContactName; public string ContactTitle; public string Address; public string City; public string Country; } [DelimitedRecord("|")] public class Orders { public int OrderID; public string CustomerID; public int EmployeeID; public DateTime OrderDate; public DateTime RequiredDate; public DateTime ShippedDate; public int ShipVia; public decimal Freight; }

You need to define a Selector Method too:

RecordAction ExampleSelector(string record) { if (Char.IsLetter(record[0])) return RecordAction.Master; else return RecordAction.Detail; }

Finally you must to instanciate a MasterDetailEngine and Read/Write files:

MasterDetailEngine engine = new MasterDetailEngine(typeof(Customers), typeof(Orders), new MasterDetailSelector(ExampleSelector)); // to Read use: MasterDetails[] res = engine.ReadFile("TestIn.txt"); // to Write use: engine.WriteFile("TestOut.txt", res);

Now you have a MasterDetails array named res where every item in the array is a MasterDetails object.
If you want to access the Master or Detail objects you can use:

// The master record res[0].Master // The details records res[0].Details // The first detail record res[0].Details[0]

 

See also

Must Read - Quick Start Guide - Attributes List - F.A.Q. - Examples of Use - Contacts & Credits - Donations

---