using System;

using System.Data;

using System.Collections.Generic;

using System.Linq;

public class Program

{

    public static void Main()

    {

        Console.WriteLine("Hello World");

        var pdb = new PersonalDetailsBuilder();

        pdb.CreateNewTable();

        pdb.AddStandardData();

        pdb.AddRow(17, "Customer 17");

        using (IDataReader reader = pdb.ToDataReader())

        {

                while (reader.Read())

            {

                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));

​

​

        return this;

    }

​

    public PersonalDetailsBuilder AddStandardData(int numberOfRows = 3)

    {

        foreach (int i in Enumerable.Range(1, numberOfRows + 1))

        {

            this.AddRow(i, "Customer " + i);

        }

​

        return this;

    }

​

    public PersonalDetailsBuilder AddRow(int customerId, string customerName)

    {

        this._dataTable.Rows.Add(customerId, customerName);

​

        return this;

    }

​

    public IDataReader ToDataReader()

    {

        return this._dataTable.CreateDataReader();

    }

}

}