Click here to Skip to main content
15,893,588 members
Articles / Desktop Programming / Win32

SQL Class Shell Generator

Rate me:
Please Sign up or sign in to vote.
4.87/5 (65 votes)
8 Jan 2009CPOL6 min read 220K   3.3K   233  
Generate class shells from SQL Server database tables, (SQL 2005 & 2008 only). Output languages supported: C# and VB.NET.
��<HTML><HEAD>

<META NAME="COPYRIGHT" CONTENT="2008 � Paw Jershauge">

<META NAME="DESCRIPTION" CONTENT="This site contains information about the SQLReader  Class Library.">

<META NAME="AUTHOR" CONTENT="Paw Jershauge">

<META NAME="CODING" CONTENT="Paw Jershauge">

<META NAME="DEVELOPER" CONTENT="Paw Jershauge [http://paw.jershauge.dk]">

<META NAME="GENERATOR" CONTENT="Assembly To HTML by Paw Jershauge">

<LINK REL="STYLESHEET" TYPE="TEXT/CSS" HREF="../dat/msdn2.css"></LINK><SCRIPT LANGUAGE="Javascript1.2" SRC="../dat/jscr.js"></SCRIPT>

<TITLE>SQLReader by Paw Jershauge</TITLE></HEAD><BODY CLASS="typeenumeration" onload="wo('SQLReader.ExtendedProperty_Type_toolbar.htm','TOOLBAR')" onunload="wo('../toolbar.htm','TOOLBAR');CurrentObject('...');">

<P CLASS="medium"><IMG SRC="../img/minus.gif" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="midmgR" ID="collapse_expandimg" NAME="collapse_expandimg"><A NAME="collapse_expand" href="#collapse_expand" onclick="plusminustglcontentshowing();tglContent();" CLASS="liketext">Collapse/Expand content</A></P>

SQLReader  Class Library

<H1>ExtendedProperty_Type Enumeration</H1>

<P><B>Namespace:</B> <A HREF="SQLReader.htm">SQLReader</A></P>

<P><B>Assembly:</B> <A HREF="SQLReader(1.0.0.0).htm">SQLReader</A> ( in SQLReader.dll )</P>

<P><B>Basetype(s): </B><A HREF="http://msdn2.microsoft.com/en-us/library/System.Enum.aspx" TARGET="_blank">System.Enum</A></P>

<P><B>Inheritance(s): </B><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">System.Byte</A></P>

<P><A HREF="#" onclick="codetglsync();"><IMG SRC="../objimg/Folder_closed.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="midmgR">Show/Hide Code</A></P>

<H3>In this document the following highlight are available:</H3>

<UL><LI><A HREF="#ANAME_FieldBox">Fields (17)</A></LI><LI><A HREF="#ANAME_EnumItemsBox">Enum items (17)</A></LI><LI><A HREF="#ANAME_SeeAlso_RefBox">See also</A></LI></UL><A NAME="ANAME_EnumItemsBox"></A><H2 CLASS="clk" onclick="plusminustgl('EnumItemsBox');"><IMG SRC="../img/minus.gif" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="midmgR" ID="EnumItemsImg" NAME="EnumItemsBoxImg">Enum Items</H2>

<TABLE CELLPADDING="0" CELLSPACING="0" BORDER="0" WIDTH="100%" ID="EnumItemsBox" NAME="EnumItemsBox"><TR><TD CLASS="tdhead">&nbsp;</TD><TD CLASS="tdhead">Name</TD><TD CLASS="tdhead">Type</TD><TD CLASS="tdhead">Value</TD><TD CLASS="tdhead">Description</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">ASSEMBLY</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">5 <I>(0x00000005)</I></TD><TD CLASS="tditem">Assembly&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">DATABASE</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">0 <I>(0x00000000)</I></TD><TD CLASS="tditem">Database&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">DATABASE_FILE</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">22 <I>(0x00000016)</I></TD><TD CLASS="tditem">Database file&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">DATABASE_PRINCIPAL</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">4 <I>(0x00000004)</I></TD><TD CLASS="tditem">Database principal&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">DATASPACE_FILEGROUP_OR_PARTITION_SCHEME</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">20 <I>(0x00000014)</I></TD><TD CLASS="tditem">Dataspace (filegroup or partition scheme)&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">INDEX</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">7 <I>(0x00000007)</I></TD><TD CLASS="tditem">Index&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">MESSAGE_TYPE</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">15 <I>(0x0000000f)</I></TD><TD CLASS="tditem">Message type&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">OBJECT_OR_COLUMN</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">1 <I>(0x00000001)</I></TD><TD CLASS="tditem">Object or column&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">PARAMETER</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">2 <I>(0x00000002)</I></TD><TD CLASS="tditem">Parameter&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">PARTITION_FUNCTION</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">21 <I>(0x00000015)</I></TD><TD CLASS="tditem">Partition function&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">REMOTE_SERVICE_BINDING</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">18 <I>(0x00000012)</I></TD><TD CLASS="tditem">Remote service binding&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">ROUTE</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">19 <I>(0x00000013)</I></TD><TD CLASS="tditem">Route&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">SCHEMA</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">3 <I>(0x00000003)</I></TD><TD CLASS="tditem">Schema&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">SERVICE</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">17 <I>(0x00000011)</I></TD><TD CLASS="tditem">Service&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">SERVICE_CONTRACT</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">16 <I>(0x00000010)</I></TD><TD CLASS="tditem">Service contract&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">TYPE</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">6 <I>(0x00000006)</I></TD><TD CLASS="tditem">Type&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">XML_SCHEMA_COLLECTION</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">10 <I>(0x0000000a)</I></TD><TD CLASS="tditem">XML schema collection&nbsp;</TD></TR>

</TABLE>

<A NAME="ANAME_FieldBox"></A><H2 CLASS="clk" onclick="plusminustgl('FieldBox');"><IMG SRC="../img/minus.gif" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="midmgR" ID="FieldBoxImg" NAME="FieldBoxImg">Fields</H2>

<TABLE CELLPADDING="0" CELLSPACING="0" BORDER="0" WIDTH="100%" ID="FieldBox" NAME="FieldBox"><TR><TD CLASS="tdhead">&nbsp;</TD><TD CLASS="tdhead">Name</TD><TD CLASS="tdhead">Type</TD><TD CLASS="tdhead">Description</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">ASSEMBLY</TD><TD CLASS="tditem"><A HREF="SQLReader.ExtendedProperty_Type.htm" TARGET="_self">ExtendedProperty_Type</A></TD><TD CLASS="tditem">Assembly&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">DATABASE</TD><TD CLASS="tditem"><A HREF="SQLReader.ExtendedProperty_Type.htm" TARGET="_self">ExtendedProperty_Type</A></TD><TD CLASS="tditem">Database&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">DATABASE_FILE</TD><TD CLASS="tditem"><A HREF="SQLReader.ExtendedProperty_Type.htm" TARGET="_self">ExtendedProperty_Type</A></TD><TD CLASS="tditem">Database file&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">DATABASE_PRINCIPAL</TD><TD CLASS="tditem"><A HREF="SQLReader.ExtendedProperty_Type.htm" TARGET="_self">ExtendedProperty_Type</A></TD><TD CLASS="tditem">Database principal&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">DATASPACE_FILEGROUP_OR_PARTITION_SCHEME</TD><TD CLASS="tditem"><A HREF="SQLReader.ExtendedProperty_Type.htm" TARGET="_self">ExtendedProperty_Type</A></TD><TD CLASS="tditem">Dataspace (filegroup or partition scheme)&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">INDEX</TD><TD CLASS="tditem"><A HREF="SQLReader.ExtendedProperty_Type.htm" TARGET="_self">ExtendedProperty_Type</A></TD><TD CLASS="tditem">Index&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">MESSAGE_TYPE</TD><TD CLASS="tditem"><A HREF="SQLReader.ExtendedProperty_Type.htm" TARGET="_self">ExtendedProperty_Type</A></TD><TD CLASS="tditem">Message type&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">OBJECT_OR_COLUMN</TD><TD CLASS="tditem"><A HREF="SQLReader.ExtendedProperty_Type.htm" TARGET="_self">ExtendedProperty_Type</A></TD><TD CLASS="tditem">Object or column&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">PARAMETER</TD><TD CLASS="tditem"><A HREF="SQLReader.ExtendedProperty_Type.htm" TARGET="_self">ExtendedProperty_Type</A></TD><TD CLASS="tditem">Parameter&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">PARTITION_FUNCTION</TD><TD CLASS="tditem"><A HREF="SQLReader.ExtendedProperty_Type.htm" TARGET="_self">ExtendedProperty_Type</A></TD><TD CLASS="tditem">Partition function&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">REMOTE_SERVICE_BINDING</TD><TD CLASS="tditem"><A HREF="SQLReader.ExtendedProperty_Type.htm" TARGET="_self">ExtendedProperty_Type</A></TD><TD CLASS="tditem">Remote service binding&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">ROUTE</TD><TD CLASS="tditem"><A HREF="SQLReader.ExtendedProperty_Type.htm" TARGET="_self">ExtendedProperty_Type</A></TD><TD CLASS="tditem">Route&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">SCHEMA</TD><TD CLASS="tditem"><A HREF="SQLReader.ExtendedProperty_Type.htm" TARGET="_self">ExtendedProperty_Type</A></TD><TD CLASS="tditem">Schema&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">SERVICE</TD><TD CLASS="tditem"><A HREF="SQLReader.ExtendedProperty_Type.htm" TARGET="_self">ExtendedProperty_Type</A></TD><TD CLASS="tditem">Service&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">SERVICE_CONTRACT</TD><TD CLASS="tditem"><A HREF="SQLReader.ExtendedProperty_Type.htm" TARGET="_self">ExtendedProperty_Type</A></TD><TD CLASS="tditem">Service contract&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">TYPE</TD><TD CLASS="tditem"><A HREF="SQLReader.ExtendedProperty_Type.htm" TARGET="_self">ExtendedProperty_Type</A></TD><TD CLASS="tditem">Type&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">XML_SCHEMA_COLLECTION</TD><TD CLASS="tditem"><A HREF="SQLReader.ExtendedProperty_Type.htm" TARGET="_self">ExtendedProperty_Type</A></TD><TD CLASS="tditem">XML schema collection&nbsp;</TD></TR>

</TABLE>

<H2>CodeDom of ExtendedProperty_Type Enumeration</H2>

<BR>

<IMG SRC="../objimg/Folder_closed.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="midmgR" ID="cscodeimg" NAME="cscodeimg"><A NAME="bookcscode" href="#bookcscode" onclick="codetgl('cscode');" CLASS="codetoggle">C# (CSharp) code</a>

<DIV NAME="cscode" ID="cscode" STYLE="display:none;">

<PRE CLASS="code">

<FONT COLOR="darkgreen">//C# (CSharp)</FONT>

public enum ExtendedProperty_Type : byte {

    

    // Hex value is: 00000000

    [Description("Database")]

    DATABASE = 0,

    

    // Hex value is: 00000001

    [Description("Object or column")]

    OBJECT_OR_COLUMN = 1,

    

    // Hex value is: 00000002

    [Description("Parameter")]

    PARAMETER = 2,

    

    // Hex value is: 00000003

    [Description("Schema")]

    SCHEMA = 3,

    

    // Hex value is: 00000004

    [Description("Database principal")]

    DATABASE_PRINCIPAL = 4,

    

    // Hex value is: 00000005

    [Description("Assembly")]

    ASSEMBLY = 5,

    

    // Hex value is: 00000006

    [Description("Type")]

    TYPE = 6,

    

    // Hex value is: 00000007

    [Description("Index")]

    INDEX = 7,

    

    // Hex value is: 0000000a

    [Description("XML schema collection")]

    XML_SCHEMA_COLLECTION = 10,

    

    // Hex value is: 0000000f

    [Description("Message type")]

    MESSAGE_TYPE = 15,

    

    // Hex value is: 00000010

    [Description("Service contract")]

    SERVICE_CONTRACT = 16,

    

    // Hex value is: 00000011

    [Description("Service")]

    SERVICE = 17,

    

    // Hex value is: 00000012

    [Description("Remote service binding")]

    REMOTE_SERVICE_BINDING = 18,

    

    // Hex value is: 00000013

    [Description("Route")]

    ROUTE = 19,

    

    // Hex value is: 00000014

    [Description("Dataspace (filegroup or partition scheme)")]

    DATASPACE_FILEGROUP_OR_PARTITION_SCHEME = 20,

    

    // Hex value is: 00000015

    [Description("Partition function")]

    PARTITION_FUNCTION = 21,

    

    // Hex value is: 00000016

    [Description("Database file")]

    DATABASE_FILE = 22,

}

</PRE>

</DIV>

<BR><BR>

<IMG SRC="../objimg/Folder_closed.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="midmgR" ID="vbcodeimg" NAME="vbcodeimg"><A NAME="bookvbcode" href="#bookvbcode" onclick="codetgl('vbcode');" CLASS="codetoggle">VB (Visual Basic) code</a>

<DIV NAME="vbcode" ID="vbcode" STYLE="display:none;">

<PRE CLASS="code">

<FONT COLOR="darkgreen">'VB (Visual Basic)</FONT>

Public Enum ExtendedProperty_Type As Byte

    

    'Hex value is: 00000000

    &lt;Description("Database")&gt;  _

    DATABASE = 0

    

    'Hex value is: 00000001

    &lt;Description("Object or column")&gt;  _

    OBJECT_OR_COLUMN = 1

    

    'Hex value is: 00000002

    &lt;Description("Parameter")&gt;  _

    PARAMETER = 2

    

    'Hex value is: 00000003

    &lt;Description("Schema")&gt;  _

    SCHEMA = 3

    

    'Hex value is: 00000004

    &lt;Description("Database principal")&gt;  _

    DATABASE_PRINCIPAL = 4

    

    'Hex value is: 00000005

    &lt;Description("Assembly")&gt;  _

    [ASSEMBLY] = 5

    

    'Hex value is: 00000006

    &lt;Description("Type")&gt;  _

    TYPE = 6

    

    'Hex value is: 00000007

    &lt;Description("Index")&gt;  _

    INDEX = 7

    

    'Hex value is: 0000000a

    &lt;Description("XML schema collection")&gt;  _

    XML_SCHEMA_COLLECTION = 10

    

    'Hex value is: 0000000f

    &lt;Description("Message type")&gt;  _

    MESSAGE_TYPE = 15

    

    'Hex value is: 00000010

    &lt;Description("Service contract")&gt;  _

    SERVICE_CONTRACT = 16

    

    'Hex value is: 00000011

    &lt;Description("Service")&gt;  _

    SERVICE = 17

    

    'Hex value is: 00000012

    &lt;Description("Remote service binding")&gt;  _

    REMOTE_SERVICE_BINDING = 18

    

    'Hex value is: 00000013

    &lt;Description("Route")&gt;  _

    ROUTE = 19

    

    'Hex value is: 00000014

    &lt;Description("Dataspace (filegroup or partition scheme)")&gt;  _

    DATASPACE_FILEGROUP_OR_PARTITION_SCHEME = 20

    

    'Hex value is: 00000015

    &lt;Description("Partition function")&gt;  _

    PARTITION_FUNCTION = 21

    

    'Hex value is: 00000016

    &lt;Description("Database file")&gt;  _

    DATABASE_FILE = 22

End Enum

</PRE>

</DIV>

<BR><BR>

<IMG SRC="../objimg/Folder_closed.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="midmgR" ID="vjscodeimg" NAME="vjscodeimg"><A NAME="bookvjscode" href="#bookvjscode" onclick="codetgl('vjscode');" CLASS="codetoggle">VJ (Visual JSharp) code</a>

<DIV NAME="vjscode" ID="vjscode" STYLE="display:none;">

<PRE CLASS="code">

<FONT COLOR="darkgreen">//J# (Visual J#)</FONT>

public enum ExtendedProperty_Type {

    

    // Hex value is: 00000000

    /** @attribute Description("Database")*/

    DATABASE(0),

    

    // Hex value is: 00000001

    /** @attribute Description("Object or column")*/

    OBJECT_OR_COLUMN(1),

    

    // Hex value is: 00000002

    /** @attribute Description("Parameter")*/

    PARAMETER(2),

    

    // Hex value is: 00000003

    /** @attribute Description("Schema")*/

    SCHEMA(3),

    

    // Hex value is: 00000004

    /** @attribute Description("Database principal")*/

    DATABASE_PRINCIPAL(4),

    

    // Hex value is: 00000005

    /** @attribute Description("Assembly")*/

    ASSEMBLY(5),

    

    // Hex value is: 00000006

    /** @attribute Description("Type")*/

    TYPE(6),

    

    // Hex value is: 00000007

    /** @attribute Description("Index")*/

    INDEX(7),

    

    // Hex value is: 0000000a

    /** @attribute Description("XML schema collection")*/

    XML_SCHEMA_COLLECTION(10),

    

    // Hex value is: 0000000f

    /** @attribute Description("Message type")*/

    MESSAGE_TYPE(15),

    

    // Hex value is: 00000010

    /** @attribute Description("Service contract")*/

    SERVICE_CONTRACT(16),

    

    // Hex value is: 00000011

    /** @attribute Description("Service")*/

    SERVICE(17),

    

    // Hex value is: 00000012

    /** @attribute Description("Remote service binding")*/

    REMOTE_SERVICE_BINDING(18),

    

    // Hex value is: 00000013

    /** @attribute Description("Route")*/

    ROUTE(19),

    

    // Hex value is: 00000014

    /** @attribute Description("Dataspace (filegroup or partition scheme)")*/

    DATASPACE_FILEGROUP_OR_PARTITION_SCHEME(20),

    

    // Hex value is: 00000015

    /** @attribute Description("Partition function")*/

    PARTITION_FUNCTION(21),

    

    // Hex value is: 00000016

    /** @attribute Description("Database file")*/

    DATABASE_FILE(22)

}

</PRE>

</DIV>

<BR><BR>

<IMG SRC="../objimg/Folder_closed.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="midmgR" ID="vccodeimg" NAME="vccodeimg"><A NAME="bookvccode" href="#bookvccode" onclick="codetgl('vccode');" CLASS="codetoggle">VC (Visual C) code</a>

<DIV NAME="vccode" ID="vccode" STYLE="display:none;">

<PRE CLASS="code">

<FONT COLOR="darkgreen">//VC (Visual C)</FONT>

public enum class ExtendedProperty_Type sealed : System::Byte {

    

    // Hex value is: 00000000

    [Description(L"Database")]

    DATABASE = 0,

    

    // Hex value is: 00000001

    [Description(L"Object or column")]

    OBJECT_OR_COLUMN = 1,

    

    // Hex value is: 00000002

    [Description(L"Parameter")]

    PARAMETER = 2,

    

    // Hex value is: 00000003

    [Description(L"Schema")]

    SCHEMA = 3,

    

    // Hex value is: 00000004

    [Description(L"Database principal")]

    DATABASE_PRINCIPAL = 4,

    

    // Hex value is: 00000005

    [Description(L"Assembly")]

    ASSEMBLY = 5,

    

    // Hex value is: 00000006

    [Description(L"Type")]

    TYPE = 6,

    

    // Hex value is: 00000007

    [Description(L"Index")]

    INDEX = 7,

    

    // Hex value is: 0000000a

    [Description(L"XML schema collection")]

    XML_SCHEMA_COLLECTION = 10,

    

    // Hex value is: 0000000f

    [Description(L"Message type")]

    MESSAGE_TYPE = 15,

    

    // Hex value is: 00000010

    [Description(L"Service contract")]

    SERVICE_CONTRACT = 16,

    

    // Hex value is: 00000011

    [Description(L"Service")]

    SERVICE = 17,

    

    // Hex value is: 00000012

    [Description(L"Remote service binding")]

    REMOTE_SERVICE_BINDING = 18,

    

    // Hex value is: 00000013

    [Description(L"Route")]

    ROUTE = 19,

    

    // Hex value is: 00000014

    [Description(L"Dataspace (filegroup or partition scheme)")]

    DATASPACE_FILEGROUP_OR_PARTITION_SCHEME = 20,

    

    // Hex value is: 00000015

    [Description(L"Partition function")]

    PARTITION_FUNCTION = 21,

    

    // Hex value is: 00000016

    [Description(L"Database file")]

    DATABASE_FILE = 22,

};

</PRE>

</DIV>

<H2 CLASS="clk" onclick="plusminustgl('SeeAlso_RefBox');"><IMG SRC="../img/minus.gif" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="midmgR" ID="SeeAlso_RefBoxImg" NAME="SeeAlso_RefBoxImg">See Also:</H2>

<A NAME="ANAME_SeeAlso_RefBox"></A><DIV ID="SeeAlso_RefBox" NAME="SeeAlso_RefBox">

&bull; <A HREF="http://msdn2.microsoft.com/en-us/library/System.Enum.aspx" TARGET="_blank">System.Enum</A>

&bull; <A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">System.Byte</A>



</DIV>

<SCRIPT LANGUAGE="Javascript1.2">

parent.MENU.ShDiv('SQLReader(1.0.0.0)_Assembly');

parent.MENU.ShDiv('SQLReader.SQLReader_Namespace');

parent.MENU.ShDiv('SQLReader.SQLReader_Enumeration');

parent.MENU.location=parent.MENU.location + '#SQLReader_SQLReader.ExtendedProperty_Type';

CopyRight('Copyright � Paw Jershauge 2008');

CurrentObject('ExtendedProperty_Type Enumeration');

</SCRIPT>

</BODY></HTML>

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Software Developer
Denmark Denmark

Comments and Discussions