EntitySchemaQuery get ColumName and value

You could create new ESQ instance, then pull columns with the addcolumn method, then do something with that date. 

Example:

//Create esq instance 

var esq = new EntitySchemaQuery(UserConnection.EntitySchemaManager, "Account");

//Add column method returns object, and save a reference to column object in var nameColumn

var nameColumn = esq.AddColumn("Name");

//add a filter or more columns . . .

//when youre finished setting up the columns and filter you can run the "GetEntityCollection" method to grab data

var entityCollection = esq.GetEntityCollection(UserConnection);

//do something with data 

return true;

What exactly are you trying to do?

Please find the answer in the post by the link below

https://community.bpmonline.com/questions/get-title-columns-esq