expression cannot contain query expressions

Hi Kladane,

Your Only have to specify the return type of the query.
Here is an example.

Employee ObjEmployee = new Employee();
ObjEmployee = ObjEmployee.GetAllEmployee().Where(emp => emp.EmployeeCode == txtempcode.Text).FirstOrDefault(); //allows you to get the first user that matches your condition. 

.SingleOrDefault() //allows you to get the UNIQUE user that matches your condition. if your there is more than one that matches your condition, an exception will be thrown.

.ToList() // you are selecting a list of employee. in this case, you have to declare a list of //employee instead of a single instance.
List<employee> ObjEmployeeList = new List<employee>();
ObjEmployeeList = ObjEmployeeList.GetAllEmployee().Where(emp => emp.EmployeeCode == txtempcode.Text).ToList(); 

</employee></employee>

One Detail thought, the syntax may be incorrect based on your method(GetAllEmployee) code.
I generaly write GetAll method as static so it is independent form the instance.
In that case. the code will be like this.

List<employee> ObjEmployeeList = new List<employee>();
ObjEmployeeList = Employee.GetAllEmployee().Where(emp => emp.EmployeeCode == txtempcode.Text).ToList(); 
</employee></employee>

Hope it helps