MetaModel.GetTable 方法

参考

定义

命名空间:: System.Web.DynamicData

程序集:: System.Web.DynamicData.dll

重要

一些信息与预发行产品相关，相应产品在发行之前可能会进行重大修改。对于此处提供的信息，Microsoft 不作任何明示或暗示的担保。

返回描述数据模型表的元数据。

重载

GetTable(String, Type)	返回描述指定表的元数据。
GetTable(Type)	返回描述指定表的元数据。
GetTable(String)	返回与指定表关联的元数据。

示例

以下示例演示如何使用 GetTable 重载方法执行以下任务：

MetaTable获取指定表的对象。
访问对象包含的 MetaTable 元数据信息。

该示例由页面及其代码隐藏文件组成。

<%@ Page Language="C#" AutoEventWireup="true" 
CodeFile="GetTable.aspx.cs" 
Inherits="DocGetTable" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
  <title></title>
</head>
<body>
    <h2>GetTable Methods</h2>

    <form runat="server">
  
     <asp:GridView ID="GridDataSource1" runat="server"
        AutoGenerateColumns="false"
        DataSourceID="LinqDataSource1"
        AllowPaging="true">
        <Columns>
          <asp:DynamicField DataField="FirstName" />
          <asp:DynamicField DataField="LastName" />
          <asp:TemplateField HeaderText="Addresses">
            <ItemTemplate>
              <%# GetAdresses(2)%>
            </ItemTemplate>
          </asp:TemplateField>
        </Columns>
      </asp:GridView>
        
    </form>
    
     <asp:LinqDataSource ID="LinqDataSource1" runat="server" 
        TableName="Customers"
        ContextTypeName="AdventureWorksLTDataContext" >
      </asp:LinqDataSource>
</body>

<%@ Page Language="VB" AutoEventWireup="false" 
CodeFile="GetTable.aspx.vb" 
Inherits="GetTable" %>

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
  <title></title>
</head>
<body>
    <h2>GetTable Methods</h2>

    <form id="Form1" runat="server">
  
     <asp:GridView ID="GridDataSource1" runat="server"
        AutoGenerateColumns="false"
        DataSourceID="LinqDataSource1"
        AllowPaging="true">
        <Columns>
          <asp:DynamicField DataField="FirstName" />
          <asp:DynamicField DataField="LastName" />
          <asp:TemplateField HeaderText="Addresses">
            <ItemTemplate>
              <%# GetAdresses(2)%>
            </ItemTemplate>
          </asp:TemplateField>
        </Columns>
      </asp:GridView>
        
    </form>
    
     <asp:LinqDataSource ID="LinqDataSource1" runat="server" 
        TableName="Customers"
        ContextTypeName="AdventureWorksLTDataContext" >
      </asp:LinqDataSource>
</body>

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Web.DynamicData;
using System.Text;

public partial class DocGetTable : System.Web.UI.Page
{
     protected void Page_Load(object sender, EventArgs e) 
     {
     }

    // Use GetTable methods.
    public string GetAdresses(int index)
    {
        // Get the default data model.
        MetaModel model = MetaModel.Default;
   
        MetaTable mTable;

        switch (index)
        {
            case 0:
                // Get the metatable for the table with the
                // specified entity type.
                mTable = model.GetTable(typeof(CustomerAddress));
                break;
            case 1:
                // Get the metatable for the table with the 
                // specified table name.
                mTable = model.GetTable("CustomerAddresses");
                break;
            case 2:
                // Get the metatable for the table with the 
                // specified table name and the specified data
                // context.
                mTable = model.GetTable("CustomerAddresses", typeof(AdventureWorksLTDataContext));
                break;
            default:
                mTable = model.GetTable(typeof(CustomerAddress));
                break;
        }

        // The following code dislays the actual value 
        // (adress) associated with a customer and link
        // to the related Addresses table.
        MetaForeignKeyColumn fkColumn = 
            (MetaForeignKeyColumn)mTable.GetColumn("Address");

        Customer row = (Customer)GetDataItem();

        StringBuilder addressList = new StringBuilder();

        foreach (CustomerAddress childRow in row.CustomerAddresses)
        {
            addressList.Append(childRow.AddressType);
            addressList.Append(":<br/>");
            addressList.Append("<a href='");
            addressList.Append(fkColumn.GetForeignKeyDetailsPath(childRow.Address));
            addressList.Append("'>");
            addressList.Append(childRow.Address.AddressLine1);
            addressList.Append("</a><br/><br/>");
        }

        return addressList.ToString();
    }
}

Imports System.Collections
Imports System.Configuration
Imports System.Data
Imports System.Linq
Imports System.Web
Imports System.Web.Security
Imports System.Web.UI
Imports System.Web.UI.HtmlControls
Imports System.Web.UI.WebControls
Imports System.Web.UI.WebControls.WebParts
Imports System.Xml.Linq
Imports System.Web.DynamicData
Imports System.Text

Partial Public Class DocGetTable
    Inherits System.Web.UI.Page
     Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)

     End Sub

    ' Use GetTable methods.
    Public Function GetAdresses(ByVal index As Integer) As String
        ' Get the default data model.
        Dim model As MetaModel = MetaModel.Default

        Dim mTable As MetaTable

        Select Case index
            Case 0
                ' Get the metatable for the table with the
                ' specified entity type.
                mTable = model.GetTable(GetType(CustomerAddress))
            Case 1
                ' Get the metatable for the table with the 
                ' specified table name.
                mTable = model.GetTable("CustomerAddresses")
            Case 2
                ' Get the metatable for the table with the 
                ' specified table name and the specified data
                ' context.
                mTable = model.GetTable("CustomerAddresses", GetType(AdventureWorksLTDataContext))
            Case Else
                mTable = model.GetTable(GetType(CustomerAddress))
        End Select

        ' The following code dislays the actual value 
        ' (adress) associated with a customer and link
        ' to the related Addresses table.
        Dim fkColumn As MetaForeignKeyColumn = CType(mTable.GetColumn("Address"), MetaForeignKeyColumn)

        Dim row As Customer = CType(GetDataItem(), Customer)


        Dim addressList As New StringBuilder()

        For Each childRow As CustomerAddress In row.CustomerAddresses
            addressList.Append(childRow.AddressType)
            addressList.Append(":<br/>")
            addressList.Append("<a href='")
            addressList.Append(fkColumn.GetForeignKeyDetailsPath(childRow.Address))
            addressList.Append("'>")
            addressList.Append(childRow.Address.AddressLine1)
            addressList.Append("</a><br/><br/>")
        Next childRow

        Return addressList.ToString()

    End Function

End Class

注解

MetaTable重载方法返回的对象包含与指定表关联的元数据信息。

运行此功能的联机示例。

GetTable(String, Type)

返回描述指定表的元数据。

public:
 System::Web::DynamicData::MetaTable ^ GetTable(System::String ^ tableName, Type ^ contextType);

public System.Web.DynamicData.MetaTable GetTable (string tableName, Type contextType);

member this.GetTable : string * Type -> System.Web.DynamicData.MetaTable

Public Function GetTable (tableName As String, contextType As Type) As MetaTable

参数

tableName: String

表的名称。

contextType: Type

要搜索表的数据上下文。

MetaTable

描述指定表的元数据。

例外

ArgumentNullException

tablename 或 contextType 为 null。

ArgumentException

未注册上下文或数据上下文中不存在表。

示例

以下示例演示如何使用 GetTable(String, Type) 该方法获取指定表的元数据。有关完整示例，请参见GetTable。

// Get the metatable for the table with the 
// specified table name and the specified data
// context.
mTable = model.GetTable("CustomerAddresses", typeof(AdventureWorksLTDataContext));

' Get the metatable for the table with the 
' specified table name and the specified data
' context.
mTable = model.GetTable("CustomerAddresses", GetType(AdventureWorksLTDataContext))

另请参阅

MetaTable

适用于

GetTable(Type)

返回描述指定表的元数据。

public:
 System::Web::DynamicData::MetaTable ^ GetTable(Type ^ entityType);

public System.Web.DynamicData.MetaTable GetTable (Type entityType);

member this.GetTable : Type -> System.Web.DynamicData.MetaTable

Public Function GetTable (entityType As Type) As MetaTable

参数

entityType: Type

标识数据模型中表的类型。

MetaTable

描述指定表的元数据。

例外

ArgumentNullException

在数据模型中找不到类型。

示例

以下示例演示如何使用 GetTable(Type) 该方法获取指定表的元数据。有关完整示例，请参见GetTable。

// Get the metatable for the table with the
// specified entity type.
mTable = model.GetTable(typeof(CustomerAddress));

' Get the metatable for the table with the
' specified entity type.
mTable = model.GetTable(GetType(CustomerAddress))

另请参阅

MetaTable

适用于

GetTable(String)

返回与指定表关联的元数据。

public:
 System::Web::DynamicData::MetaTable ^ GetTable(System::String ^ uniqueTableName);

public System.Web.DynamicData.MetaTable GetTable (string uniqueTableName);

member this.GetTable : string -> System.Web.DynamicData.MetaTable

Public Function GetTable (uniqueTableName As String) As MetaTable

参数

uniqueTableName: String

标识数据模型中表的名称。

MetaTable

描述指定表的元数据。

例外

ArgumentException

在数据模型中找不到名称。

示例

以下示例演示如何使用 GetTable(String) 该方法获取指定表的元数据。有关完整示例，请参见GetTable。

// Get the metatable for the table with the 
// specified table name.
mTable = model.GetTable("CustomerAddresses");

' Get the metatable for the table with the 
' specified table name.
mTable = model.GetTable("CustomerAddresses")

注解

该名称唯一标识数据模型中的表，并用于生成用于路由的相关 URL。

另请参阅

MetaTable

适用于

通过

MetaModel.GetTable 方法

定义

重载

示例

注解

GetTable(String, Type)

参数

返回

例外

示例

另请参阅

适用于

GetTable(Type)

参数

返回

例外

示例

另请参阅

适用于

GetTable(String)

参数

返回

例外

示例

注解

另请参阅

适用于

其他资源