[Solved] ASP.Net MVC Error: LINQ to Entities does not recognize the method System.DateTime ToDateTime(System.Object)

Hi,

I am trying to get data using date from an mvc controller to view. But I am getting the below error. I searched a lot but unable to understand cause. Please help me getting out of this.

LINQ to Entities does not recognize the method 'System.DateTime ToDateTime(System.Object)' method, and this method cannot be translated into a store expression.

public ActionResult searchflight(string byflightDate, string byflightNo)
{
     
  if (byflightDate != null && byflightNo != null && byflightNo != string.Empty && byflightDate != string.Empty)
    {
        DateTime _byflightDate = Convert.ToDateTime(byflightDate);
        return View(db.tbl_FlightDetails.Where(x =>  Convert.ToDateTime(x.flightDate) == _byflightDate &&  x.flightNumber == byflightNo).ToList());
    }else if(byflightDate != null && byflightNo == string.Empty)
    {
        DateTime _byflightDate = Convert.ToDateTime(byflightDate);
        return View(db.tbl_FlightDetails.Where(x => Convert.ToDateTime(x.flightDate) == _byflightDate));
    }else if(byflightDate == null && byflightDate == string.Empty  && byflightNo != null && byflightNo != string.Empty)
    {
        return View(db.tbl_FlightDetails.Where(x => x.flightNumber == byflightNo || byflightNo == null).ToList());
    }
  else
    {
        return View(db.tbl_FlightDetails.Where(x => x.flightNumber == byflightNo || byflightNo == null).ToList());
    }          
}