public List<string> Search(string criteria) { var context = new AdventureWorksEntities(); var query = context.ExecuteStoreQuery<string>("Select Name from Production.Product Where Freetext(*,{0})", criteria); return query.ToList(); }
public List<string> Search(string criteria) { var context = new AdventureWorksEntities(); var query = context.Database.SqlQuery<string>("Select Name from SalesLT.Product Where Freetext(*,{0})", criteria); return query.ToList(); }
public List<string> GetProducts() { List<string> products = null; AdventureWorksEntities context = new AdventureWorksEntities(); var query = from product in context.Products select product.Name; products = query.ToList(); return products; }