NHibernate - Working with dynamic created Table

Question

I use Fluent NHibernate for project. Some database table created with SQL query dynamically. I execute sql select query as follow, but it return -1.

 var query = $"Select * from {tableName}";
 var obj = Session.CreateSQLQuery(query).ExecuteUpdate();// result is -1

My question is how can I work easily with dynamic created tables in NHibernate - SELECT, INSERT, UPDATE, DELETE?

Answer 1

The below code would suffice.

var tableName = "YourTableName";
var query = $"Select * from " + tableName;