Why Context Return Null in entity framework

Question

why validate return null although i have it public Registration ValidateUser( string userName, string passWord) { try { using (var _context = new DatabaseContext()) { var validate = (from user in _context.Registration where user.Username == userName && user.Password == passWord select user).SingleOrDefault(); var users=_context.Registration; return validate; } } catch (Exception) { throw ; } } public DbSet Registration { get ; set ; } and in db i have Registration table with records

Mark Tabor · Answer

Here is complete code public partial class DatabaseContext : DbContext { public DatabaseContext() : base ( "name=TimesheetDBEntities" ) { } public class Registration { [Key] public int RegistrationID { get ; set ; } [Required(ErrorMessage = "Enter Name" )] public string Name { get ; set ; } [Required(ErrorMessage = "Mobileno Required" )] [RegularExpression(@ "^(\d{10})$" , ErrorMessage = "Wrong Mobileno" )] public string Mobileno { get ; set ; } [Required(ErrorMessage = "EmailID Required" )] [RegularExpression(@ "^([a-zA-Z0-9_\-\.]+)@(($$[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([a-zA-Z0-9\-]+\.)+))([a-zA-Z]{2,4}|[0-9]{1,3})($$?)$" , ErrorMessage = "Please enter a valid e-mail adress" )] public string EmailID { get ; set ; } [MinLength(6, ErrorMessage = "Minimum Username must be 6 in charaters" )] [Required(ErrorMessage = "Username Required" )] public string Username { get ; set ; } [MinLength(7, ErrorMessage = "Minimum Password must be 7 in charaters" )] [Required(ErrorMessage = "Password Required" )] public string Password { get ; set ; } [Compare( "Password" , ErrorMessage = "Enter Valid Password" )] public string ConfirmPassword { get ; set ; } [Required(ErrorMessage = "Gender Required" )] public string Gender { get ; set ; } public DateTime? Birthdate { get ; set ; } public DateTime? DateofJoining { get ; set ; } public int ? RoleID { get ; set ; } [MaxLength(5, ErrorMessage = "Minimum Password must be 7 in charaters" )] public string EmployeeID { get ; set ; } public DateTime? CreatedOn { get ; set ; } public int ? ForceChangePassword { get ; set ; } } public Registration ValidateUser( string userName, string passWord) { try { using (var _context = new DatabaseContext()) { var validate = (from user in _context.Registration where user.Username == userName && user.Password == passWord select user).SingleOrDefault(); var users=_context.Registration; return validate; } } catch (Exception ex) { string mess=ex.Message; throw ; } } if (! string .IsNullOrEmpty(loginViewModel.Username) && ! string .IsNullOrEmpty(loginViewModel.Password)) { var Username = loginViewModel.Username; var password = EncryptionLibrary.EncryptText(loginViewModel.Password); var result = _ILogin.ValidateUser(Username, password); this result return null all the time

Mark Tabor · Answer

Thanks Manoj As below is my query it return the record below is the project which i downloaded and running i changed the connection string https://www.c-sharpcorner.com/article/timesheet-project-process-using-mvc-5/

Manoj Bhoir · Answer

Hi, Your code looks perfect. Please check that parameter values you are passing userName and passWord for those values records are present in the table. Try to execute Select Query on your DB with same userName and passWord and check record exist. I think your DB does not contain record for those parameter. In your question you have mentioned that Context return Null which is different. If your Context object itself is null then it indicates that your DB connection is not properly initiatlized. In this case you need to check your Entity Framework DB configuration/Connection String.