public SurrogateProduct[] GetProductByName(string FirstLetter)
{
List <SurrogateProduct> products = new List <SurrogateProduct>();
using (NorthWindLibrary.NorthwindEntities model = new NorthWindLibrary.NorthwindEntities())
{
products = (from p in model.Products
where p.ProductName.ToUpper().Contains(FirstLetter.ToUpper())
select new SurrogateProduct
{
CategoryId = p.CategoryID,
ProductId = p.ProductID,
ProductName = p.ProductName
}).ToList <SurrogateProduct>();
}
return(products.ToArray());
}
//Service dışarıya DTO sınıfları göndercek (istemciye sadece DTO sınıfları veriyoruz.entity sınıfları vermiyoruz)
public SurrogateProduct[] GetProducts(int CategoryId)
{
List <SurrogateProduct> products = new List <SurrogateProduct>();
using (NorthWindLibrary.NorthwindEntities model = new NorthWindLibrary.NorthwindEntities())
{
products = (from p in model.Products
where p.CategoryID == CategoryId
select new SurrogateProduct
{
CategoryId = p.CategoryID,
ProductId = p.ProductID,
ProductName = p.ProductName
}).ToList <SurrogateProduct>();
}
return(products.ToArray());
}
