[Table("Terminals", Schema = "dbo")]
public class TerminalEx
{
    #region Constructors
    public TerminalEx()
    {

    }
    #endregion

    #region Public Properties
    [Key]
    public int TerminalId { get; set; }

    public string License { get; set; }

    [Column("TerminalName")]
    public string Name { get; set; }

    public string RootPublicDomainAddress { get; set; }
    public string CompanyName { get; set; }
    public int TimeZoneId { get; set; }
    public string Zip { get; set; }
    public string DispatchEmail { get; set; }

    [Column("useAutoAddlDrvPmt")]
    public byte UseAutoAddDriverPayment { get; set; }

    public byte UseTerminalAutoAssignment { get; set; }
    public byte UseMapCodes { get; set; }

    [Column("OEautoPopulateAccountNo")]
    public byte AutoPopulateAccountNumberForOrderEntry { get; set; }

    [Column("OEautoPopulateAddresses")]
    public byte AutoPopulateAddressesForOrderEntry { get; set; }
    #endregion
}

public class XceleratorContext : DbContext
{
    public static void DoTest()
    {
        XceleratorContext db = null;
        try
        {
            db = new XceleratorContext();
            var bleh = db.Terminals.ToList();

            foreach (TerminalEx term in bleh)
            {
                System.Diagnostics.Debug.WriteLine(term.TerminalId);
                System.Diagnostics.Debug.WriteLine(term.Name);
            }
        }
        catch (Exception ex)
        {
            System.Diagnostics.Debug.WriteLine(ex.ToString());
            throw;
        }
        finally
        {
            if (db != null)
            {
                db.Dispose();
                db = null;
            }
        }
    }

    #region Contructors
    public XceleratorContext()
        : base(ConfigurationManager.AppSettings["ConnectionString"])
    {
        Database.SetInitializer<XceleratorContext>(null);
        this.Database.Log += WriteLog;
    }

    private void WriteLog(string obj)
    {
        System.Diagnostics.Debug.WriteLine(obj);
    }
    #endregion

    #region Public Properties
    public virtual DbSet<TerminalEx> Terminals { get; set; }
    #endregion

    #region Encapsulation of DbSets
    public T Add<T>(T entity) where T : class
    {
        return Set<T>().Add(entity);
    }

    public T Attach<T>(T entity) where T : class
    {
        Set<T>().Attach(entity);
        Entry<T>(entity).State = EntityState.Modified;
        return entity;
    }

    public T Detach<T>(T entity) where T : class
    {
        Entry<T>(entity).State = EntityState.Detached;
        return entity;
    }

    public T Remove<T>(T entity) where T : class
    {
        if (Entry<T>(entity).State == EntityState.Detached)
        {
            Entry<T>(entity).State = EntityState.Deleted;
            return Entry<T>(entity).Entity;
        }
        else
            return Set<T>().Remove(entity);
    }
    #endregion

    #region Method Overrides
    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Entity<EFUser>();
        var terminalConfig = modelBuilder.Entity<TerminalEx>();

        //terminalConfig.Map(b =>
        //{
        //    b.Property(c => c.Name).HasColumnName("TerminalName");
        //    b.Property(c => c.UseAutoAddDriverPayment).HasColumnName("useAutoAddlDrvPmt");
        //    b.Property(c => c.AutoPopulateAccountNumberForOrderEntry).HasColumnName("OEautoPopulateAccountNo");
        //    b.Property(c => c.AutoPopulateAddressesForOrderEntry).HasColumnName("OEautoPopulateAddresses");
        //}).ToTable("Terminals", "dbo").HasKey(d => d.TerminalId);

        // base.OnModelCreating(modelBuilder);
    }
    #endregion

    #region Stored Proicedure Calls
    public IEnumerable<EFUser> GetUser(int? id = null, string userName = null, string passwordHash = null)
    {
        return this.Database.SqlQuery<EFUser>(
            " exec dbo.GetUser @id, @userName, @passwordHash ",
            GetSqlParameter("id", System.Data.SqlDbType.Int, value: id),
            GetSqlParameter("userName", System.Data.SqlDbType.NVarChar, 100, userName),
            GetSqlParameter("passwordHash", System.Data.SqlDbType.NVarChar, 100, passwordHash));
    }
    #endregion

    #region Private Methods
    private static SqlParameter GetSqlParameter<T>(string name, System.Data.SqlDbType type, int? size = null, T? value = null) where T : struct
    {
        var res = new SqlParameter(name, type) { Value = value ?? (object)DBNull.Value };

        if (size.HasValue)
            res.Size = size.Value;

        return res;
    }

    private static SqlParameter GetSqlParameter(string name, System.Data.SqlDbType type, int size, string value)
    {
        return new SqlParameter(name, type, size) { Value = value ?? (object)DBNull.Value };
    }
    #endregion
}

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

    Xcelerator.Data.BizObjects.XceleratorContext.DoTest()

End Sub

#region Method Overrides
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
    modelBuilder.Entity<EFUser>();
    var terminalConfig = modelBuilder.Entity<TerminalEx>();

    //terminalConfig.Map(b =>
    //{
    //    b.Property(c => c.Name).HasColumnName("TerminalName");
    //    b.Property(c => c.UseAutoAddDriverPayment).HasColumnName("useAutoAddlDrvPmt");
    //    b.Property(c => c.AutoPopulateAccountNumberForOrderEntry).HasColumnName("OEautoPopulateAccountNo");
    //    b.Property(c => c.AutoPopulateAddressesForOrderEntry).HasColumnName("OEautoPopulateAddresses");
    //}).ToTable("Terminals", "dbo").HasKey(d => d.TerminalId);

    // base.OnModelCreating(modelBuilder);
}
#endregion