Database Magic


images_thumb.jpg 1
Introduction Last week I gave an internal presentation to my fellow consultants at CGI on the principals of data modelling/data architecture, modelling within Visual Studio 2013 and a history of the (ADO.NET) Entity Framework. I’ve attached the slide deck to this article, and also in my presentations page. Data Modelling […]

Data Modelling and the Entity Framework


image_thumb.png 12
Introduction This article is part of the ongoing series I’ve been writing recently, but can be read as a standalone article.  I’m going to do a better job of integrating the changes documented here into the ongoing solution I’ve been building.  However, considering how much time and effort I put […]

Solving the detached many-to-many problem with the Entity Framework


image_thumb.png
Introduction Following on from the previous article, Data Access with the Entity Framework V6 RC1, this time I’m going to go deeper and look at how we manipulate entities through a structured and often times generic approach. We’ll take a particularly close look at an approach to adding, updating and […]

Basic Data Operations with the Entity Framework V6 RC1



image_thumb.png
Introduction Following on from the earlier article which established a data schema, the next step is to wrap the database design in an ORM.. for fun. I’m going to take a look at the latest pre-release of the Entity Framework, version 6 (RC1).  If you’re interested in the licensing aspects, […]

Integrating the Entity Framework v6 RC1


image_thumb.png 1
Introduction Per my introduction article, I’m learning the hard way – with the latest from Microsoft.  Yesterday I created a SQL schema from a Twitter archive which was “fun”, but didn’t provide me with a decent enough schema to model a complete end-to-end design for something meaningful. So I’m back […]

Schema Modelling with Visual Studio 2013 Preview




image_thumb.png
Introduction Recently, I added some articles about installing and configuring some new pre-release software that Microsoft released earlier in the year.  [ Visual Studio 2013 | Team Foundation Server 2013 ] Now I’m ready to put it all to the test! I know there’s been a lot of build-up, and […]

Previewing the Previews





image_thumb.png
Overshadowed, possibly, by the release of the new iPad?  Not in the world of databases.  Yesterday Microsoft officially released SQL Server 2012 “release to manufacturing” (RTM) which means we’re officially out of pre-release editions! Previously codenamed ‘Denali’, the new version brings to the table some serious changes, some of which […]

SQL Server 2012 Released!


image_thumb.png 1
Introduction In December 2011, Microsoft released an early Release Candidate (RC) of SQL Server 2012 (formerly known as codename Denali). There are a bunch of new things in SQL Server 2012 – here’s a list of just a few: Master Data Services Reporting Services PowerPivot for SharePoint Data Quality Services […]

SQL Server 2012 Release Candidate 0


1
There are times when you want to get a little creative about your investigative work when it comes to SQL Server.  In this case, this is a very short article highlighting some efficiencies in locating information about specific programmatic resources within a database. If you haven’t used the INFORMATION_SCHEMA views […]

Some INFORMATION_SCHEMA magic



image_thumb.png
Recently I alluded to writing a series of posts on the Entity Framework Futures, now referred to as the “Microsoft ADO.NET Entity Framework Feature Community Technology Preview 5“ which could really, really use a cool codename. Introduction If you’ve been following along on the Windows Workflow Rules Engine series of […]

Entity Framework Code First (Part 1)