I want to do reproduce this query n ES. Is it possible? How?

Code:

1    select '1' as test, * from employee

where '1' is the value of a C# variable

 So, let's say I have this:

string name = "John";

I want to put the value of  the variable "name" inside the query.

thanks

You will either have to use in-line raw SQL, or a custom Load.

string name = "John";

EmployeesQuery eq = new EmployeesQuery("e");
eq.Select("<'" + name + "' AS Name>", eq);

EmployeesCollection collection = new EmployeesCollection();
collection.Load(eq);

Just to Correct. Name needs to be enclosed by single quote

Thanks. Perfect!!!

Code:
1    string name = "John";
2    
3    EmployeesQuery eq = new EmployeesQuery("e");
4    eq.Select("<'" + name + "' AS 'Name'>", eq);
5    
6    EmployeesCollection collection = new EmployeesCollection();
7    collection.Load(eq);
8    
9