Simplified

Database Access

Objective: Improve the code that retrieves and sends data to the database for faster development and better maintainability.

Problems:

  • EDMX code generator is slow and difficult to customize
  • Architecture is hard for new developers to understand

Improvements:

  • Simplify code (cut down on classes)
  • Use code generation that we can customize
  • Use navigation properties (Entity Framework feature)

Before Refactor: Complicated Joins

After Refactor: Leverage Navigation Properties

Before Refactor: Code is Difficult to Read

After Refactor: More Human-Readable Names

Summary

  • Database changes faster
  • Less code (less to maintain!)
  • More intuitive architecture that follows standards
  • More readable code
  • Implementation in use by WebPay team

Simplified Database Access

By Josh Bullock

Simplified Database Access

  • 857