Why Context Return Null in entity framework

Mark Tabor

7y15.6k.NET

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mark Tabor7y ago
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
0
Mark Tabor7y ago
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/
0
Manoj Bhoir7y ago
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.
0