Five Reasons For Using An O/r Mapping Tool
|
So, why should you use any O/R mapping tool? I am not talking about a specific tool but rather all O/R mapping tools in general. There are a number of reasons for using an O/R mapping tool but before I dive into that, let me give you a brief overview of what an O/R mapping tool really is.
An O/R mapping tool generates persistence objects for your .NET application. It is a modeling and code generation tool that connects to your database and reads its schema, then lets you map objects to database tables and views, specify single-row insert, update, load, and delete operations, queries and stored procedure calls, as methods to these objects. And, it also lets you define one-to-one, one-to-many, many-to-one, and many-to-many relationships between objects based on relationships between tables in the database. It then generates fully working persistence objects code for you.
There are many other features that a good O/R mapping tool provides but I'm keeping my description brief so I can talk more about the benefits.
Reason 1: Cuts down your development time
First benefit of an O/R mapping tool is that it saves you a ton of development time (20% to 50% time depending on your situation). Now, O/R mapping tool is not generating any "rocket science" code for you and you could definitely do it manually if you wanted. But, this is a lot of tedious work and you would definitely be happier if you didn't have to do it yourself. Let's do some simple math.
A typical application with 15-20 database tables has 30-50 objects (including domain and factory objects) and this is roughly 5000 to 10,000 lines of code. It is likely to take you a few weeks to a couple of months to develop and test this code. And, if your application has more tables than this (which many do), then just multiple the above numbers by that much.
On the other hand, an O/R Mapping tool would generate this code for you in a day or two. Even here, you need these 1-2 days primarily to determine your object mappings to the database. The actual code generation is instantaneous. So, your time saving is tremendous.
Reason 2: Produces better designed code
Second benefit of an O/R mapping tool is that it lets you produce better designed code than doing it yourself by-hand. I know what you're thinking. You think you can do a better job than an O/R mapping tool because you write every aspect of your code. Some of you definitely can but not everyone. Consider this. An average development team has different levels of expertise and experience and not everybody is a good designer. As a result, they may not follow design patterns in their code and end up with a lesser quality code. And, if multiple developers are writing code, their code is very likely going to be inconsistent with each other. And, inconsistency itself is a big source of poor quality in an application's code.
On the other hand, a good O/R mapping tool uses code templates that have excellent design because they are very likely designed and created by very senior (architect level) engineers. And, these code templates almost always follow known design patterns. So, the code that you'll generate from an O/R mapping tool is very likely going to be better designed than code designed by your own development team.
Reason 3: You don't have to be a .NET expert
Third benefit of using an O/R mapping tool is that you don't have to be a .NET expert to develop your persistence code. As you know, data access code is critical for the overall performance of your application. If this code is designed and developed poorly, it can severely affect your application. So, if you developed this code by hand, you need to be an export of .NET, COM+, stateless components, and MTS.
However, if you use an O/R mapping tool, you can focus primarily on the "logical design" of your persistence objects including object mapping and the different types of interactions with the database including insert, update, load, delete, queries, stored procedure calls, relationships, and more. And, the O/R mapping tool would do the rest for it. It would ensure that the generated code follows all the best practices of writing stateless .NET components to run in COM+ and MTS.
Reason 4: Saves you testing time
Fourth benefit of an O/R mapping tool is that it reduces your testing effort dramatically. If you developed all the persistence code by hand, you would also be responsible for testing it yourself. And, as you know, testing is as much effort as development in any project.
On the other hand, if you generated code from an O/R mapping tool, it is coming from code templates that are very likely thoroughly tested by the software vendor itself (more so than you because it is their primary focus). And, on top of it, most likely hundreds or perhaps thousands of other customers are using this tool and have tested the code generated from this O/R mapping tool. As a result, many of the bugs that you might not find in your own testing have already been found and fixed in the generated code of an O/R mapping tool.
Reason 5: Simplifies your .NET development
If you have to write all the persistence code yourself, you're bogged down into the details of ADO.NET, COM+, MTS, stateless .NET components, and more. And, you end up spending a lot of time in details that you really don't need to. On the other hand, if you generate code from an O/R mapping tool, you get well design objects and you only need to deal with their public interface.
Below is an example of code you'll write if you used an O/R mapping tool.
try {
Employees objInfo = new Employees();
EmployeesFactory objFactory = new EmployeesFactory();
objInfo.EmployeeID = EmployeeID;
objFactory.Load(objInfo);
// code here to use the "objInfo" object } catch(Exception ex) {
// code here to handle the exception
return; }
As you can see, the generated code is very simple to use than actually writing the .NET components yourself.
Many people have never heard of O/R mapping tools and many more have heard of them but are afraid to use them. I hope I have made a strong enough case here for you to give a serious consideration to O/R mapping for your project.
Iqbal Khan is the Director of Sales & Marketing at AlachiSoft (http://www.alachisoft.com/), a leading provider of O/R Mapping tool called TierDeveloper. You can reach him at iqbal@alachisoft.com.
|
|
|
Free Program Removes Spyware Not Detected By Premium Security Scan
What is Spyware?Spyware monitors your surfing habits and sends the data off to some remote server in cyberland. Your computer can get infected with spyware easily by visiting a web page or installing a software program. Kazza is a classic example of a free software download riddled with spyware. More info here: http://compactURL.com/sd...(related: Software)
Do You Know These Facts About Spyware ?
Imagine something that follows you home and sets itself upin your house. It eats your food, enjoys your drinks, readseverything you bring home or purchase. It runs up yourphone bills and no matter where you go, it can follow youand takes notes on everything you do.Generically labeled spyware, your stealth visitor is aprogram or set of programs designed to track your Internetactivity. And, while it hasn't gone as far as above,...(related: Software)
Information Products: A Business Owners Best Friend
We live in a post-industrial age where information is the coin of the realm. Knowledge is the most valuable asset that a business owns. For most businesses, that knowledge exists primarily in the heads of the people who work there. For entrepreneurs and sole practitioners, what's in their head usually is the business. That's both limiting and dangerous.Let's take the example of a successful management consultant. Drawing on her knowledge and experience, she's able to hire herself out at a substantial hourly rate. The trouble is, every time...(related: Software)
Microsoft Great Plains Accounting/erp Implementation ? Finance Industry Customization Example
Microsoft Business Solutions Great Plains is very generic accounting application out of the box and has multiple modules to address specific horizontal or vertical market requirements. At the same time Great Plains, now being moved on MS SQL Server platform allows you to deploy standard tools to customize and fit to these requirements, when you don...(related: Software)
Simple Solution For Php Includes - Iframes
I have recently created my first Php program. I wanted to share with others some of the problems that I encountered, and how I finally overcame these obstacles.My Reason for needing a Php IncludeTo start, my most recent website features a free classified advertising solution, a modified version of PhpBB stripped to function as an Article Bulletin Board (No replying), and a link directory. The business model of my Website offers free Classified Ad...(related: Software)
Need Of Document Management System (dms)
Document Management or Enterprise Information Management is perhaps one of the most important of the enterprise solutions tha...(related: Software)
Crook: A Methodology For The Refinement Of Forward-error Correction
Table of Contents1) Introduction2) Related Work3) Framework4) Implementation5) Performance Results5.1) Hardware and Software Configuration5.2) Experiments and Results6) Conclusion1 IntroductionMany cyberinformaticians would agree that, had it not been for SMPs, the visualization of cache coherence might never have occurred. The usual methods for the essential unification of neural networks and model checking do not apply in this area. On a similar note, By comparison, it should be noted that our methodology is built on the principles of artificial intelligence. Thusly, the improvement of the World...(related: Software)
Great Plains Dexterity Development: Faq
Microsoft Business Solutions Great Plains is Dexterity-written application and currently we see increased interest for Great Plains customers to do in-house Dexterity development and customization. Dexterity itself is written on C programming language and its initial architecture was based on the Graphical and Database platform independence, which C programming language was believed to provide. Initially back in 1994 Great Plains Software Dynamics and Dynamics C/S+ were realized for Macintosh and Windows and pretty similar Dexterity DYNAMICS.DIC dictionary worked for Ctree/Faircomm and Microsoft SQL Server 6.5. In our days Microsoft Great Plains is available for Windows and MS SQL Server only (since version 8.0). In this small article we would like to give you highlights on the most typical entry level Dexterity development question...(related: Software)
Microsoft Great Plains Implementation In Russia ? Overview For Consultant
Microsoft Business Solutions Great Plains is very popular ERP platform in the USA, Canada (including French speaking Quebec/Montreal), U.K., Australia, New Zealand, South Africa, Middle East: OAE, Egypt, Arabia, Latin America. Former versions ? Great Plains Dynamics/eEnterprise was also popular in Europe: France, Poland, Russia. When Microsoft acquired Navision Software ? and handed it out to its subdivision: Microsoft Business Solutions ? we saw some geo-strategy changes. Navision, the leader on the European mid-market and successfully overcoming such localization barriers as language translation, adaptation to country-specific taxes and payroll taxes ? was chosen as preferred or the only recommended solution for emerging markets. In Russia we saw dramatic situation, when ...(related: Software)
Multinational Corporation Erp Implementation ? Microsoft Business Solutions Great Plains
If you look back to the history, you will see that ERP for large publicly traded company had to be built upon very reliable hardware (more likely non-Intel hardware: mainframe, Sun sparc, etc.), powerful database platform: Oracle, DB2, Ingress, Sybase and reliable OS: UNIX. 10 years ago Microsoft had Wi...(related: Software)
Downloading Spyware Removers: Think Before, Not After
Just imagine: you are walking, say, towards your car, and all of a sudden somebody comes up to you and begins? polishing your shoes. Or even better example--a guy you've never met before opens the hood of your car, says the engine is broken and tries to persuade you to add some gadget your car desperately needs--and now! What you'd do if such a crazy thing happened? Wouldn't you readily accept the help, paid for it and...(related: Software)
Microsoft Great Plains Implementation: Collection Management ? Overview For Consultant
Microsoft Business Solutions Great Plains is very good fit for mid-size company and probably good budget solutions for large corporation. Being matured product ? Great Plains provides such horizontal solutions as Collection department automation. The most common question we hear in collection department is how we assign problem clients to sp...(related: Software)
Microsoft Blues
With the advent of 'Service Pack 2' for Windows XP operating system, Microsoft have really made the forums hum.Every forum on computer problems is replete with complaints that since downloading and installing 'SP2', many 'third party' appli...(related: Software)
site-map - Copyright © 2008 | Contact Webmaster | All Rights Reserved. | Software