对象关系映射架构（DBFramework）及代码生成器源码
一、使用对象关系映射组件Kenly.DBFramework.dll不用编写任何SQL或者存储过程即可实现下列功能：
1、数据表、视图和存储过程与对象之间的转换。
2、数据表、视图的自定义条件查询。
3、数据表、视图的分页查询。
4、根据ID、主键或自定义条件对数据表进行增、删、改操作。
5、实现一对一、一对多、多对一和多对多的关系映射。
6、支持单个对象和多个对象之间的事务控制。
7、支持查询结果排序。
8、支持查询表达式生成。
9、支持延迟加载。
二、代码生成器
1、根据指定的数据库连接，自动生成数据表、视图和存储过程对应的对象代码（C#代码）。
2、自动生成相关的工程文件，生成完整的业务层项目文件。
3、可以帮助生成自定义查询方法。
4、支持SQLServer2000、SQLServer2005和Oracle代码生成插件，支持插件扩展。
提供
1、对象关系映射组件： Kenly.DBFramework.dll
2、代码生成器源码：CodeHelper。
3、代码生成器插件源码（支持SQLServer2000、SQLServer2005和Oracle）：Plugin。
4、使用手册：DBFramework.Manual V4.5.3.pdf。
主要API：
public abstract class ViewGateway where T: new()
{
// Methods
static ViewGateway();
protected ViewGateway();
protected static int Count();
protected static int Count(string condition);
protected static List CountGroup(string groupBy);
protected static List CountGroup(string condition, string groupBy);
public static List CreateInstances(int count);
protected static List Distinct(string columnName);
protected static List Distinct(string columnName, string condition);
protected static List Distinct(string columnName, string condition, bool ignoreNull);
protected static bool Exists(string condition);
public bool ExistsById();
public bool ExistsByPK();
protected static List Find(PagingArg pagingArg, params string[] propertyNames);
protected static List Find(string condition, params string[] propertyNames);
protected static List Find(PagingArg pagingArg, bool sqlServer2000, params string[] propertyNames);
protected static List Find(string condition, PagingArg pagingArg, params string[] propertyNames);
protected static List Find(string condition, PagingArg pagingArg, bool sqlServer2000, params string[] propertyNames);
protected static List FindAll(params string[] propertyNames);
protected static void FindTop(T firstOne);
protected static List FindTop(int topCount, params string[] propertyNames);
protected static void FindTop(string condition, T firstOne);
protected static List FindTop(string condition, int topCount, params string[] propertyNames);
protected static void InitializeGateway(GatewayConfig config);
protected static void InitializeGateway(DatabaseType dbType, string connectionString);
protected void InitializeInstance(T entity);
protected static object Max(string columnName);
protected static object Max(string columnName, string condition);
protected static List MaxGroup(string columnName, string groupBy);
protected static List MaxGroup(string columnName, string condition, string groupBy);
protected static object Min(string columnName);
protected static object Min(string columnName, string condition);
protected static List MinGroup(string columnName, string groupBy);
protected static List MinGroup(string columnName, string condition, string groupBy);
protected static DataTable Query(PagingArg pagingArg, params string[] propertyNames);
protected static DataTable Query(string condition, params string[] propertyNames);
protected static DataTable Query(PagingArg pagingArg, bool sqlServer2000, params string[] propertyNames);
protected static DataTable Query(string condition, PagingArg pagingArg, params string[] propertyNames);
protected static DataTable Query(string condition, PagingArg pagingArg, bool sqlServer2000, params string[] propertyNames);
protected static DataTable QueryAll(params string[] propertyNames);
protected static DataTable QueryTop(int topCount, params string[] propertyNames);
protected static DataTable QueryTop(string condition, int topCount, params string[] propertyNames);
public ArrayList RetrieveAssociations();
public ArrayList RetrieveAssociations(Type elementType);
public ArrayList RetrieveAssociations(params Type[] elementTypes);
public void RetrieveById();
public void RetrieveByPK();
protected internal virtual void RetrieveBySql(string sql);
public void ShadowCopyTo(object targetEntity);
public void ShadowCopyTo(T targetEntity);
protected static double Sum(string columnName);
protected static double Sum(string columnName, string condition);
protected static List SumGroup(string columnName, string groupBy);
protected static List SumGroup(string columnName, string condition, string groupBy);
public static string ToColumnName(string propertyName);
public static T ToObject(DataRow adaptedRow);
public static List ToObjects(DataTable adaptedTable);
public static List ToObjects(DataRow[] adaptedRows);
public static string ToPropertyName(string columnName);
public static DataTable ToTable(IList entities);
public static DataTable ToTable(params T[] entities);
public static DataTable ToTable(bool isAdapted, params T[] entities);
public static DataTable ToTable(bool isAdapted, IList entities);
// Properties
protected internal static string CommandText { get; }
protected internal static GatewayConfig Config { get; }
internal T Entity { get; set; }
public object EntityId { get; }
public object PrimaryKey { get; }
protected static Order SortedOrder { get; set; }
}
public abstract class TableGateway : ViewGateway where T: TableGateway, new()
{
// Methods
static TableGateway();
protected TableGateway();
public int AddNew();
public static int AddNew(IList entities);
public static int AddNew(T entity);
public int AddNew(bool returnIdentity);
public static int AddNew(T entity, bool returnIdentity);
public static int AddNew(IList entities, out Transaction transaction);
public static int AddNew(IList entities, bool returnIdentity);
public static int AddNew(T entity, out Transaction transaction);
public static int AddNew(IList entities, bool returnIdentity, out Transaction transaction);
public static int AddNew(T entity, bool returnIdentity, out Transaction transaction);
public IDbTransaction BeginTransaction();
public IDbTransaction BeginTransaction(IsolationLevel isolationLevel);
public IDbTransaction BeginTransaction(double activeTime);
public IDbTransaction BeginTransaction(IsolationLevel isolationLevel, double activeTime);
public bool Commit();
protected static int Delete(string condition);
protected static int Delete(string condition, out Transaction transaction);
public int DeleteById();
public static int DeleteById(T entity);
public static int DeleteById(IList entities);
public static int DeleteById(IList entities, out Transaction transaction);
public static int DeleteById(T entity, out Transaction transaction);
public int DeleteByPK();
public static int DeleteByPK(T entity);
public static int DeleteByPK(IList entities);
public static int DeleteByPK(IList entities, out Transaction transaction);
public static int DeleteByPK(T entity, out Transaction transaction);
protected void OnPropertyChanged(MethodBase propertyMethod);
protected void OnPropertyChanged(string propertyName);
protected internal override void RetrieveBySql(string sql);
public bool Rollback();
protected static int Update(T entity, string condition);
protected static int Update(T entity, string condition, out Transaction transaction);
public int UpdateById();
public static int UpdateById(IList entities);
public static int UpdateById(T entity);
public static int UpdateById(T entity, out Transaction transaction);
public static int UpdateById(IList entities, out Transaction transaction);
public int UpdateByPK();
public static int UpdateByPK(IList entities);
public static int UpdateByPK(T entity);
public static int UpdateByPK(IList entities, out Transaction transaction);
public static int UpdateByPK(T entity, out Transaction transaction);
// Properties
public bool Changed { get; }
public List ChangedPropertyNames { get; }
}
public class StoredProcedure : IStoredProcedure
{
public bool BeginTransaction();
public void CloseReader(IDataReader reader);
public bool Commit();
public DataSet ExecuteDataSet();
public DataTable ExecuteDataTable();
public DataTable ExecuteDataTable();
public List ExecuteEntity();
public int ExecuteNonQuery();
public IDataReader ExecuteReader();
public object ExecuteScalar();
protected static void InitializeGateway(GatewayConfig config);
protected static void InitializeGateway(DatabaseType dbType, string connectionString);
protected void InitializeInstance(T entity);
public bool Rollback();
}
public class AggregateEntity where T: AggregateEntity, new()
{
public static List Execute();
protected static List Execute(string condition);
public static DataTable ExecuteDataTable();
protected static DataTable ExecuteDataTable(string condition);
protected static void InitializeGateway(GatewayConfig config);
protected static void InitializeGateway(DatabaseType dbType, string connectionString);
// Properties
protected static Order SortedOrder { get; set; }
}
public static class EntityMapper
{
// Methods
public static void AdaptToDatabase(DataTable adaptedTable);
public static void AdaptToEntity(DataTable rawTable);
public static void CopyToEntities(IList entities, IList adaptedRows);
public static void CopyToEntities(IList entities, DataTable adaptedTable);
public static void CopyToEntity(T entity, DataRow row);
public static List CreateEntities(int count);
public static DataTable CreateTable();
public static DataTable CreateTable(bool isAdapted);
public static string ToColumnName(string propertyName);
public static List ToEntities(IList adaptedRows);
public static List ToEntities(DataTable table);
public static T ToEntity(DataRow adaptedRow);
public static string ToPropertyName(string columnName);
public static DataTable ToTable(IList entities);
public static DataTable ToTable(params T[] entities);
public static DataTable ToTable(bool isAdapted, params T[] entities);
public static DataTable ToTable(bool isAdapted, IList entities);
}
public static class EntityUtility
{
// Methods
public static List Inherit(IList entities);
public static T Inherit(object entity);
public static T Inherit(Tbase baseEntity, TransformAction method);
public static List Inherit(IList baseEntities, TransformAction method);
public static void ShadowCopy(IList targetEntities, IList sourceEntities);
public static void ShadowCopy(object targetEntity, object sourceEntity);
}
文章介绍了sqlalchemy-codegen工具，它能基于sqlalchemyORM框架自动生成实体层Model和控制器代码，支持Flask，可以按需针对整个数据库或特定表生成代码，且能将每个表的实体文件单独存放。此外，它还支持反向引用、忽略特殊列、逻辑删除等功能，简化了开发过程。
362
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
