applying indexes in LINQ query

applying indexes in LINQ query

Postby 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.

Thanks,
Raghavendra.
raghavendra
 
Posts: 3
Joined: Fri 23 Apr 2010 10:08

Postby 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.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for Oracle