namespace DataFieldMappingConsoleSample
{
    using System;
    using System.Collections.Generic;
    using System.Data;
    using System.Data.SqlClient;
    using System.Linq;
 
    class Program
    {
        static void Main(string[] args)
        {
            SqlConnection connection = new SqlConnection("Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=master;Data Source=localhost");
            SqlCommand command = new SqlCommand("SELECT * FROM sysobjects ORDER by type, name", connection);
 
            connection.Open();
            IDataReader dr = command.ExecuteReader();
            IEnumerable<TableInfo> tables = dr.AsEnumerable<TableInfo>();
            tables.All(tableInfo => { Console.WriteLine("Id: {0}, Name: {1}, Type: {2}", tableInfo.Id, tableInfo.Name, tableInfo.Type); return true; });
            connection.Close();
 
            Console.WriteLine("Press any key to finish...");
            Console.ReadKey(false);
        }
    }
 
    public class TableInfo
    {
        [DataFieldMapping("Id")]
        public int Id { get; set; }
 
        [DataFieldMapping("Name")]
        public string Name { get; set; }
 
        [DataFieldMapping("Type")]
        public string Type { get; set; }
    }
}