how to validate username and password from database using Linq in c# asp.net
i already make a " .dbml " file and also Stored Procedure name '' sp_LoginValidation''
i am used like this but it shows some error...........
LoginValidationDataContext check = new LoginValidationDataContext();
var result = from p in check.sp_LoginValidation ()
where p.UserName == LoginUser.UserName && p.Password = LoginUser.Password
select p.FirstOrDefault();
if (result != false)
{
Response.Redirect("UserRegistration.aspx");
}
else
{
Responce.write(" <script> alert ('invalid credentials')<script/>");
}
}