Sep 30, 2009 at 6:39 AM
Edited Sep 30, 2009 at 7:00 AM
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
where i.inv_ID == 51
SELECT t0.INV_ID, t0.CUSTOMER_ID, t0.INV_DATE, t0.NETT_
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.
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.