Naming Convention war

Posted on 2011-05-10
Last Modified: 2012-05-11
We are having a naming convention war.

I'm working with the Data Warehouse Database and want to have all columns that are flags have the naming convention with 'is' in front of the column.

The ETL programmer working in C# does not want 'is' in front of the column because the ORM tool takes the database columns and automatically adds the prefix 'is' in front of the boolean.  So it will create isisColumnName.  So he wants me to have no 'is' prefix for booleans.

I'm not a C# programmer so I am not familiar with the ORM tool.

Any suggestions or ideas would be appreciated!
Question by:Bodhi108
    LVL 82

    Expert Comment

    by:Dave Baldwin
    Use something else like 'flg' for 'flag'.  Then you'll end up with 'isflgColumnName'.

    Author Comment

    The code in C# would be 'isisColumnName' and the Database Column would be isColumnName.   For example, isRegistered in DB would become isisRegistered.  

    So he wants me to have no 'is' for columnName.  For example, he is suggesting to have 'Registered' as columnName in Database and isRegistered in C#.  

    What he can do is after the ORM creates the names, he can change them but he doesn't want to...

    I thought of having RegisteredFlag but it is not as clear whether the it means the person is registered or not.
    LVL 40

    Accepted Solution

    So he has problems with his ORM tool but wants you to model your database schema around it. Unacceptable, especially if you are doing data driven design.

    Tell him to learn how to drive his ORM tool so you don't have to make compromises in YOUR model so he can have HIS model to his liking. Your database model column name is just as critical as the entity field names. The issue he speaks of isn't that hard to workaround, depending on the ORM.

    Last resort, tell him how to use simple search/replace in Visual Studio to replace 'isIs' with 'is'  :)

    Author Closing Comment

    Exactly what I needed to hear!

    Author Comment

    Yes, I was thinking exactly that but I needed to hear it from a person who has experience with the ORM tool.  Because I don't have that particular coding expertise there is a good chance I will be voted against since there is only one of me and several C# coders...  

    Hopefully, I can present it in a way that is understood (not compromising standards).

    LVL 40

    Expert Comment

    Well, don't misinterpret me, I don't feel like you shouldn't be open to compromise, but only when it is technically unreasonable not to. In this case, there are several simple solutions. If, however, there is no other workaround, then you have to weigh the advantages vs disadvantages.

    The thing with the ORM is he shouldn't have to re-generate the C# class repeatedly. Once he modifies the property name, it should stick.

    What I am against is making compromises for people who are lazy or don't have the skillset.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now