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.PASSWORD.TrimEnd().Length > 8
It would be nice if IQToolKit implements theses functions for better productivity and performance.