C# (CSharp) Farmacia2Entitiesの例

コード例 #1

 public IEnumerable <Medicamentos> Get()
 {
     using (Farmacia2Entities Medicamentos = new Farmacia2Entities())
     {
         return(Medicamentos.Medicamentos.ToList());
     }
 }

コード例 #2

 public Medicamentos Get(int id)
 {
     using (Farmacia2Entities Medicamento = new Farmacia2Entities())
     {
         return(Medicamento.Medicamentos.FirstOrDefault(e => e.Codigo == id));
     }
 }

コード例 #3

 public IEnumerable <Medicamentos> ListarMedicamentos(string medicamento)
 {
     using (Farmacia2Entities farm = new Farmacia2Entities())
     {
         return(farm.Medicamentos.SqlQuery("SELECT * FROM Medicamentos WHERE Medicamento LIKE '" + medicamento + "%';").ToList());
     }
 }