using System.Collections.Generic;
public static void Main()
Console.WriteLine("Hello World");
var pdb = new PersonalDetailsBuilder();
pdb.AddRow(17, "Customer 17");
using (IDataReader reader = pdb.ToDataReader())
Console.WriteLine(reader.GetInt32(0) + ", " + reader.GetString(1));
public class PersonalDetailsBuilder
private DataTable _dataTable;
public PersonalDetailsBuilder CreateNewTable()
this._dataTable = new DataTable("CustomerPersonalDetails");
this._dataTable.Columns.Add("CustomerId", typeof(int));
this._dataTable.Columns.Add("CustomerName", typeof(string));
public PersonalDetailsBuilder AddStandardData(int numberOfRows = 3)
foreach (int i in Enumerable.Range(1, numberOfRows + 1))
this.AddRow(i, "Customer " + i);
public PersonalDetailsBuilder AddRow(int customerId, string customerName)
this._dataTable.Rows.Add(customerId, customerName);
public IDataReader ToDataReader()
return this._dataTable.CreateDataReader();