Re-Engineer queryable and enumerable extensions found in the System.Linq namespace from the SubSonic.Linq queryable extensions.

[kccarter76]

update the subsonic query provider to build the query when a System.Linq extension is used. The goal here is to remove any extension stubbed out in System.Linq.Queryable and System.Linq.Enumerable from SubSonic.Linq.SubSonicQueryable. This should allow us to rename it to SubSonic.Linq.Queryable.

this will also make life simpler for developers to use the SubSonic Core data access layer.

[kccarter76]

the query provider will not support ElementAt, it makes no sense to do so when the query against the db would return every record in the database table.

[kccarter76]

I have been able to unwind back to the original issue that sent me down this rabbit hole.

Unable to cast object of type 'WhereEnumerableIterator1[SubSonic.Extensions.Test.Models.Unit]' to type 'SubSonic.ISubSonicCollection1[SubSonic.Extensions.Test.Models.Unit]'

has anyone seen this issue? this is a internal enumerator to the System.Linq namespace. I personal think I need to rethink the DbWhereExpression. I may need to do something I have not thought of, yet.

Update:

refactored the DbWhereExpression to implement the IArgurmentProvider and IDbParameterProvider interfaces and modeled it after MethodCallExpression. Since MethodCallExpression can not be inherited from at this time. we added additional overrides that allow us to reduce the DbWhereExpression to a MethodCallExpression. We also implemented code that allows for a WhereExpression to merge with the where already attached to the Query.