TrimEnd() and TrimStart() function

Sep 2, 2010 at 7:47 AM

Hi,

We have two databases SQL server and Foxpro. I put up the data access layer in my project which is based on IQToolKit and LINQtoVFP. So we can connect to SQL server and FoxPro as per requirement.

LinqTOVFP supports TrimEnd() and TrimStart() functions,  but IQToolKit SQL provider does not. So Following LINQ query fails with SQL server provider.

var list2 = (from d in

IQ.DEMOFs

where d.PASSWORD.TrimEnd().Length > 8  

 

 

select d).ToList<DEMOF>();

It would be nice if IQToolKit implements theses functions for better productivity and performance.