applying indexes in LINQ query

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Posts: 3
Joined: Fri 23 Apr 2010 10:08

applying indexes in LINQ query

Post by raghavendra » Wed 13 Oct 2010 10:10

how can i apply a table index present in the database in my linq query while querying through entity framework.


Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Wed 13 Oct 2010 11:58

In case if you are using Entity Framework v4 you can use the ExecuteStoreQuery method.
And you can write your queries in the form of Stored Procedures and create Function Imports for them no matter what EF version you are using.
If you do not have the grants to modify the database you can create CommandTexts instead.

Post Reply