So for a while I’ve been manually adding items and it finally occurred to me that there must be a faster way to add whole folders to a Visual Studio project. Recently I came across this blog entry – it’s rather obvious and it works. Can’t believe I didn’t know […]
Programming
322 posts
Over the weekend I’ve been working on a query abstraction approach which is interoperable with both LINQ to SQL and the ADO.net Entity Framework (using IQueryable) – with some minor modifications to suit each data model. As I was putting this to use on a somewhat semi-realistic search pane, I […]
Hi Everyone, since I’m off to Sydney from Monday until Wednesday next week (and unlikely to be publishing anything new during that time) here is a bonus post. See you after I return.. /R One of the like-to-haves with SQL Server has been the enforcement of column uniqueness but allowing […]
So recently I was playing with an abstraction for dynamic LINQ queries. The typical usage scenario arises when one needs to search one or more tables with “dynamic” filter patterns. Usually this is one of those intoxicating multiple search criteria (“Advanced Search”) screens. To illustrate my point, let’s work with […]
Hi All, I just wanted to bring your attention to the upcoming Microsoft Tech Days – a 24 hour event. You can get most of the info from the official site – https://www.msfttechdays.com/public/home.aspx – however seeing as this is a unique event, I thought I’d highlight some of the awesome […]
Recently I had to determine, given a specific date, what the recurrence of that date’s day of the week was within the month; for example, today (the 20th of March 2009) is the 3rd Friday this month. In addition, I also had to determine whether it was also the last […]
A question was posed: “If a table is not being used in a relational context, what are the benefits of putting a [clustered] index on the table?” Well, I’d highly recommend reading this article on (1) SQL indexes although it is a bit detailed. The short hand summary is that […]
I’m going to coin the phrase ‘Functional Transparency’ because it fits the definition. I’ve been working with functional transparency in LINQ to SQL for a few weeks now, and it seems to be working well enough to write about. The objective is to implement additional (background) functionality which is not […]
Since the ADO Entity Framework was launched last year (as RTM) I’ve been trying to find an excuse to start using it for more than fluff demos. Unfortunately the opportunity for real use has not been forthcoming, so I decided to put together a personal project which would allow me […]
So we all probably know by now that a Linq DataContext object is used for both establishing and accessing SQL Server databases. You might be also aware that to take advantage of Linq to SQL’s functionality, changes must be performed within the scope of a DataContext. This entry will focus […]
So this may not come as a surprise to many, but Microsoft have taken the Windows 7 into a public beta. As I understand it, MSDN and TechNet subscribers already have access, and the general public will too, tomorrow (AEST). Windows version 7 is the next major version of the […]
Undoubtedly, anyone who has evaluated LINQ to SQL has fond it a fairly powerful yet lightweight ORM technology which is less complex than the ADO Entity Framework yet utilizes the strength and power of Language Integrated Queries. One problem with LINQ to SQL is the auto paging feature of the […]
Over at MSDN there has been published a (1) fairly comprehensive paper on development under Windows 7. Some particular points of interest/new features include: "Windows 7 is designed to run on the same hardware as Windows Vista, and to be compatible with applications and device drivers that work with Windows […]
Well, it’s been over a month since I registered and I still don’t have an Azure Services token. I’ve had a SQL Data Services token from day 1, but still nothing on the Azure front. It’s kinda getting frustrating, especially since I have an application ready to go. Anyone at […]
Finally BizTalk 2006 R3 *ahem* BizTalk 2009 has entered public beta. This means you can take an early look at the next generation of BizTalk (and, hopefully a new generation of developer tools!). Even with BizTalk 2006 R2, you are required to run Visual Studio 2005! The project is up […]