Cool, I just added the logic and ran this query. Notice how I call query.ExecuteReader()

EmployeesQuery query = new EmployeesQuery();
query.Select(query.FirstName, query.LastName);
query.Where(query.LastName.Like("Gri%"));

using (IDataReader reader = query.ExecuteReader())
{
    while (reader.Read())
    {
        string s;

        s = reader.GetString(0);
        s = reader.GetString(1);
    }
}

I'll ping you when a test build is up for you in a day or so ...

Ok, the unit tests are passing! Here are a couple of questions/ suggestions:

-overload the ExecuteQuery() method to allow for CommandBahavior as a param

-IDataReaders can have multiple steps. Take this example:

http://www.developerfusion.co.uk/show/4638/

How can we accomplish this using EntitySpaces? A common usage of a multi-step datareader i have seen is when you want to get a certain page of a result set but also need know how many results there are in total. "Results 10-50 of 50,000"

Comments?

I haven't been playing with the IDataReader interface at all, but I like what you are proposing it can do.

NOTE: I also want to be cautious or careful to avoid database dependent solutions. (I.e. I want the same code to work for every db). I don't know if this ventures into that territory or not; albeit, the occassional override to gain some needed feature is generally worth it.

Ya, I will add look at the other options, this should all be Database independent as well. One note however, I'm thinking of changing the API from this:

query.ExecuteReader()

to

query.es.ExecuteReader()

so this doesn't clutter up the API, still not sure on that though? What do you guy think.

martinmizzell:

Ok, the unit tests are passing! Here are a couple of questions/ suggestions:

-overload the ExecuteQuery() method to allow for CommandBahavior as a param

-IDataReaders can have multiple steps. Take this example:

http://www.developerfusion.co.uk/show/4638/

How can we accomplish this using EntitySpaces? A common usage of a multi-step datareader i have seen is when you want to get a certain page of a result set but also need know how many results there are in total. "Results 10-50 of 50,000"

Comments?

 Has anyone had a chance to look at multi-step datareaders?

Hi Mike,

 It has been a few days and i havent heard anything back. I know y'all are likely busy with the 2009 version. If you don't think it fits into the vision of the product or it would be a long time to add it, please let me know and i will buy the source and personally code it.

 Thanks!

 Martin

I have been pondering the concept this afternoon and thinking about how it could be done. Without looking at your source code, I would assume that you do something like this:

IDataReader ExecuteReader()

{

IDbCommand command = DbConnection.CreateCommand();

command.CommandText = esQuery.RenderTheCurrentQueryToText(); <-- something like that, right?

return command.ExecuteReader();

}

what if the ExecuteReader method was static and took a (param esQuery[] )?

or what about using a decorator on the class itself?

We are definitely on the same page. I think this will be a great addition to the product and I will use it extensively. I don't know if you have an early experience program but I would like to be a part of any betas if you would allow it.