ASP.net mvc ef codfirst
ActionResult Index()
Controller
public class PersonalController : Controller { private SchoolContext db = new SchoolContext(); private string FirstName_keyword = "1"; private string LastName_keyword = "1"; private string Phone_keyword = "1"; public ActionResult Index() { var listOfPersonal = db.Personals.Where(current => current.FirstName.Contains(FirstName_keyword) & current.LastName.Contains(LastName_keyword) & current.Phone.Contains(Phone_keyword)).ToList(); return View(listOfPersonal);
SELECT * FROM Personals
from Personals in db.Personals select new { PersonID = Personals.PersonID, FirstName = Personals.FirstName, LastName = Personals.LastName, Phone = Personals.Phone }
var listOfPersonal = from Personals in db.Personals select new { FirstName = Personals.FirstName, LastName = Personals.LastName, Phone = Personals.Phone }; return View(listOfPersonal);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)