One of RSI’s clients we develop and maintain a database containing information pertaining to their business as well as an application they can use to interact with the database. For a successful result we use a solution called LLBLGen Pro, an Entity Modeling software that seamlessly maps elements and functions of the database into objects the application code can interact with.
LLBLGen Pro is an application that creates a separate project within RSI’s solution. It is specifically designed to house the various entity classes, stored procedure caller functions, and the various fields involved as the interdependencies between various entities. The application interface allows RSI to update the project with the most recent schema from our database simply and easily. LLBLGen Pro picks and chooses which aspects of the database to create entity and stored procedure definitions for in the code, preventing the application from becoming bloated unnecessarily.
The projects created assist in making tasks easier from the development perspective since it reduces the time it takes to integrate new schema changes when compared to a custom-object class or a clunky database query in code. It also makes the objects and functions clearer and more obvious when reading code back, making fixing potential errors much easier down the road.
Flexibility is a big asset when it comes to updating the general structure of our application or database. RSI recently upgraded the client’s application entity framework and the LLBLGen Pro integration was seamless with the latest version of the product. Even if RSI moved the database away from a service like Microsoft SQL Server to a service like MySQL, the application will continue to thrive in a different environment.