dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Tip: Speed Up Entity Framework Queries

 Learn how explicitly specifying the type can speed up EF queries.


advertisement

Queries like the one below will perform more slowly than they could be run on a varchar column.

Explicitly marking them as such will improve the performance of EF queries as it would query with the right type.

dataContext.Tables.Where(k = k.MyStringProperty == someValue); 

Explicit type specification on the property though the Column attribute. 
[Column(TypeName="varchar")] 
public string MyStringProperty { get; set; }

 

Visit the DevX Tip Bank

 



   
Srinath M. S. says: "I would love to leave a footprint in this flat world."
Thanks for your registration, follow us on our social networks to keep up-to-date