In my previous post I talked about general usage of SQL CE database in Mango. In this example I am going to talk about keeping the database schema updated. For example, I want to add a column to Person table from previous post. I would like to add Notes column with the following definition: …
In the past I have written about dealing with data on Windows Phone 7, including WCF Services, WCF Data Services and Isolated Storage. One thing that was missing in the initial release is native RDBMS, such as SQL CE. Luckily, Mango update that should be released later this year finally exposes SQL CE to developers. …
Atlanta Code Camp 2011 took place yesterday, Saturday, June 25 2011. I was one of the organizers of the event. The event was a success based on some preliminary feedback we gathered during the vent itself. We have over 250 people attending 54 different sessions. I did one talk – Using Code First (Code Only) …
In my previous post I showed how to implement custom conventions in absence of the same feature in Entity Framework 4.1. Today I am going to expand on the same topic and try to create some global contentions. Let me elaborate a bit on a problem I am trying to resolve. For example, if I …
Continue reading ‘Global Conventions in Entity Framework Code First v 4.1’ »
As you know, in preview version of Entity Framework code first existed concept of custom pluggable conventions that would allow the developer to avoid using large amounts of code in OnModelCreating method. Typically, if one would like to keep entity classes free of entity framework references and possibly of Data Annotations references, fluent API available …
Continue reading ‘Custom Conventions in Entity Framework Code First v 4.1’ »
As I was playing around with Entity Framework code first and ASP.NET MVC, it became pretty obvious that caching of some of the EF query results would be pretty handy. For example, if you look at my post that includes a simple ASP.NET MVC blogging application, you could see that I have to keep fetching …
Repository pattern is a popular architecture pattern that is used to create data access code / layer for an application. Basic principal behind the pattern is that business object in your application never talks to database directly, but instead talks to repository that takes POCO classes and also returns POCO classes as results of a …
Continue reading ‘Repository Pattern with Entity Framework’ »
Today I am going to talk about how to create a WCF Data Service and host it using a hosting provider. My specific example will be using GoDaddy (www.GoDaddy.com). This is the site where I host my blog. I already posted on this topic, but was using Azure instead. If you have a subscription to …
Continue reading ‘Hosting WCF Data Services on Third Party Hosting Provider’ »
I have recently worked on a project that was using enterprise library logging capabilities. Enterprise Libiary information can be viewed on pattern and practices web site. These library includes a number of useful components, The one I am going to cover here is database logging capabilities. Logging features allows an application to be configured to …
Continue reading ‘Enterprise Library Database Logging and TransactionScope’ »
In this part I am going to use WCF Data Services (formerly known as project Astoria and ADO.NET Data Services) to accomplish the same couple of tasks I did in WCF custom service. I am going to get a list of people and add a person. I will use exact same project as I did …
Continue reading ‘Working with Data on Windows Phone 7 – Part 2’ »