Click here to Skip to main content
15,886,578 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 218.4K   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.Index_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>Index_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 (4)</A></LI><LI><A HREF="#ANAME_EnumItemsBox">Enum items (4)</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">Clustered</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">Clustered&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">Heap</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">Heap&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">Nonclustered</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">Nonclustered&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</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">8 <I>(0x00000008)</I></TD><TD CLASS="tditem">XML&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">Clustered</TD><TD CLASS="tditem"><A HREF="SQLReader.Index_type.htm" TARGET="_self">Index_type</A></TD><TD CLASS="tditem">Clustered&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">Heap</TD><TD CLASS="tditem"><A HREF="SQLReader.Index_type.htm" TARGET="_self">Index_type</A></TD><TD CLASS="tditem">Heap&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">Nonclustered</TD><TD CLASS="tditem"><A HREF="SQLReader.Index_type.htm" TARGET="_self">Index_type</A></TD><TD CLASS="tditem">Nonclustered&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</TD><TD CLASS="tditem"><A HREF="SQLReader.Index_type.htm" TARGET="_self">Index_type</A></TD><TD CLASS="tditem">XML&nbsp;</TD></TR>

</TABLE>

<H2>CodeDom of Index_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 Index_type : byte {

    

    // Hex value is: 00000001

    [Description("Heap")]

    Heap = 1,

    

    // Hex value is: 00000002

    [Description("Clustered")]

    Clustered = 2,

    

    // Hex value is: 00000004

    [Description("Nonclustered")]

    Nonclustered = 4,

    

    // Hex value is: 00000008

    [Description("XML")]

    XML = 8,

}

</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 Index_type As Byte

    

    'Hex value is: 00000001

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

    Heap = 1

    

    'Hex value is: 00000002

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

    Clustered = 2

    

    'Hex value is: 00000004

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

    Nonclustered = 4

    

    'Hex value is: 00000008

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

    XML = 8

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 Index_type {

    

    // Hex value is: 00000001

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

    Heap(1),

    

    // Hex value is: 00000002

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

    Clustered(2),

    

    // Hex value is: 00000004

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

    Nonclustered(4),

    

    // Hex value is: 00000008

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

    XML(8)

}

</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 Index_type sealed : System::Byte {

    

    // Hex value is: 00000001

    [Description(L"Heap")]

    Heap = 1,

    

    // Hex value is: 00000002

    [Description(L"Clustered")]

    Clustered = 2,

    

    // Hex value is: 00000004

    [Description(L"Nonclustered")]

    Nonclustered = 4,

    

    // Hex value is: 00000008

    [Description(L"XML")]

    XML = 8,

};

</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.Index_type';

CopyRight('Copyright � Paw Jershauge 2008');

CurrentObject('Index_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