testobject.cs

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

using System;
using System.Collections.Generic;
using System.Text;
using Oracle.DataAccess.Client;
using System.Reflection;
using System.Data;
using OracleDALGen.Classes;
using OracleDALGen.Classes.Attributes;
using System.Collections;

using OracleDALGen.Classes.Database;

namespace OracleDALGen.Classes.TestObject
{
    [ClassDatabaseType("get_test_object", Method.Select, CommandType.StoredProcedure)]
    [ClassDatabaseType("merge_test_object", Method.Merge, CommandType.StoredProcedure)]
    [ClassDatabaseType("delete_test_object", Method.Delete, CommandType.StoredProcedure)]
    public class TestObject 
    {
        private Decimal? id;
        private string name;

        private ChildObject childObjet = new ChildObject();
        private IList<ListObject> listObjects = new List<ListObject>();

        public TestObject() 
        {
        }

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

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

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

        [ObjectColumn("CHILD_OBJECT_ID", OracleDbType.Decimal, typeof(ChildObject))]
        public ChildObject ChildObject
        {
            get { return childObjet; }
            set { childObjet = value; }
        }

        [ListColumn("ID", "TEST_OBJECT_ID", "get_list_objects", Method.Select, CommandType.StoredProcedure, typeof(ListObject), OracleDbType.Decimal)]
        public IList<ListObject> ListObjects
        {
            get { return listObjects; }
            set { listObjects = value; }
        }

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

            Param[] paramArray = new Param[] { new Param("ID", id) };

            return dl.LoadSingle<TestObject>(paramArray, connection);
        }
    }

    public interface ICollectionConverter<T>
    {
        IList<T> Convert(IList<object> list);
    }
}