Database Magic

There’s going to be more to this in coming posts, but I thought I’d add all the articles I’ve been reading ahead of schedule.  The long and short of the story is this – I’ve managed to implement round trip CRUD operations using POCO (Plain Old CLR Objects) using a […]

Reading Ahead – ADO Entity Framework v4 and POCO Entities

This is part of a series of entries written about Microsoft’s new SQL Azure database service and the Entity Framework v4. Following on from my previous posts (check them out before continuing) – this article assumes you have followed steps outlined in the  previous posts to create various models and […]

A Dynamic Data Website with SQL Azure and the Entity ...

Sometimes it’s good to refresh.. I keep forgetting the conditions for using an updatable view in SQL Server so I thought I’d publish this info to my blog for reference purposes. Updatable Views You can modify the data of an underlying base table through a view, as long as the […]

SQL Server Tip: Updatable Views