I am using a specific notation for my database columns/fields so I'd also like to have a way of defining a descriptive name for those columns while I'm presenting the data to my end users on screen. I'd wouldn't like to have displayed name_customer in my
form but "Customer Name" instead
I'd like to know a way of doing it at sql-server database level so I can regenerate my metadata running a script every time I make changes in my database structure. It seems that there is no way of adding an alias name to your columns in sql-server ... or
is there a way?
How can I achieve that
What I'm saying is taht I know that I can get what I wnat at MetaData file level but is somethings which must be done manually and I'd like to have a way of automating that process
Thanks. It seems that http://mattberseth2.com/downloads/custom_metadata.zip is down to downlaod the source code fileor maybe it is fully included in your package ?
Hi Kcla, I like to give hime credit but yes it is down and has been for some time, my version deals with Column and Tables names and I think his only did column names.
See my blog C# Bits | Twitter @sjnaughton Always seeking an elegant solution.
I think you might as well send the original http://mattberseth2.com/downloads/custom_metadata.zip file instead of anything else from your part. I guess implementation should be in that file which is unfortunatelly offline now
Sorry for late answer ---- and Yes. I'll give it a try!!! It seems that the only thing to do is add it in the Global.asax file but I'd like to have a repository in which I could make future lookups of column names in the event of a minor/bigger database
change ... like having a dictionary with three columns : tablename, colum name and display name
klca
Member
507 Points
413 Posts
Metadata Column names vs aliases
Nov 06, 2012 04:01 PM|LINK
Hi,
I am using a specific notation for my database columns/fields so I'd also like to have a way of defining a descriptive name for those columns while I'm presenting the data to my end users on screen. I'd wouldn't like to have displayed name_customer in my form but "Customer Name" instead
I'd like to know a way of doing it at sql-server database level so I can regenerate my metadata running a script every time I make changes in my database structure. It seems that there is no way of adding an alias name to your columns in sql-server ... or is there a way?
How can I achieve that
What I'm saying is taht I know that I can get what I wnat at MetaData file level but is somethings which must be done manually and I'd like to have a way of automating that process
Carlos N. Porras
(El Salvador)
sjnaughton
All-Star
27330 Points
5459 Posts
MVP
Re: Metadata Column names vs aliases
Nov 06, 2012 05:21 PM|LINK
Hi Kcla, try this
Dynamic Data – Custom Metadata Providers *** UPDAT...
this is based on some work Matt Berseth's did here Dynamic Data And Custom Metadata Providers
Always seeking an elegant solution.
klca
Member
507 Points
413 Posts
Re: Metadata Column names vs aliases
Nov 06, 2012 09:32 PM|LINK
Hi Steve,
Thanks. It seems that http://mattberseth2.com/downloads/custom_metadata.zip is down to downlaod the source code fileor maybe it is fully included in your package ?
Carlos N. Porras
(El Salvador)
sjnaughton
All-Star
27330 Points
5459 Posts
MVP
Re: Metadata Column names vs aliases
Nov 07, 2012 01:08 PM|LINK
Hi Kcla, I like to give hime credit but yes it is down and has been for some time, my version deals with Column and Tables names and I think his only did column names.
Always seeking an elegant solution.
klca
Member
507 Points
413 Posts
Re: Metadata Column names vs aliases
Nov 07, 2012 04:56 PM|LINK
Hi Steve,
I was asking not because I don't think that you have done what you did but to find an example of its implementation
In the link you gave it was this
2: {5: });klca
Member
507 Points
413 Posts
Re: Metadata Column names vs aliases
Nov 08, 2012 03:00 PM|LINK
Hi Steve,
Would you mind helping me out with an example of its implementation please? Is there a download with source code for this post?
Carlos N. Porras
(El Salvador)
sjnaughton
All-Star
27330 Points
5459 Posts
MVP
Re: Metadata Column names vs aliases
Nov 08, 2012 10:09 PM|LINK
Hi Kcla, e-mail me direct and I will send you a working sample.
Always seeking an elegant solution.
klca
Member
507 Points
413 Posts
Re: Metadata Column names vs aliases
Nov 09, 2012 09:39 PM|LINK
Hi Stewve,
I think you might as well send the original http://mattberseth2.com/downloads/custom_metadata.zip file instead of anything else from your part. I guess implementation should be in that file which is unfortunatelly offline now
Carlos N. Porras
(El Salvador)
sjnaughton
All-Star
27330 Points
5459 Posts
MVP
Re: Metadata Column names vs aliases
Nov 11, 2012 11:31 AM|LINK
Hi Carlos, I have sent you my latest did you get it?
Always seeking an elegant solution.
klca
Member
507 Points
413 Posts
Re: Metadata Column names vs aliases
Nov 12, 2012 08:16 PM|LINK
Hi Steve
Sorry for late answer ---- and Yes. I'll give it a try!!! It seems that the only thing to do is add it in the Global.asax file but I'd like to have a repository in which I could make future lookups of column names in the event of a minor/bigger database change ... like having a dictionary with three columns : tablename, colum name and display name
Carlos N. Porras
(El Salvador)