How to convert early bound query to IQueryable

Question

Assuming that AccountSet returns an IQueryable<Account>, how can I convert this early binding:

XrmServiceContext _xrmServiceContext;
var result = _xrmServiceContext.AccountSet.FirstOrDefault(x => x.Id == locationGuid);

Into something that is more reusable like:

_xrmServiceContext.Where(Set == "Account").FirstOrDefault(x => x.Id == locationGuid);

AccountSet is defined as:

    public System.Linq.IQueryable<Xrm.Account> AccountSet
    {
        get
        {
            return this.CreateQuery<Xrm.Account>();
        }
    }

How do I generalize this to be reusable for any IQueryable member of XrmServiceContext ?

this is similar to what i would like to do but it uses reflection, something that i want to avoid, http://stackoverflow.com/a/38198824/6761907 — Alex Gordon, Feb 24 '17 at 21:20

score 1 · Answer 1 · edited May 23 '17 at 12:00

1

As long as the Id is the primary key you can use that in conjunction with find to make a generic call

public T Get<T>(object[] Id)
      where T : class
{
    return _xrmServiceContext.Set<T>().Find(Id )
}

if your looking for an IQueryable that may be a bit harder but you can find out how to do that off of a previous question I asked:

Entity Framework Filter By PrimaryKey

edited May 23 '17 at 12:00

Community

1
1

answered Feb 24 '17 at 20:45

johnny 5

19,893
50
121
195

but it could be Xrm.Account, or Xrm.Contact, or a lot of other classes – Alex Gordon Feb 24 '17 at 21:12
The set function looks up the db set based off of its entity type – johnny 5 Feb 24 '17 at 21:15
this is similar to what i want to do but it uses reflection http://stackoverflow.com/a/38198824/6761907 – Alex Gordon Feb 24 '17 at 21:17
@MeggieLuski what are you confused about here, the type passed into the set is generic so you create a generic function get and that passes to to the context and gets the entity set – johnny 5 Feb 24 '17 at 21:20
there's no "set" method – Alex Gordon Feb 24 '17 at 21:30
You might just be missing a using hit ctrl . On the red underline see if there is an add using – johnny 5 Feb 24 '17 at 21:39

score 1 · Answer 2 · answered Feb 24 '17 at 21:39

1

Courtesy of this post, I've found the following solution:

private static T EntityGet<T>(Guid id)
    where T : Entity
{
    T item =
    (
        from query in Context.CreateQuery<T>()
        where query.Id == id
        select query
    ).Single();

    return item;
}

answered Feb 24 '17 at 21:39

Alex Gordon

57,446
287
670
1,062

How are you to specify that T has an id – johnny 5 Feb 24 '17 at 21:59
T is an Entity, and Entity has id – Alex Gordon Feb 24 '17 at 22:00

How to convert early bound query to IQueryable

2 Answers2