Browse by Tags

All Tags » LINQ (RSS)

Paging with NHibernate using a custom Extension method to make it 'easier' :)... by stefan.sedich

Update 20081022: I have updated the articles code to reflect the bug fixes kindly suggested by Paco :). I have now used this in my project and have had no issues with it yet. The fixes included clearing order by's on the count query and also returning...
Filed under: , , , ,

Our First ASP.NET 3.5 Site Goes Live!! by stefan.sedich

Hello All, UPDATE 20080409: Another site has launced, check out www.betts.com.au !!! Thanks Stefan ---------------------------------------------------------------------- Finally our first ASP.NET 3.5 website went live today, there are 2 more to come but...

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: , , ,

Book Review: Linq Quickly by N Satheesh Kumar by stefan.sedich

This books title does not lie, it is LINQ and it is quickly. This book is an excellent introduction into the world of LINQ and also a great reference once you get your feet wet. The start of the book gives you a brief introduction into what LINQ is and...
Filed under: , , ,

A Templated ASP.NET RSS Feed Reader Control by stefan.sedich

Update 20070330: By popular demand (well a couple people) I have included a sample project with everything needed to get started using this control. Basically just a sample web project, click here to get the zipped archive. You might notice things are...

ASP.NET Ajax using a custom ViewManager to render paged data without updatepanels by stefan.sedich

Sometimes you do not want the overhead of using an updatepanel, as each time you make a request it is posting more back than you might need, sure it can be powerful and easy to use but not always the most effective way Say you would like to be able to...

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: , , , , , ,
More Posts Next page »