I'm think I just got my answer  the  ToDataSore() method seems to work.

Here's my latest code  and that seems to work

Daniel

var dataStore = new DataStore<Parts_List>(_dataContext);
            
          
            var Builder = _dataContext.SqlModelMapper.GetQueryBuilder<Parts_List>();
            Builder.RemoveWhere();
            Builder.WhereRaw("(description like  :description ) ", SqlBuilder.Parameter<string>("description"));
            Builder.AndWhereRaw("(pk_zones =  :pk_zones or :pk_zones is null) ", SqlBuilder.Parameter<int>("pk_zones"));
            
           var _parts = (Builder.Load("diode%",1)).ToList();
           var ds = _parts.ToDataStore();   
           return ds;

Hi Daniel,

There are some extension methods that convert an enumerable to a .NET DataStore, so you could chain them to your QueryBuilder's ToList() method like this:

var dataStore = dataContext.SqlModelMapper.GetQueryBuilder<Model>()
    .WhereRaw(....)
    .ToList()
    .ToDataStore(dataContext);

Please let me know if this helps you

Regards,
Francisco

Yes that did the trick.

However had to include the Load() method in the chain link for it to work.

  var ds2 = _dataContext.SqlModelMapper.GetQueryBuilder<Parts_List>()
            .WhereRaw("(description like  :description ) ", SqlBuilder.Parameter<string>("description"))
            .AndWhereRaw("(pk_zones =  :pk_zones or :pk_zones is null) ", SqlBuilder.Parameter<int?>("pk_zones"))
            .AndWhereRaw("(Parttype =  :parttype) ", SqlBuilder.Parameter<string>("parttype"))
            .AndWhereRaw("(inactive  =  :inactive) ", SqlBuilder.Parameter<int?>("inactive"))
            .Load(description + "%", pk_zones, parttype, 0, 0)
            .ToList()
            .ToDataStore(_dataContext);
         

Thanks Daniel