Returns a SQL-DDL statement for adding a column to a table.

Namespace:  Huagati.DBMLTools.Runtime
Assembly:  HuagatiDBMLToolsRTE (in HuagatiDBMLToolsRTE.dll) Version: 1.66.3362.23798

Syntax

C#
public static string AddColumnStatement(
	this MetaDataMember member
)
Visual Basic (Declaration)
<ExtensionAttribute> _
Public Shared Function AddColumnStatement ( _
	member As MetaDataMember _
) As String
Visual C++
[ExtensionAttribute]
public:
static String^ AddColumnStatement(
	MetaDataMember^ member
)

Parameters

member
Type: System.Data.Linq.Mapping..::.MetaDataMember
Linq-to-SQL MetaDataMember representing the column to generate 'alter table ... add column' statement for.

Return Value

A SQL-DDL statement for adding a column corresponding to the metadatamember in the database.

Examples

This example shows how to generate SQL-DDL for adding missing columns.
CopyC#
using Huagati.DBMLTools.Runtime;

public class MappingSample
{
    public void Test()
    {
        SomeDataContext dc = new SomeDataContext();

        //iterate through the collection of tables defined in the datacontext
        foreach (System.Data.Linq.Mapping.MetaTable table in dc.Mapping.GetTables())
        {
            //iterate through the members
            foreach (System.Data.Linq.Mapping.MetaDataMember member in table.RowType.DataMembers)
            {
                //only check non-association persistent members
                if (!member.IsAssociation && member.IsPersistent)
                {
                    if (!member.ExistsInDB(dc.Connection))
                    {
                        string addColumn = member.AddColumnStatement();
                    }
                }
            }
        }
    }
}

See Also