Thanks Alex

I am just beginning sample for poco but don't have idea where to start. Link provided above is bouncer to me is there any more sample which looks simple for poco beginner with more detail.

Manish

It's exactly what can do peta POCO, create table with petaPOCO and do CRUD operations with it.

Table creation example:

using Umbraco.Core;
using Umbraco.Core.Persistence;

namespace MyDemo.Web.Logic.Extensions
{
   public class RegisterEvents : ApplicationEventHandler
   {
       protected override void ApplicationStarted(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext)
       {
           var db = applicationContext.DatabaseContext.Database;

           if (!db.TableExist("wilCompetition"))
           {
               db.CreateTable(false);
           }
       }
   }
}

POCO class:

using System;
using Umbraco.Core.Persistence;
using Umbraco.Core.Persistence.DatabaseAnnotations;

namespace MyDemo.Web.Data.Poco
{
   [TableName("wilCompetition")]
   [PrimaryKey("Id", autoIncrement = true)]
   public class Competition
   {
       [PrimaryKeyColumn(AutoIncrement = true)]
       public int Id { get; set; }

       public string Name { get; set; }

       [Column("CompetitionDescription")]
       [NullSetting(NullSetting = NullSettings.Null)]
       [SpecialDbType(SpecialDbTypes.NTEXT)]
       public string Description { get; set; }

       public DateTime CreatedOn { get; set; }
   }
}

Thanks,

Alex