Is it possible to write a custom provider using a DAL that does not support IQueryable
All of the providers that Sitefinity use contain at least one method that returns an IQueryable object. Is there any way I can write a custom provider if my DAL does not support IQueryable?
Hello
Unfortunately, the membership provider and the other providers use IQueryable when getting collection of items, in order to be able to filter it later on. The provider has to be implemented using queryable collections since the derived classes and interfaces need them. The MembershipDataProvider we have provided is made the way it is, so we ensure if you override the methods we can provide all the functionality working as expected and as the default membership provider. You can use the AsQueryable extension method on the queried collection, however, since all items are loaded this will slow down performance. You can see from our full code sample that we have also done this in some of the methods where this is inevitable.
Regards,
Nikola Zagorchev
Telerik