Sub Sonic - 1.0

using SubSonic; 
using SubSonic.Utilities;

namespace MettleSystems.dashCommerce.Content
{
	[Serializable]
	public partial class Page : ActiveRecord<Page>
	{
		public Page()
		{
		  SetSQLProps();
		  InitSetDefaults();
		  MarkNew();
		}
		 
		public Page(string columnName, object columnValue)
		{
			SetSQLProps();
			InitSetDefaults();
			LoadByParam(columnName,columnValue);
		}
		
		[XmlAttribute("PageId")]
		public int PageId 
		{
			get { return GetColumnValue<int>("PageId"); }
			set { SetColumnValue("PageId", value); }
		}
		  
		[XmlAttribute("Title")]
		public string Title 
		{
			get { return GetColumnValue<string>("Title"); }
			set { SetColumnValue("Title", value); }
		}
	  
		[XmlAttribute("MenuTitle")]
		public string MenuTitle 
		{
			get { return GetColumnValue<string>("MenuTitle"); }
			set { SetColumnValue("MenuTitle", value); }
		}
		  
		[XmlAttribute("Description")]
		public string Description 
		{
			get { return GetColumnValue<string>("Description"); }
			set { SetColumnValue("Description", value); }
		}
	}

}

using SubSonic; 
using SubSonic.Utilities;

namespace Subsonic.Crud {
    class Program {
        static void Main(string[] args) {
                    
        public static void Insert(Guid varPageGuid,int varParentId,string varTitle,string varMenuTitle,string varKeywords,string varDescription,int varSortOrder,int varTemplateId,string varCreatedBy,DateTime varCreatedOn,string varModifiedBy,DateTime varModifiedOn)
		{
			Page item = new Page();
			
			item.PageGuid = varPageGuid;			
			item.ParentId = varParentId;	
			item.Title = varTitle;			
			item.MenuTitle = varMenuTitle;			
			item.Keywords = varKeywords;			
			item.Description = varDescription;			
		
			if (System.Web.HttpContext.Current != null)
				item.Save(System.Web.HttpContext.Current.User.Identity.Name);
			else
				item.Save(System.Threading.Thread.CurrentPrincipal.Identity.Name);
		}
        }
    }
}

using SubSonic; 
using SubSonic.Utilities;

namespace Subsonic.Crud {
    class Program {
        static void Main(string[] args) {
                    
        	public MettleSystems.dashCommerce.Content.Page Page
		{
			get { return MettleSystems.dashCommerce.Content.Page.FetchByID(this.PageId); }

			set { SetColumnValue("PageId", value.PageId); }

	    }
    }
}

using SubSonic; 
using SubSonic.Utilities;

namespace Subsonic.Crud {
    class Program {
        [DataObjectMethod(DataObjectMethodType.Delete, true)]
        public bool Delete(object PageId)
        {
            return (Page.Delete(PageId) == 1);
        }
    }
}

namespace Subsonic.Crud{
    class Program {
        		public static void SaveRegionMap(int varPageId, RegionCollection items)
		{
			QueryCommandCollection coll = new SubSonic.QueryCommandCollection();
			//delete out the existing
			QueryCommand cmdDel = new QueryCommand("DELETE FROM dashCommerce_Content_Page_Region_Map WHERE PageId=@PageId", Page.Schema.Provider.Name);
			cmdDel.AddParameter("@PageId", varPageId);
			coll.Add(cmdDel);
			DataService.ExecuteTransaction(coll);
			foreach (Region item in items)
			{
				PageRegionMap varPageRegionMap = new PageRegionMap();
				varPageRegionMap.SetColumnValue("PageId", varPageId);
				varPageRegionMap.SetColumnValue("RegionId", item.GetPrimaryKeyValue());
				varPageRegionMap.Save();
			}

	} 
}

namespace Subsonic.Crud{
    class Program {
	
        [DataObjectMethod(DataObjectMethodType.Select, true)]
        public PageCollection FetchAll()
        {
            PageCollection coll = new PageCollection();
            Query qry = new Query(Page.Schema);
            coll.LoadAndCloseReader(qry.ExecuteReader());
            return coll;
        }
	}
}