childobject.cs

oracle dal gen,生成.NET ORACLE DAL层代码

using System;
using System.Collections.Generic;
using System.Text;
using OracleDALGen.Classes.Attributes;
using System.Data;

using OracleDALGen.Classes.Database;

namespace OracleDALGen.Classes.TestObject
{
    [ClassDatabaseType("get_child_object", Method.Select, CommandType.StoredProcedure)]
    [ClassDatabaseType("merge_child_object", Method.Merge, CommandType.StoredProcedure)]
    [ClassDatabaseType("child_object", Method.Notification, CommandType.TableDirect)] 
    public class ChildObject 
    {
        private Decimal? id;
        private string name;

        public ChildObject(Decimal? id, string name) 
        {
            this.id = id;
            this.name = name;
        }

        public ChildObject()
        {

        }

        [IdColumn("ID", Oracle.DataAccess.Client.OracleDbType.Decimal)]
        public Decimal? Id
        {
            get { return id; }
            set { id = value; }
        }

        [DbColumn("NAME", Oracle.DataAccess.Client.OracleDbType.Varchar2)]
        public string Name 
        {
            get { return name; }
            set { name = value; }
        }

        public static ChildObject LoadSingle(int id, OraConnection connection)
        {
            DatabaseLoader dl = new DatabaseLoader();

            return dl.LoadSingle<ChildObject>(new Param[] { new Param("ID", id) }, connection);
        }
    }
}