ORIENTA?ÃO A OBJETOS NA PR?TICA

    [Table(TableName = [Ô]Produto[Ô])]
    public class Produto : CommonFunctions<Produto>
    {
        [Field(SqlType = SqlDbType.UniqueIdentifier, ShowLabel = [Ô]ID[Ô], TableFieldName = [Ô]ID[Ô], IsPrimaryKey = true)]
        public Guid GUID { get; set; }
        [Field(SqlType = SqlDbType.VarChar, ShowLabel = [Ô]Tipo[Ô], TableFieldName = [Ô]Tipo[Ô])]
        public string Codigo { get; set; }
        [Field(SqlType = SqlDbType.VarChar, ShowLabel = [Ô]Descrição[Ô], TableFieldName = [Ô]Descricao[Ô])]
        public string Descricao { get; set;         }
        [Field(SqlType = SqlDbType.Money, ShowLabel = [Ô]Preco[Ô], TableFieldName = [Ô]Preco[Ô])]
        public double Valor { get; set; }
}

public class CommonFunctions<T> where T : CommonFunctions<T>, new()
    {
        public static T GetObj()
        {
            return new T();
        }
       public List<String> Insert()
        {
            ValidaObjeto(this);
            List<String> _return = null;
            SqlConnection Cn = new Conexao().SqlConnection;

            using (SqlCommand cmd = this.GetInsertCommand(Cn))
            {
                Cn.Open();
                cmd.ExecuteNonQuery();


                if (cmd.Parameters != null)
                {
                    _return = new List<String>();
                    foreach (SqlParameter item in cmd.Parameters)
                    {
                        if (item.Direction == System.Data.ParameterDirection.Output)
                        {
                            if (item.Value == DBNull.Value)
                                _return.Add(null);
                            else
                                _return.Add(item.Value.ToString());
                        }
                    }
                }

            }
            return _return;
        }
        public virtual SqlCommand GetInsertCommand(SqlConnection Connection)
        {
            SqlCommand _return = new SqlCommand();
            _return.Connection = Connection;

            List<PropertyInfo> properties = this.GetType().GetProperties().ToList();
            List<string> fields = new List<string>();
            string NomeTabela = ((Table)this.GetType().GetCustomAttributes(true)[0]).TableName;
            _return.CommandText = [Ô]Insert Into {0} ({1}) Values ({2})[Ô];




            foreach (PropertyInfo item in properties)
            {
                Field attributes = null;
                if (item.GetCustomAttributes(true).ToList().Count > 0)
                {
                    attributes = (Field)item.GetCustomAttributes(true).ToList().FirstOrDefault(a => a.GetType() == typeof(Field));
                    if (attributes != null)
                    {
                        if (attributes.TableFieldName != [Ô][Ô])
                        {
                            object valor = null;
                            valor = item.GetValue(this, null);

                            fields.Add(attributes.TableFieldName);

                            _return.Parameters.Add(new SqlParameter()
                            {
                                Value = valor,
                                ParameterName = attributes.TableFieldName,
                                SqlDbType = attributes.SqlType
                            });
                        }
                    }
                }
            }

            foreach (SqlParameter par in _return.Parameters)
            {
                if (par.Value == null)
                    par.Value = DBNull.Value;

            }

            string campos = string.Empty;
            string valores = string.Empty;
            foreach (string item in fields)
            {
                campos += item + [Ô],[Ô];
                valores += [Ô]@[Ô] + item + [Ô],[Ô];
            }
            campos = campos.Substring(0, campos.Length - 1);
            valores = valores.Substring(0, valores.Length - 1);

            _return.CommandText = string.Format(_return.CommandText, NomeTabela, campos, valores);

            return _return;
        }
    }