Object Relational Mapping design

Closed Posted Aug 4, 2005 Paid on delivery
Closed Paid on delivery

We want to integrate an Object Relational Mapping (ORM) layer into an existing application. We prefer to use LLBL Gen Pro as the ORM tool, but it's templates will need to be extensively modified.

Our business entities cannot inherit from base classes in the ORM layer. Basically, this project consists of modifying the templates that LLBL uses to generate the persistence code to remove the inheritance requirement. It will require writing some new templates. Writing LLBL templates isn't very difficult (if you think it is difficult, this is the wrong project for you). Where we need some real expertise is at the design/architecture level.

The LLBL runtime support classes will also need to be modified, but our own team is capable of doing this work -- it just needs to be coordinated with the design of this project, so it is the coder's responsibility too although we may be able to help with the implementation.

The persistence code must fully support our existing business objects and all their advanced functionality. We will not modify our business layer nor will we consider any solution that compromises our advanced business object functionality. All persistence optimizations and security features of the shipping LLBL templates must be maintained in the new/modified templates.

If you are an ORM expert (even if you haven't used LLBL Gen Pro before), please consider this project. (However, if you can't show us previous enterprise-level ORM projects, don't bother bidding.)

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

4) Deliverables must work with LLBLGen Pro.

5) Code should use design patterns and an overall architecture that meets buyer's approval.

6) Code must be well commented (stating why, not what) and identifiers must use good names.

7) At a minimum, the code should conform to best practices such as those described in this book "Effective C#: 50 Specific Ways to Improve Your C#" By Bill Wagner

8) Coder must write and deliver a full set of tests (from simple to complex) showing that the deliverables can pass all tests. Tests are subject to approval of buyer and buy may alter/edit tests to make them acceptable.

9) Coder must fix bugs!

10) Final payment will be made only after buyer has fully tested the delivered product for a reasonable period of time to ensure that it works adequately.

## Platform

.NET framework 1.1 and 2.0.

Code must be written in C#.

Templates must be written in LLBL Gen Pro template languages and generate C#.

Generated code must support MS SQLServer.

Project must run in VisualStudio 2003 and 2005.

Coder must be available to chat over Yahoo or MSN instant messaging each working day during this project during reasonable business hours for the US Eastern time zone.

C# Programming Engineering Microsoft MySQL PHP Software Architecture Software Testing SQL Windows Desktop

Project ID: #3835763

About the project

1 proposal Remote project Active Aug 21, 2005

1 freelancer is bidding on average $680 for this job

Sameeh

See private message.

$680 USD in 14 days
(13 Reviews)
3.5