Browse by Tags

All Tags » SQL » .NET (RSS)

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

Gotcha with linq and paging by stefan.sedich

Hey All, Had a query which I was paging on the front end. I knew that a certain product was meant to be in my display but could not see it. But on page 2 a product would repeat itself. Odd, got into profiler and looked at the queries. The first page would...
Filed under: , , , , , ,

Handling Default Values With LINQ to SQL by stefan.sedich

Hi All, Have run into some issues with using default values in my SQL database with LINQ. I set AutoGenerated in the LINQ Designer to true which made use of my default values but this did not let me update this manually as it would throw an exception...
Filed under: , , , , , ,

Tagging Implementation with LINQ by stefan.sedich

Hello all, I decided to implement tagging on my video library. My first solution was to use one table for the tags. Containing the videoid and tagname. When I loaded in 1,000,000 test tags this became slow to generate my tag cloud data. My new solution...

BLL With LINQ by stefan.sedich

Hello, I am currently working on a little project I call GeekTube, it is going to be an internal repository for videos. Implementing my BLL has never been easier. My approach has been to implement all my static helpers as part of a partial class. For...
Filed under: , , , , ,

Unexpected results with Compiled Queries and LINQ to SQL by stefan.sedich

SOLUTION: Ok fired up SQL profiler and see my problem, the non compiled query seems to not evaluate the query until you actualy use the object. But the Compiled version is hitting the database straight away. And as I was not using this data the non compiled...
Filed under: , , , , , , ,

Wierd behaviour with LINQ to SQL designer (bug????) by stefan.sedich

This is odd. Have a test table with an id and name field no primary key was set as it was a quick test hack. Pulled the table into the LINQ Designer and noticed none of the validation partial methods were there. There was no OnnameChanged. Nowhere. After...
More Posts