// @nuget: EntityFramework

​

using System;

using System.Linq;

using System.Data.Entity;

using System.Reflection;

using System.Data.SqlClient;

​

public class Program

{

    public static void Main()

    {

        using (var context = new EntityContext())

        {

            context.Customers.Add(new Customer() { Name ="Customer_A", Description = "Description", LastLoginTime = new DateTime(2010,1, 1, 13, 30, 0).TimeOfDay });

            context.Customers.Add(new Customer() { Name ="Customer_B", Description = "Description", LastLoginTime = new TimeSpan(8, 0 , 0) });          

            context.Customers.Add(new Customer() { Name ="Customer_C", Description = "Description", LastLoginTime = new TimeSpan(15, 0 , 0)});

            context.SaveChanges();  

        }

​

        using (var context = new EntityContext())

        {

            var list = context.Customers.ToList();

            Console.WriteLine(GetEntityFrameworkDllVersion());

            FiddleHelper.WriteTable("Customers", list); 

        }

        using(var conn = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer())) 

        {

            conn.Open();

            using(var cmd = conn.CreateCommand())

            {

                cmd.CommandText = @"SELECT COLUMN_NAME, DATA_TYPE 

FROM INFORMATION_SCHEMA.COLUMNS 

WHERE TABLE_NAME = 'Customers'";

                var reader = cmd.ExecuteReader();

                while(reader.Read())

                {

                    Console.WriteLine(reader[0] + ": " +reader[1]);

                }

            }

        }

    }

​

    public class EntityContext : DbContext

    {

        public EntityContext() : base(FiddleHelper.GetConnectionStringSqlServer())

        {

​

        }

        public DbSet<Customer> Customers { get; set; }

    }

    public static string GetEntityFrameworkDllVersion()

    {

        var efAssembly = System

            .AppDomain

            .CurrentDomain

            .GetAssemblies()

            .FirstOrDefault(x => x.FullName.Contains("EntityFramework"));

​

        if (efAssembly == null)

        {

            return "EF is not installed in project";

        }

​

        return "Using " + efAssembly.FullName + " v" + efAssembly.GetCustomAttributes<AssemblyInformationalVersionAttribute>().First().InformationalVersion;

    }

    public class Customer

    {

        public int CustomerID { get; set; }

        public string Name { get; set; }

        public string Description { get; set; }

        public TimeSpan LastLoginTime { get; set; }

    }

}