Next pet project is to move my blog on Community Server to the Cloud. I spend too long making sure my database size does not go over 500 MB, the size limit on my hoster. So once every 3 months I have to do some clean up of the database: DELETE FROM cs_statistics_Site DELETE FROM cs_Visits DELETE FROM...

I was listening to the recent .NET rocks episode about the Entity Framework advisory council and it was interesting to hear the team's point of view and the problems they are trying to solve with the Entity Framework. They have nice goals, but there is a fundamental problem here that some of the original...

ASP.NET SQLDatasource control was for me a super productive tool in the past. There are some small features missing like a more elegant data paging. ASP.NET 3.5 bring a new control LinqDatasource which have great support for data paging . So I tried  to create a rss feed with LINQtoSQL and LinqDatasource...

This is something I have come across during our SQL migration which I didn't even think about. You can zip up your bak files and save considerable hard drive space. We have a 14 gig database which happily compresses down to 2 gig. With hard drives coming down in price, you may think why bother. Well...

/// <summary> /// This webservice is used with AJAX AutoComplete Extender /// to populate possible car makes for textbox on Sell Your Car form /// </summary> [ ScriptService ()] [ WebService (Namespace = "http://tempuri.org/" )] [ WebServiceBinding (ConformsTo = WsiProfiles .BasicProfile1_1...

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 not do this. So finally I have my VB.NET sql comming...

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 7.3. I know that I get different SQL between C#...

In the world of .NET programming, ADO.NET has become the De Facto standard for accessing database of all types (relational or otherwise). The purists among us will be quick to point out that ADO.Net should be the only option and that as developers we shouldn’t even be thinking about bypassing ADO.NET...

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 get a select top 9 which would not do any orderby...

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. I got a good suggestion from Young Joo to keep autogenerated...