What to put as the Provider for a mocked IQueryable

Question

I am working with Moles and mocking a System.Data.Linq.Table.

I got it constructing fine, but when I use it, it wants IQueryable.Provider to be mocked (moled) as well.

I just want it to use normal Linq To Objects. Any idea what that would be?

Here is the syntax I can use:

MTable<User> userTable = new System.Data.Linq.Moles.MTable<User>();
userTable.Bind(new List<User> { UserObjectHelper.TestUser() });

// this is the line that needs help
MolesDelegates.Func<IQueryProvider> provider = //Insert provider here!
                                                             ^
userTable.ProviderSystemLinqIQueryableget = provider         |
                                                             |
                                                             | 
what can I put here? ----------------------------------------+

Johannes Rudolph · Accepted Answer · 2010-02-12T13:51:03.540

7

Simplest would be a List<T> which can be used as IQueryable<T> via .AsQueryable().

MolesDelegates.Func<IQueryProvider> provider = () => userLinqList.AsQueryable().Provider;

That's what I use as a in memory database to mock out Linq2Sql. Simple and elegant.

edited Feb 12 '10 at 13:51

answered Feb 11 '10 at 17:16

Johannes Rudolph

35,298
14
114
172

`MolesDelegates.Func provider = new List();` says that List does not convert to MolesDelegates.Func – Vaccano Feb 11 '10 at 17:17
1

`MolesDelegates.Func provider = new List().AsQueryable().Provider` – Johannes Rudolph Feb 11 '10 at 17:38
Thanks for the tip. The syntax turned out to be: `MolesDelegates.Func provider = () => userLinqList.AsQueryable().Provider;` – Vaccano Feb 11 '10 at 19:28
yeah, glad you could figure it out. I am on the road atm and SO is terrible on iPhone :-) – Johannes Rudolph Feb 12 '10 at 05:55

score 0 · Answer 2 · answered Mar 21 '10 at 03:47

0

The simple solution would be to bind the list.AsQueryable() to the table. The IQueryable methods would automatically be rerouted to the list.

answered Mar 21 '10 at 03:47

Peli

2,465
16
17

What to put as the Provider for a mocked IQueryable

2 Answers2

Linked