SQL statement - parameters?

Sep 30, 2009 at 6:39 AM
Edited Sep 30, 2009 at 7:00 AM

Hi

Comparing the generated SQL for a simple query between Linq to SQL and Linq to Oracle it appears that Linq to Oracle is not passing any parameters into the call to Oracle.

var invquery =from i in invoices where i.inv_ID == 51 select i;

=>

SELECT t0.INV_ID, t0.CUSTOMER_ID, t0.INV_DATE, t0.NETT_
AMOUNT
FROM INVOICES t0 - no paramateres

The required filtering for the query is then applied in .Net and this is clearly affecting performance. Am I missing a detail in the stack which will push in parameters? 

Any help appreciated.

Many thanks

John

 

Coordinator
Oct 25, 2009 at 5:35 PM
Hi, this problem occurs when you use .NET 3.5 library instead of linq preview. this version does not work with .NET 3.5 implementation of linq.