Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: .NET
Expertise: Intermediate
Aug 21, 2018

Speed Up Entity Framework Queries

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. 
public string MyStringProperty { get; set; }
Srinath M S
Thanks for your registration, follow us on our social networks to keep up-to-date