Tag: orm

web and orm framework

Orm

Entities and their maps are managed in Excel and generated using QGen.

  • Entity has Id and auditing columns (created / updated).
  • TableName, fieldNames and Captions are defined in an EntityMap.
  • DBManager (base class)
    • Generates Insert / Update based on Id = default or not.
    • Loads one / list using db reader given constructor as argument.
    • Fluently build DbCommand with sql string and named parameters.
    • Execute command with an expected rows to update and message to throw if rowcount not expected.

Read more »