Browse by Tags

All Tags » VB.NET (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: , , ,

Output Cache With Usercontrol on Masterpage and Multiple VaryByCustom by stefan.sedich

Hey All, Had an issue today where I had a masterpage which was inherited from 2 pages. On the masterpage I had a control which is using output cache to cache the control. But ran into an issue where you would visit the first page say Test.aspx and you...
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: , , , , , ,

UserControl OutputCache and VaryByParam not working with postback!! by stefan.sedich

Don't know if anyone has come across this before. But if you have a usercontrol that uses VaryByParam and you have it on a page and do a postback you will get the wrong cache item. Use the below test bed to see what I mean, this is following to my post...

Fully Accessible And SEO Friendly Ajax Paging Using DataPager by stefan.sedich

Hey All, Working on my current project I implemented paging using a listview and a datapager. I then decided it would be much nicer to use AJAX for my paging so wrapped all this up in an updatepanel. Next step was the issue when you would goto a page...

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

Issues using HyperLink control with an image in a URL Rewriting scenario by stefan.sedich

Hey All, I was using the HyperLink control in my page and added URL Rewriting to my page so that for example: http://site/test/test/default.aspx would be rewritten to http://site/default.aspx. I had a HyperLink control on the default page like so: <asp...
More Posts