Provide prepared where statement in sql query parts

[rezarouzbahani]

Is your feature request related to a problem? Please describe. I need a property in SqlQueryParts which returns prepared where. For example instead of

where Id = @Param1

returns

where Id = 1

Describe the solution you'd like I've following code which works like a charm!

sqlQuery.WhereClause = Regex.Replace(sqlQuery.WhereClause, "@Param[0-9]", e =>
{
     string paramName = e.Value.Replace("@", "");
     object value = sqlQuery.Parameters[paramName];
     if (value is string strValue)
          return $"'{value}'";
     return value.ToString();
});

Describe alternatives you've considered N/A

Additional context N/A

[ysmoradi]

It's too risky if you use it without caution!

[lock[bot]]

This issue has been automatically locked due to inactivity. Please file a new issue if you are encountering a similar or related problem. Read more about our automatic conversation locking policy.