I've been working on a Linq provider Sql that currently provides the following features:
- Comprehensive support for SQLite, SQLServer 2000/2005, MS Access, Transparently query multiple databases in one expression e.g. an MS Access Database and an SQL Server Database
- Translates function calls and property accessors in the
String, DateTime and Nullable`1 classes that have SQL equivalents e.g. firstName.Length, firstName.ToUpper(), orderDate.Year, shippedDate.HasValue etc.
- Implements all IQueryable methods e.g. GroupBy, Any, All, First, Sum, Average etc.
- Correctly and comprehensively translates binary and unary expressions that have valid translations into SQL.
- Parameterizes queries instead of embedding constants in the SQL transformation.
- Performs caching of previously translated expression trees.
- Does not use MARS - Multiple Active Result Sets, an SQL Server 2005 specific feature.
- Correctly translates calls to
SelectMany even when the query sources involve method calls. The SQL Server 2005 specific keyword CROSS APPLY is neither required nor used.
I've used you're ADO.NET provider to support SQLite. Thanks for the great work.
Cheers!