I'm having an issue with SqlModelMapper when I'm trying to Load with a modified SqlQueryBuilder. If I call SqlExecutor.Select with the SqlQueryBuilder it works ok, but if I call SqlModelMapper.Load with the same SqlQueryBuilder, it seems to ignore it and just use it's original query.
I want to use SqlModelMapper to take advantage of the nested model feature, otherwise I would just use SqlExecutor.
Originally I noticed the issue with some complex sql and model, but I can reproduce it with a simple model and sql. My function is below (I just uncomment the relevant return line to test both cases). Can anyone see any issues with my code?
public IList<codeDetails> Retrieve()
ISqlQueryBuilder queryBuilder =
queryBuilder.AsWhere().AndWhereRaw("code_details.table_id = 'PN'");
string sql = queryBuilder.ToSqlString(_dataContext);
// This line works as expected
// This line ignores the modified queryBuilder