PetaPoco - 1.0

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using PetaPoco;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel;

namespace PetaPocoWebTest.Poco
{
	[TableName( "tag")]
	public class Tag
	{
		public int Id {get; set;}

		[Column( "tagName")]
		public string TagName {get; set;}

		public Tag() : this( string.Empty)
		{
		}

		[ResultColumn]
		public List<Article> Articles {get; set;}

		public override string ToString()
		{
			return this.TagName;
		}

		public Tag( string tagName)
		{
			this.TagName = tagName;
			this.Id = int.MinValue;
			this.Articles = new List<Article>();
		}
	}
}

using SubSonic; 
public bool Insert( Tag tag)
		{
			_database.Insert( "tag", "id", true, tag);

			return true;
		}

public bool Update( Tag tag)
		{
			_database.Update( tag);

			return true;
		}

public bool TagExists(int tagId)
		{
			return _database.Exists<Tag>(tagId);
		}
		

public bool Delete_entity(Tag tag)
		{
			using (var scope = _database.GetTransaction())
			{
				int rowsAffected = _database.Delete(tag);

				if (rowsAffected > 0)
				{
					scope.Complete();
					return true;
				}
				else
				{
					return false; // Deletion failed or the entity did not exist
				}
			}
		}

public List<Tag> RetrieveAll()
		{
			return _database.Fetch<Tag, Article, Author, Tag>(
				new TagRelator().Map,
				"select * from tag " +
				"left outer join articleTag on articleTag.tagId = tag.id " +
				"left outer join article on article.id = articleTag.articleId " +
				"join author on author.id = article.author_id order by tag.tagName asc").ToList();
		}