Sql tables and columns description

8 posts, 0 answers
  1. Filipe Peixinho
    Filipe Peixinho avatar
    41 posts
    Member since:
    May 2006

    Posted 09 Jul 2009 Link to this post

    Greetings.

    I would like to know if is possible and if there is a way of retrieving sql tables and columns description from database in a Reverse Mapping scenario and/or generate in the Database  those descriptions in a Forward MApping scenario.

    Thanks
  2. Peter Brunner
    Admin
    Peter Brunner avatar
    89 posts

    Posted 10 Jul 2009 Link to this post

    Hello Filipe,

    Telerik OpenAccess ORM supports both ways.

    Our blog post Model first or Schema First provides a good introduction into this and provides further links to other resources.

    Regards,
    Peter Brunner
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Check out the tips for optimizing your support resource searches.
  3. DevCraft banner
  4. Filipe Peixinho
    Filipe Peixinho avatar
    41 posts
    Member since:
    May 2006

    Posted 10 Jul 2009 Link to this post

    Greetings.

    I'm not able to find any information on the link you've provided that is related to my question.
    I think i haven't made myself clear.

    There's a link below to complete my previous question:
    http://files.getdropbox.com/u/479032/TableDescription.jpg
  5. Dimitar Kapitanov
    Admin
    Dimitar Kapitanov avatar
    632 posts

    Posted 10 Jul 2009 Link to this post

    Hi Filipe Peixinho,
    We have it already in our TODO list as an enhancement to our runtime DLL capabilities (you can find more about artificial fields and generic data access in our documentation http://www.telerik.com/help/openaccess-orm/openaccess-tasks-howto-use-artificial-fields.html and http://www.telerik.com/help/openaccess-orm/generic-data-access-overview.html). While we are unable to say when exactly it will make it inside the product I believe it will be lately for Q1 2010. Hope that helps.

    Regards,
    Dimitar Kapitanov
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Check out the tips for optimizing your support resource searches.
  6. Dimitar Kapitanov
    Admin
    Dimitar Kapitanov avatar
    632 posts

    Posted 10 Jul 2009 Link to this post

    Hi Filipe Peixinho,
    We have it already in our TODO list as an enhancement to our runtime DLL capabilities (you can find more about artificial fields and generic data access in our documentation http://www.telerik.com/help/openaccess-orm/openaccess-tasks-howto-use-artificial-fields.html and http://www.telerik.com/help/openaccess-orm/generic-data-access-overview.html). While we are unable to say when exactly it will make it inside the product I believe it will be lately for Q1 2010. Hope that helps.

    Regards,
    Dimitar Kapitanov
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Check out the tips for optimizing your support resource searches.
  7. Simsonic
    Simsonic avatar
    2 posts
    Member since:
    Oct 2008

    Posted 10 Jul 2009 Link to this post

    Hi there

    This function would be verry useful. Its quite annoying to write the description in the database AND in the classes. So i hope you can implement this function!

    Regards,
    Simon Wermuth
  8. Allen
    Allen avatar
    42 posts
    Member since:
    Nov 2014

    Posted 06 Jan 2015 in reply to Dimitar Kapitanov Link to this post

    You misunderstand his meaning.
    We have describing each table in your database table design, as well as the summary information for each field.
    We hope to ORM these description information can be retrieved from the database and mapped in the entity class to describe writing entity classes as text files.
    Just like this:

    private int _attrId;
    [System.ComponentModel.DataAnnotations.Required()]
    /// <summary>
    /// This is a Attribute Id
    /// </summary>
    public virtual int AttrId
    {
        get
        {
            return this._attrId;
        }
        set
        {
            if(this._attrId != value)
            {
                this.OnPropertyChanging("AttrId");
                this._attrId = value;
                this.OnPropertyChanged("AttrId");
            }
        }
    }
  9. Viktor Zhivkov
    Admin
    Viktor Zhivkov avatar
    291 posts

    Posted 09 Jan 2015 Link to this post

    Hi Allen,

    You are welcome to post your feature suggestions in our Ideas and Feedback portal.
    There other clients will be able to see your suggestion, comment and vote for it if they want to support it.

    Regards,
    Viktor Zhivkov
    Telerik
     
    OpenAccess ORM is now Telerik Data Access. For more information on the new names, please, check out the Telerik Product Map.
     
Back to Top
DevCraft banner