.Net Entity Framework & POCO ... querying full table problem

Posted by Chris Klepeis on Stack Overflow See other posts from Stack Overflow or by Chris Klepeis
Published on 2010-05-25T21:08:44Z Indexed on 2010/05/25 21:21 UTC
Read the original article Hit count: 263

I'm attempting to implement a repository pattern with my poco objects auto generated from my edmx.

In my repository class, I have:

IObjectSet<E> _objectSet;
private IObjectSet<E> objectSet
{
    get
    {
        if (_objectSet == null)
        {
            _objectSet = this._context.CreateObjectSet<E>();
        }
        return _objectSet;
    }
}

public IQueryable<E> GetQuery(Func<E, bool> where)
{
    return objectSet.Where(where).AsQueryable<E>();
}

public IList<E> SelectAll(Func<E, bool> where)
{
    return GetQuery(where).ToList();
}

Where E is the one of my POCO classes. When I trace the database and run this:

IList<Contact> c = contactRepository.SelectAll(r => r.emailAddress == "[email protected]");

It shows up in the sql trace as a select for everything in my Contact table. Where am I going wrong here? Is there a better way to do this? Does an objectset not lazy load... so it omitted the where clause? This is the article I read which said to use objectSet's... since with POCO, I do not have EntityObject's to pass into "E"

http://devtalk.dk/CommentView,guid,b5d9cad2-e155-423b-b66f-7ec287c5cb06.aspx

© Stack Overflow or respective owner

Related posts about .NET

Related posts about entity-framework