If you’ve been following the blog for a while now, you’ll know there are two main database schemas I tend to work with for Proof of Concept (PoC) applications, movies and records (vinyl LPs). Last year I was building an Entity Framework based PoC using a schema made up of […]
Projects
31 posts
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 […]
This is not part of the ongoing series of articles on SQL Data Services, but rather a call out to a Microsoft White Paper which has been published (a) here – SQL Server White Paper Template. I’d recommend, if you are interested in SQL Data Services, that you take a […]
In the last entry, we looked at basic querying with a web browser and viewing service metrics. This entry will examine administrative commands and bulk uploading options using the SDS administration utility (st.exe) which is part of the SDS SDK. Migrating Data To SQL Data Services There’s really no fun […]
In the previous entry we reviewed how to create entities, but what do we do now? Before I go into detail on how to interact with SDS directly, let’s take some time to go over the fundamentals of querying with SDS. This entry will focus on some of the techniques […]
In the last entry, we established a way of programmatically creating an SDS Authority and Containers. In this entry we will focus on creating data Entities using the SOAP interface. Review In Part 1, we saw how the relationship is defined between objects in the SQL Data Services world. An […]
In Part 1, we were introduced to the concept of SQL Data Services (SDS) and the fundamental design. In Part 2, we looked at the options for authentication, data access and the SDS SDK (helpful tools). In this entry we will look at using the SOAP interface to create an […]
Yesterday, Part 1 in this series introduced you to the basic fundamentals behind SQL Data Services (SDS). The official definition of SQL Data Services is below. “Microsoft SQL Data Services (SDS) offers highly scalable and Internet-facing distributed database services in the cloud for storing and processing relational queries. SDS can […]
Recently, SQL Data Services (SDS) were published as a Community Technical Preview (CTP). Registering via Microsoft Connect, I’ve been able to start building a sample application which is designed to make use of SDS for online real-time queries. This blog entry forms part of the [MiniProject] documentation – the Mini […]
No, I haven’t forgotten! I’ve been working extensively on the Mini Project and I think you’re going to like what the outcome looks like. Since SQL Code Camp (where Matt Lynch and I demonstrated advanced Entity Framework concepts in concert with SQL Server Compact Edition) I’ve been reworking the Mini […]
As with all good data schemas, there’s usually some refactoring as time goes by. This project isn’t immune to the shifting sands of time or perfection, and so today’s second instalment features a schema change. Below is a representation of the schema shift. To summarise, separate Actor/Director tables have been […]
Let’s kick off the Mini Project by examining the database schema. The project involves storing and manipulating data related to movies (in my case, DVDs I own). For this project I am going to concentrate on three key relationships: 1. Movies have at least one director2. Movies have one or […]
Well, hi all. This is the first of a new brand of Tech posts. I’ll be attempting to walk through steps to creating some projects for various nefarious uses. This Mini Project focuses on re-using Media Player by hosting the WMP COM Control in a .Net Framework WinForms application. Overview […]
As you may recall from part 1, this series of posts is about how to retrieve the target of a Windows shortcut (.lnk). Now, I left off part 1 in C++ land, as I’d compiled a Win32 Dynamic Link Library which called the Windows Shell in order to extract […]