C# (CSharp) TiendaVirtual.DataAccess DatabaseContext.Query Examples

Example #1

File: CostoEnvioDAO.cs Project: snahider/Test-Automation-NET

 public decimal Obtener(string pais)
 {
     using (var connection = new DatabaseContext().Database.Connection)
     {
         connection.Open();
         var costo = connection.Query<decimal>("Select costo from CostoEnvioPais where pais=@pais", new { pais }).Single();
         return costo;
     }
 }

Example #2

File: AlmacenDAO.cs Project: divyang4481/Presentations

 public int CantidadInventario(int productoId)
 {
     using (var connection = new DatabaseContext().Database.Connection)
     {
         connection.Open();
         var cantidad = connection.Query <int>("select cantidad from Inventario where productoId=@productoId", new { productoId }).Single();
         return(cantidad);
     }
 }

Example #3

 public decimal Obtener(string pais)
 {
     using (var connection = new DatabaseContext().Database.Connection)
     {
         connection.Open();
         var costo = connection.Query <decimal>("Select costo from CostoEnvioPais where pais=@pais", new { pais }).Single();
         return(costo);
     }
 }

Example #4

File: AlmacenDAO.cs Project: snahider/Test-Automation-NET

 public int CantidadInventario(int productoId)
 {
     using (var connection = new DatabaseContext().Database.Connection)
     {
         connection.Open();
         var cantidad=connection.Query<int>("select cantidad from Inventario where productoId=@productoId", new { productoId }).Single();
         return cantidad;
     }
 }