Hi Tony,

You will be able to delete the parameters using ISqlQueryBuilder’s RemoveWhere method in the next release. For the time being, please use the workaround you posted in the other reply.

Thanks & Regards,
David

Hi Tony,

You can use SqlModelMapper’s RemoveWhere function to see if it resolves your issue. For example, you can write your service like this:

var builder = _dataContext.SqlModelMapper.GetQueryBuilder<MyClass>();
            
builder.RemoveWhere();
             

List<MyClass>  result = (await builder.LoadAsync()).ToList();

You can refer to the following link for more details:

https://docs.appeon.com/snapobjects/3.0/api_reference/SnapObjects.Data/SqlModelMapper/IQueryBuilder/Method/RemoveWhere.html

Regards,

David  

I have no idea how to remove the params of a ISqlQueryBuilder. The ISqlQueryBuilder.UsedParameters gives me an IReadOnlyDictionary<string, ISqlParameter> - its read only and I can't modify it.

so i coded a little workaround, its not perfect, but its works.

my service;

List<MyClass> myClasses = new List<MyClass>();

var builder = ModelSqlBuilder.GetBuilder<MyClass>(_dataContext)
.GetQueryBuilder(sqlselect);

builder.RemoveWhere();

var dynamicModels = (await _dataContext.SqlExecutor.SelectAsync<DynamicModel>(
builder.ToSqlString(_dataContext),
new object[] { },
default)).ToList();

foreach (var dynamicModel in dynamicModels)
myClasses .Add(new MyClass(dynamicModel));

return myClasses;

and my new constructor;

public MyClass(DynamicModel dynamicModel)
{
var props = typeof(MyClass).GetProperties();

foreach (var paramprop in dynamicModel?.Properties)
{
var prop = props.First(x => x.GetCustomAttribute<SqlColumnAttribute>().Column == paramprop.Name);
prop.SetValue(this, dynamicModel.GetValue(prop.GetCustomAttribute<SqlColumnAttribute>().Column));
}
}