//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));
}
