Browse by Tags

All Tags » VB.NET » LINQ (RSS)

Update to my LINQ to SQL performance in VB.NET saga by stefan.sedich

Hello, If you have read my posts before where I was complaining about VB generated sub optimal SQL when using nullable columns in your where clauses, I came to the conclusion I was being silly and not using .Value on those nullable fields in my queries...
Filed under: , , ,

Different SQL between VB.NET and C# LINQ to SQL SOLVED!! by stefan.sedich

Hi All, Following my previous post I have solved this issue. Somehow accidently I discovered that if the field has allow nulls set on it VB.NET will add the Where Coalesce in your query hence in my case slowing it down dramatically. It seems that C# does...
Filed under: , , , , , ,

Different SQL between C# and vb.net using LINQ to SQL causes performance issues by stefan.sedich

Hi All, I am currently working on a project and we are using VB.NET, I am using LINQ to SQL for my data access. I have just implemented my search query and thought I would check the generated SQL's execution plan and found that the subtree cost was about...
More Posts