Databases
StackOverflow2013
Postsdbo
POEntityframework 4.0 .CreateQuery<T> and OrderBy exception
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POEntityframework 4.0 .CreateQuery<T> and OrderBy exception
    primarykey
    data
    text
    <p>I thought this was fixed in 4.0. I have this method </p> <pre><code>public IQueryable&lt;T&gt; All(Expression&lt;Func&lt;T,object&gt;&gt; sort) { return EntityContext.CreateQuery&lt;T&gt;(EntityName).AsQueryable&lt;T&gt;().OrderBy(sort); } </code></pre> <p>this throws the following exception</p> <blockquote> <p>Unable to cast the type 'System.Int32' to type 'System.Object'. LINQ to Entities only supports casting Entity Data Model primitive types. Source is System.Data.Entity</p> </blockquote> <p>Any idea how to fix this or if there's any workaround This happens with every call when the order is not a string datatype</p> <pre><code>IQueryable&lt;Blog&gt; sortedAll = _repository.All(x =&gt; x.Title); </code></pre> <p>since Title is a string the orderBy works fine. but it fails with any other datatypes</p> <p>Since I came up with this "bad" solution before I seen Marc's. I thought I post it </p> <pre><code>public IQueryable&lt;T&gt; All(Expression&lt;Func&lt;T,object&gt;&gt; sort) { var expresssionType = sort.Body.GetType(); string propertyName= expresssionType == typeof(System.Linq.Expressions.UnaryExpression) ? ((MemberExpression)((UnaryExpression)sort.Body).Operand).Member.Name : ((MemberExpression)sort.Body).Member.Name; var items= EntityContext.CreateQuery&lt;T&gt;(EntityName).AsQueryable&lt;T&gt;(); var type = typeof(T); var expressionProperty = type.GetProperty(propertyName); var exPressionparameter = Expression.Parameter(type, "p"); var propertyAccess = Expression.MakeMemberAccess(exPressionparameter, expressionProperty); var orderByExp = Expression.Lambda(propertyAccess, exPressionparameter); Expression resultExp = Expression.Call(typeof(Queryable), "OrderBy", new Type[] { type, expressionProperty.PropertyType }, items.Expression, Expression.Quote(orderByExp)); return items.AsQueryable().Provider.CreateQuery&lt;T&gt;(resultExp); } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USSammy
    1. USSammy
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POEntityframework 4.0 .CreateQuery<T> and OrderBy exception
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POEntityframework 4.0 .CreateQuery<T> and OrderBy exception
      1. USJohan Olsson
      1. VTFavorite
    3. VO
      singulars
      1. POEntityframework 4.0 .CreateQuery<T> and OrderBy exception
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload