Click here to Skip to main content
15,887,416 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi i work winform for many years.
now i wants to learn
ASP.net mvc ef codfirst
but it is very complex for me.
i put below code in
ActionResult Index()
of
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);


then i change sql command :
SELECT * FROM Personals
to linq
from Personals in db.Personals
select new {
PersonID = Personals.PersonID,
FirstName = Personals.FirstName,
LastName = Personals.LastName,
Phone = Personals.Phone
}

then i put it in source as below.but it's eror

var listOfPersonal =
from Personals in db.Personals
select new
{
FirstName = Personals.FirstName,
LastName = Personals.LastName,
Phone = Personals.Phone
};

return View(listOfPersonal);


thanks. very much

What I have tried:

i study very much
search and .....
but no get any thing
help me
Posted
Comments
Richard MacCutchan 26-Dec-19 10:30am    
What error did you receive?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900