Just in case you didn’t realise, I’m doing a talk on “LINQ for SQL” at this weekend’s CodeCampSA. Yes, I’m the first “real” speaker after morning tea on Saturday!
I’ll be doing an updated version of the presentation I did for the SQL User Group in February.
At that time, the latest LINQ for SQL was the May 2006 CTP which installed on top of Visual Studio 2005. Since then Microsoft have released Beta 1 of Visual Studio 2008 which has also incorporated some language syntax changes to Visual Basic related to the LINQ bits. Fabio has listed some of the framework changes since last year.
Bits that affected my presentation include:
- The Visual Studio LINQ to SQL Designer now works pretty well (no need to use the SQLMETAL.EXE command-line tool)
- Overriding insert/update/delete operations now doesn’t use attributes (this is a bit strange) on the methods.
- Projections in VB don’t need to use New, and you use ‘=’ instead of ‘:=’.
I also did some testing of SQL generated for SQL Server 2000 versus 2005. It turns out LINQ for SQL is smart enough that it uses 2005 features (eg. ROW_NUMBER) when they will perform better.
Here’s the June CTP release of
I’m not clear whether these can be installed on top of Visual Studio Orcas Beta 1.
This morning I had a phone call from an ABC TV journalist.
I gather he was doing a follow-up story on the Adelaide woman who has been arrested in the US allegedly trying to meet up with a 16 year old.
I’m not exactly sure how he contacted me, but I’m guessing it is related to the fact that I’ve done some presentations on Internet Safety for Children and that I work here at the University of South Australia.
Anyway, he rang back later and I got the impression he really wanted someone who was an ‘expert in the field’ - eg. had the IT experience but also direct Internet Safety experience with children too. I’m happy to be an IT expert, but internet safety isn’t part of my day-to-day job, so I’m not willing to call myself an ‘expert’ for that.
Anyway, I’ll try and watch the news tonight to see how the story ended up.
The band, at various times known as Verandah and more recently Kaboodle is now known as Seven Fold.
Hoping that this name may last a bit longer than the others, I’ve taken the plunge and created a band blog.
I’ve also invited the other band members to contribute to the blog, so hopefully it starts to record a bit of the continuing history of what we’re up to.