Life of a .Net Developer's Life Made Easier

I am not a DBA; actually I am not very good with databases at all. I am a software engineer, but I have to write database code all the time. Developer managers tend to blur the skill sets of DBAs and developers and often think that I can act as one. I often found myself asking "Is there a tool that can help me write database code and even allow DBAs or other developers to come in and easily tune it?"

As a matter of fact, I am one of the core engineers of this system and this is exactly the reason why I am working in this company. I always wanted such a tool to assist me with both SQL and ADO.Net. I always wanted to be able to manage the code that relates to my database tier in one solution.
 

I used to hate searching through multiple files trying to find out where the database access code that relates to a problem is so I can look at it and fix it. The worst part is that most of the time the “discovered” database access code requires other libraries to compile (nobody forces isolation of the database tier); I'd have to find all of the missing libraries and setup configurations to test the database transaction. The truth of the matter is that I came across the same issues in all of the projects with which I have participated. Between all of the searching, configuration and setup, and the lack of unit tests (of which most tended to be outdated), an exorbitant amount of time and money would be wasted.


With Orasis Mapping Studio,  I do not have to write unit tests and they are up to date at all times without writing any test code. My database tier is in one place and I do not have to deal with any configuration files at all. If I need to point to a different database I simply edit my connection and I am ready to go. Another big relief is that I can see the actual data and verify the validity of my results in the same IDE. I do not need to get to another application to do that. When my data access performance is not adequate, I can always ask the DBA to come, put him in the query designer and look at my queries.

 

I believe that the best development tools for engineers are created by engineers based on their experiences. I hope my two year effort in this product will make other engineers' lives easier and more productive.