I have recently evaluated a few code generators and (Object Relational Model) ORM frameworks in .NET, to my surprise, there were quite a few of them all with there own unique sets of pro’s and con’s and designed for various stages of development.

Why do we need an ORM/Code generator?

The main purpose here is to eliminate writing repetitive and static code; this will lead to a higher quality product, developed in a much shorter time. 

The repetitive/static code I am referring to is CRUD (Create, Read, Update and Delete), CRUD is common and is required by almost all applications, it is repetitive and error prone, Crud requires lots of testing time which can be reduced if code is automatically generated and it can take a lot of time (like weeks) if the database used is huge.

The Evaluation 

As mentioned, there are many ORM/code generators out there, each with there own pro’s and con’s, these are the features I looked for when selecting our ORM.

• Support for hierarchies and relationships,
• Support for grouping and aggregate functions,
• Support for transactions,
• Database independent,
• Concurrency,
• Performance and footprint,
• Learning curve and simplicity with which it can be integrated into code,
• Up to date documentation,
• Online support,
• Reasonable price.

End Result 

 
My evaluation has lead to an ORM and code generator that complement each other well, satisfy all of the above requirements, and has now been implemented as the core foundation of our development framework. 

 
Implementation has been successful and development time and quality of the product has been noticeably improved within the first week of implementation. This has a knock on effect that affects the clients directly, as greatly reduced development time means cheaper pricing and a happier client.

Nadir Kamdar

Hello All, and welcome to my first Blog. 

I guess its only right to start off with an introduction.  My name is Nadir Kamdar,  I am a Microsoft Consultant for SMC Enterprise. 

I gratuated from the University of Cape Town back in 1999, with a B-Com degree, and majored in Infomation Systems, I soon started working for SMC Enterprise (then knowned as Shocked) as ASP Developer.  I have from then till know specialised in ASP, ASP.NET, SQL, Sharepoint and a few other Microsoft toys.  

I have worked in Vodacom, MEC-SA, City Of Cape Town,  Creda Communications and even in Saudi for a company called Saudi Aramco.

I am currently more a Project Manager/Consultant/Developer, but plan to use this blog to assist developers, as well as talk about things that i believe are of interest in the Microsoft IT space and also talk about the services offered in SMC Enterprise.

SMC Enterprise has many experts, and this blog will be used by them as well, so I am sure this space will provide a interesting source of information no matter whats your interest.

Nadir Kamdar