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

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

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;