MVP Award, 2013 and Learning

January 22nd, 2013 | Posted by Robert Curlette in Lifehacking - (1 Comments)

The best part of sharing is learning. When we share, we invite others to participate in the solution. We need to learn to share, and by sharing we learn from others, with their valuable comments and feedback. It is this feedback loop that we benefit from as a community.

The SDL Tridion MVP award was created to recognize those who share their experiences and knowledge through public blogs, StackOverflow, and other media. I feel honored to be awarded the MVP award for sharing in 2012.

But, this is a new year and the clock resets on the MVP award. We are all now equal and although I shared a lot in 2012 I need to continue sharing in 2013 if I want to have a chance of winning the MVP award again.

With 2013 I welcome all the new bloggers that will contribute more to our community, challenge our ways of thinking, and introduce new ways of solving old problems. The Tridion 2013 product is around the corner. Ask your manager to install it on the Dev machine. Write about the installation, or one of the many new features.

The secret of writing is finding something exciting to write about. If you are excited and curious about a topic, it is much easier to write and also the quality is much better. So, find something interesting, technically, to write about! It could be Tridion, .Net, Java or Web Services. Processes, management or functional designs. But, write a small article and see where it goes! And, if you make mistakes, you can always edit the article and fix them. I know I have!

Speaking of learning, Pluralsight has a great course on ServiceStack (web service framework) and with this link you can get a 1 day free trial.

I wish you all a successful year of learning!

I wanted to create a simple app to store data using the elegant OrmList from ServiceStack.  During this process I found a couple of things that cost me some time and I wanted to share these with you.  In this article I will walk through creating a small and simple ServiceStack OrmLite example.  It should take around 5 minutes to complete the example.

Please see the excellent OrmLite official docs for more examples.

Update Jan 6, 2013:  Code samples updated with the great feedback in the comments from Demis Bellot.

Step 1:  Create a Console App and Reference OrmLite.SQLite

– Create a Console app named OrmLiteExample

– Add the OrmLite references from NuGet (  Right-click on the References in the Solution Explorer, Manage NuGet Packages, Online, OrmLite.  Or, from the Package Manager Console (View, Other Windows, Package Manager Console) type ‘Install-Package ServiceStack.OrmLite.Sqlite32’.

Step 2:  Create the DTO (aka Model)

This is the nicest part of working with ServiceStack.  Everything is DTO and Model driven – no config files to create and the code is simple and concise.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using ServiceStack.DataAnnotations;

namespace OrmLiteExample
    class Note
        [AutoIncrement] // Creates Auto primary key
        public int Id { get; set; }

        public string SchemaUri { get; set; }
        public string NoteText { get; set; }
        public DateTime? LastUpdated { get; set; }
        public string UpdatedBy { get; set; }

Step 3:  In program.cs, add the Using statements

using ServiceStack.OrmLite;
using ServiceStack.OrmLite.Sqlite;

The using statement ServiceStack.OrmLite.Sqlite will throw an exception if you build now.

Fix:  With NuGet, download and install ServiceStack.OrmLite.Sqlite32 package. Also, go to the properties of your project and make sure the target framework is set to .NET framework 4.  Solved!

Step 4:  Add the connection strings for SqLite

Thanks to the nice Unit Tests in the ServiceStack project I was able to use their example.

public static string SqliteMemoryDb = ":memory:";
// Updated per comment form Jonas.  First connection string below causes an app pool restart!  Use MapHostAbsolutePath instead!
//public static string SqliteFileDb = "~/App_Data/db.sqlite".MapAbsolutePath();  
public static string SqliteFileDb = "~/App_Data/db.sqlite".MapHostAbsolutePath();
Problem:  The MapAbsolutePath is not found.
Fix: Include the missing library:

using ServiceStack.Common.Utils;

Step 5:  Create the connection

//Using Sqlite DB- improved
var dbFactory = new OrmLiteConnectionFactory(
                SqliteFileDb, false, SqliteDialect.Provider);

// Wrap all code in using statement to not forget about using db.Close()
using (var db = dbFactory.Open()) {

Step 6: Create the Table



Step 7:  Insert a record

Note:  This is different than the excellent online examples.  I received a warning message to use the Connection instead of the Command object.

// Insert
	new Note {
		SchemaUri = "tcm:0-0-0",
		NoteText = "Hello world 5",
		LastUpdated = new DateTime(2013, 1, 5),
		UpdatedBy = "RC" });

Step 8:  Read the data

 // Read
var notes = db.Where<Note>(new { SchemaUri = "tcm:0-0-0" });
foreach (Note note in notes)
	Console.WriteLine("note id=" + note.Id + "noteText=" + note.NoteText);

Full Code