elvijsost

=== VIEW (Index.cshtml)

@model IEnumerable<App.Models.PROVIDER>

@{
    ViewBag.Title = "Index";
}

<h2>Hello from Index</h2>

<ol>
    @foreach (var item in Model)
    {
        <li>@item.PROV_ID - <strong>@item.PROV_FIRSTNAME</strong>: @item.PROV_LASTNAME</li>
    }
</ol>

=== CONTROLLER (ProviderController.cs)

using App.Models;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;

namespace App.Controllers
{
    public class ProviderController : Controller
    {
        private Lel lel = new Lel();

        public ActionResult Index()
        {
            var zxc = lel.PROVIDERS.ToList();

            return View(zxc);
        }
    }
}

=== MODEL (Lel.cs)

namespace App.Models
{
    using System;
    using System.Data.Entity;
    using System.ComponentModel.DataAnnotations.Schema;
    using System.Linq;

    public partial class Lel : DbContext
    {
        public Lel()
            : base("name=Lel")
        {
        }

        public virtual DbSet<PROVIDER> PROVIDERS { get; set; }

        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            modelBuilder.Entity<PROVIDER>()
                .Property(e => e.PROV_ID)
                .IsUnicode(false);

            modelBuilder.Entity<PROVIDER>()
                .Property(e => e.PROV_LASTNAME)
                .IsUnicode(false);

            modelBuilder.Entity<PROVIDER>()
                .Property(e => e.PROV_FIRSTNAME)
                .IsUnicode(false);

            modelBuilder.Entity<PROVIDER>()
                .Property(e => e.PROV_MIDDLEINITIAL)
                .IsUnicode(false);

            modelBuilder.Entity<PROVIDER>()
                .Property(e => e.PROV_LOGINNAME)
                .IsUnicode(false);

            modelBuilder.Entity<PROVIDER>()
                .Property(e => e.PROV_SSNUM)
                .IsUnicode(false);

            modelBuilder.Entity<PROVIDER>()
                .Property(e => e.PROV_PASSWORD)
                .IsUnicode(false);

            modelBuilder.Entity<PROVIDER>()
                .Property(e => e.PROV_TITLE)
                .IsUnicode(false);

            modelBuilder.Entity<PROVIDER>()
                .Property(e => e.PROV_SUFFIX)
                .IsUnicode(false);

            modelBuilder.Entity<PROVIDER>()
                .Property(e => e.PROV_UPIN)
                .IsUnicode(false);

            modelBuilder.Entity<PROVIDER>()
                .Property(e => e.PROV_DEAID)
                .IsUnicode(false);

            modelBuilder.Entity<PROVIDER>()
                .Property(e => e.PROV_NHLID)
                .IsUnicode(false);

            modelBuilder.Entity<PROVIDER>()
                .Property(e => e.PROV_BILLING_SW)
                .IsFixedLength()
                .IsUnicode(false);

            modelBuilder.Entity<PROVIDER>()
                .Property(e => e.BLOCKLABLINKMSG_SW)
                .IsFixedLength()
                .IsUnicode(false);

            modelBuilder.Entity<PROVIDER>()
                .Property(e => e.PROV_CANREVIEWCHARTS_SW)
                .IsFixedLength()
                .IsUnicode(false);

            modelBuilder.Entity<PROVIDER>()
                .Property(e => e.PROV_EDIID)
                .IsUnicode(false);

            modelBuilder.Entity<PROVIDER>()
                .Property(e => e.PROV_INITIALS)
                .IsUnicode(false);

            modelBuilder.Entity<PROVIDER>()
                .Property(e => e.NPI)
                .IsUnicode(false);

            modelBuilder.Entity<PROVIDER>()
                .HasMany(e => e.PROVIDERS1)
                .WithOptional(e => e.PROVIDER1)
                .HasForeignKey(e => e.PROV_REFILLMGR);
        }
    }
}

=== MODEL (Provider.cs)

namespace App.Models
{
    using System;
    using System.Collections.Generic;
    using System.ComponentModel.DataAnnotations;
    using System.ComponentModel.DataAnnotations.Schema;
    using System.Data.Entity.Spatial;

    [Table("HPSITE.PROVIDERS")]
    public partial class PROVIDER
    {
        public PROVIDER()
        {
            PROVIDERS1 = new HashSet<PROVIDER>();
        }

        [Key]
        public int IMREPROV_CODE { get; set; }

        [Required]
        [StringLength(20)]
        public string PROV_ID { get; set; }

        [Required]
        [StringLength(30)]
        public string PROV_LASTNAME { get; set; }

        [Required]
        [StringLength(30)]
        public string PROV_FIRSTNAME { get; set; }

        [StringLength(5)]
        public string PROV_MIDDLEINITIAL { get; set; }

        [StringLength(20)]
        public string PROV_LOGINNAME { get; set; }

        [StringLength(11)]
        public string PROV_SSNUM { get; set; }

        public int? PROV_TYPE { get; set; }

        public byte? PROV_ACTIVITY { get; set; }

        [StringLength(100)]
        public string PROV_PASSWORD { get; set; }

        public DateTime? PROV_LASTPASSWORDCHANGE { get; set; }

        public DateTime? PROV_DEAEXPIRE { get; set; }

        public int? PROV_ADDRCODE { get; set; }

        public int? PROV_SPECIALTY { get; set; }

        [StringLength(10)]
        public string PROV_TITLE { get; set; }

        [StringLength(10)]
        public string PROV_SUFFIX { get; set; }

        [StringLength(20)]
        public string PROV_UPIN { get; set; }

        [StringLength(20)]
        public string PROV_DEAID { get; set; }

        [StringLength(20)]
        public string PROV_NHLID { get; set; }

        public byte? PROV_REFERRAL { get; set; }

        public int? PROV_LOGINCOUNT { get; set; }

        public DateTime? PROV_AGREETOLICENSE { get; set; }

        public short? PROV_LICENSETYPE { get; set; }

        public byte? PROV_LOGINATTEMPTS { get; set; }

        public int TAG_AUTHORCODE { get; set; }

        public DateTime TAG_SYSTEMDATE { get; set; }

        public byte TAG_ARCHIVED { get; set; }

        public int? PROV_REFILLMGR { get; set; }

        [Required]
        [StringLength(1)]
        public string PROV_BILLING_SW { get; set; }

        public int? PROV_CHARTREVIEWER { get; set; }

        [Required]
        [StringLength(1)]
        public string BLOCKLABLINKMSG_SW { get; set; }

        [Required]
        [StringLength(1)]
        public string PROV_CANREVIEWCHARTS_SW { get; set; }

        [StringLength(30)]
        public string PROV_EDIID { get; set; }

        [StringLength(4)]
        public string PROV_INITIALS { get; set; }

        [StringLength(20)]
        public string NPI { get; set; }

        public byte SIGNOFFPRIVILEGE_CODE { get; set; }

        public int? PROV_SERVICELEVEL { get; set; }

        public virtual ICollection<PROVIDER> PROVIDERS1 { get; set; }

        public virtual PROVIDER PROVIDER1 { get; set; }
    }
}

=== Web.config

<add name="EMR_Connection" connectionString="Data Source=192.168.0.13; Initial Catalog=EMR; User ID=hpreports; Password=H99999P" providerName="System.Data.SqlClient" />
    <add name="Lel" connectionString="data source=192.168.0.13;initial catalog=EMR;user id=hpreports;password=H99999P;MultipleActiveResultSets=True;App=EntityFramework" providerName="System.Data.SqlClient" />