//Listar Usuarios public ActionResult Index() { List <ClienteEntity> lst = new List <ClienteEntity>(); using (PracticaMVCEntities1 db = new PracticaMVCEntities1()) { lst = (from c in db.Cliente select new PracticaMVC.Models.ClienteEntity { nombreCliente = c.nombreCliente }).ToList(); } #region [Dapper] PracticaMVCEntities1 db2 = new PracticaMVCEntities1(); List <ClienteEntity> lstD = new List <ClienteEntity>(); var conn = ConfigurationManager.ConnectionStrings["PracticaMVCEntities"].ConnectionString; using (IDbConnection db = new SqlConnection(conn)) { lstD = db.Query <ClienteEntity> ("Select * From Cliente").ToList(); } #endregion return(View(lst)); }
public List <ClienteEntity> ListarClienteXProfesion(int idProfesion) { List <ClienteEntity> lstClienteXProf = new List <ClienteEntity>(); using (PracticaMVCEntities1 db = new PracticaMVCEntities1()) { lstClienteXProf = (from c in db.Cliente join pc in db.ProfesionCliente on c.idCliente equals pc.idCliente where pc.idProfesion == idProfesion select new PracticaMVC.Models.ClienteEntity { nombreCliente = c.nombreCliente, genero = c.Genero.Trim() } ).ToList(); } return(lstClienteXProf); }
//Litar Profesiones public ActionResult About() { List <ProfesionEntity> lstP = new List <ProfesionEntity>(); using (PracticaMVCEntities1 db = new PracticaMVCEntities1()) { lstP = (from p in db.Profesion select new PracticaMVC.Models.ProfesionEntity { nombreProfesion = p.nombreProfesion, descripcion = p.descripcion, idProfesion = p.idProfesion } ).ToList(); } return(View(lstP)); }