public List <Product> AjaxMethod(Product Pro)
{
List <Product> Product1;
elpatobookresellEntities db = new elpatobookresellEntities();
Product1 = db.Products.Where(p => p.BookName.Contains(Pro.BookName)).ToList();
return(Product1);
}
public ActionResult Loaddata()
{
//String SQL = "SELECT ProductId, Products.CategoryId AS CategoryId, BookName, ImageFileName, UnitCost,ISBNNum,userID"
// + ", SUBSTRING(Description, 1, 100) + '...' AS Description, IsDownload, DownloadFileName "
// + "FROM Products INNER JOIN Categories ON Products.CategoryId = Categories.CategoryId ";
// var products = db.Products.SqlQuery(SQL);
using (elpatobookresellEntities dc = new elpatobookresellEntities())
{
// dc.Configuration.LazyLoadingEnabled = false;
// if your table is relational, contain foreign key
string sql = @"SELECT [ProductId],[CategoryId],[BookName],[ImageFileName],[UnitCost]
,[Description],[IsDownload],[DownloadFileName],[ISBNNum],[userID]
FROM[dbo].[Products] ";
List <Product> products1 = dc.Database.SqlQuery <Product>(sql).ToList();
var d1 = Json(new { data = products1 }, JsonRequestBehavior.AllowGet);
return(d1);
}
}