Silly question on model first design

2 posts, 0 answers
  1. kieron
    kieron avatar
    9 posts
    Member since:
    Dec 2010

    Posted 03 Oct 2011 Link to this post

    I am starting to play around with Open access ORM and i have done my schema in model first designer. I have created for example a table called contacts with fields  below
    contactId
    name
    phone
    email

    When i click on use default mapping to create the tables it appends a 1 to the end of all the tables fields ie below
    contact_id1
    name1
    phone1
    email1

    Why is it doing this as this will look ugly having a 1 at the end of all the tables? am i doing something wrong? i have checked the naming rules section and nothing is there. i would think it would make the table field names the same as the domain model? I am using Telerik-OpenAccess-ORM-FreeEdition-2011.2.908.1
  2. PetarP
    Admin
    PetarP avatar
    754 posts

    Posted 05 Oct 2011 Link to this post

    Hi Kieron,

     The naming settings you are referring to are only applicable in reverse mapped scenarios. For forward mapping we are depending on a common mechanism for calculating the name that currently cannot be altered (it would be in the future).
    As for the numbers - they get applied when our runtime generates a column for a field that is not previously associated with such but a column with the same name already exist in that table. The newly generated column automatically gets a number appended in the end. Can you please open your rlinq file with an xml editor and check if in the tables node for your specific table there are more columns defined than the ones you are seeing. Maybe the problem lies there.

    Greetings,
    Petar
    the Telerik team
    Want to use Telerik OpenAccess with SQL Azure? Download the trial version today. 
  3. DevCraft banner
Back to Top