public IEnumerable <Customer> GetCustomersWithAddressExemplifyingOneToOneRelationship()
{
var customers = new LinqQueryExampleMapper().GetCustomersWithAddressExemplifyingOneToOneRelationship();
return(customers);
}
public IEnumerable <string> GetCustomersNamesWithDistinct()
{
var customersNames = new LinqQueryExampleMapper().GetCustomersNamesWithDistinct();
return(customersNames);
}
public IEnumerable <Customer> GetCustomersWithAddressAndCartsBasedInWhereWithOperatorNOTIN()
{
var customers = new LinqQueryExampleMapper().GetCustomersWithAddressAndCartsBasedInWhereWithOperatorNOTIN();
return(customers);
}
public IEnumerable <Customer> GetCustomersWithAddressAndCartsBasedInUnion()
{
var customers = new LinqQueryExampleMapper().GetCustomersWithAddressAndCartsBasedInUnion();
return(customers);
}
public int GetCartsQuantityWithCOUNT()
{
var quantity = new LinqQueryExampleMapper().GetCartsQuantityWithCOUNT();
return(quantity);
}
public IEnumerable <ProductShippingRate> GetProductsWithShippingRatesExemplifyingManyToManyRelationship()
{
var productShippingRates = new LinqQueryExampleMapper().GetProductsWithShippingRatesExemplifyingManyToManyRelationship();
return(productShippingRates);
}
public IEnumerable <KeyValuePair <int, int> > GetCartIdsAndQuantityItemsWithGROUPBYSUM()
{
var carts = new LinqQueryExampleMapper().GetCartIdsAndQuantityItemsWithGROUPBYSUM();
return(carts);
}
public int GetQuantityItemsWithSUM()
{
var quantity = new LinqQueryExampleMapper().GetQuantityItemsWithSUM();
return(quantity);
}
public decimal GetQuantityItemsWithAVG()
{
var quantity = new LinqQueryExampleMapper().GetQuantityItemsWithAVG();
return(quantity);
}
public IEnumerable <Cart> GetCartsWithProductsExemplifyingOneToManyRelationship()
{
var carts = new LinqQueryExampleMapper().GetCartsWithProductsExemplifyingOneToManyRelationship();
return(carts);
}
public int GetCustomerIdWithMIN()
{
var customerId = new LinqQueryExampleMapper().GetCustomerIdWithMIN();
return(customerId);
}
public IEnumerable <KeyValuePair <int, DateTime> > GetCustomersIdsAndCartPurchaseDateWithGROUPBYMIN()
{
var customers = new LinqQueryExampleMapper().GetCustomersIdsAndCartPurchaseDateWithGROUPBYMIN();
return(customers);
}
public IEnumerable <KeyValuePair <int, int> > GetCustomersIdsAndCartsQuantityWithHAVING()
{
var customers = new LinqQueryExampleMapper().GetCustomersIdsAndCartsQuantityWithHAVING();
return(customers);
}
