asp.net Dynamic Data Site own MetaData

Posted by loviji on Stack Overflow See other posts from Stack Overflow or by loviji
Published on 2010-04-20T18:21:53Z Indexed on 2010/04/20 18:23 UTC
Read the original article Hit count: 300

Filed under:
|
|

Hello, I'm searching info about configuring own MetaData in asp.NET Dynamic Site.

For example. I have a table in MS Sql Server with structure shown below:

CREATE TABLE [dbo].[someTable](
    [id] [int] NOT NULL,
    [pname] [nvarchar](20) NULL,
    [FullName] [nvarchar](50) NULL,
    [age] [int] NULL)

and I have Ms Sql table, sysTables and sysColumns.

sysTables:

ID sysTableName TableName TableDescription

1 | someTable |Persons |All Data about Persons in system

sysColumns

ID TableName sysColumnName ColumnName ColumnDesc ColumnType MUnit

1 |someTable | sometable_pname| Name | Persona Name(ex. John)| nvarchar(20) | null
2 |someTable | sometable_Fullname| Full Name | Persona Name(ex. John Black)| nvarchar(50) | null
3 |someTable | sometable_age| age | Person age| int | null

© Stack Overflow or respective owner

Related posts about dynamic-data

Related posts about ASP.NET