Click here to Skip to main content
15,886,519 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.Update_Referential_Action_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>Update_Referential_Action 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">CASCADE</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">&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">NO_ACTION</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">&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">SET_DEFAULT</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">&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">SET_NULL</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">&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">CASCADE</TD><TD CLASS="tditem"><A HREF="SQLReader.Update_Referential_Action.htm" TARGET="_self">Update_Referential_Action</A></TD><TD CLASS="tditem">&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">NO_ACTION</TD><TD CLASS="tditem"><A HREF="SQLReader.Update_Referential_Action.htm" TARGET="_self">Update_Referential_Action</A></TD><TD CLASS="tditem">&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">SET_DEFAULT</TD><TD CLASS="tditem"><A HREF="SQLReader.Update_Referential_Action.htm" TARGET="_self">Update_Referential_Action</A></TD><TD CLASS="tditem">&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">SET_NULL</TD><TD CLASS="tditem"><A HREF="SQLReader.Update_Referential_Action.htm" TARGET="_self">Update_Referential_Action</A></TD><TD CLASS="tditem">&nbsp;</TD></TR>

</TABLE>

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

    

    // Hex value is: 00000000

    NO_ACTION = 0,

    

    // Hex value is: 00000001

    CASCADE = 1,

    

    // Hex value is: 00000002

    SET_NULL = 2,

    

    // Hex value is: 00000003

    SET_DEFAULT = 3,

}

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

    

    'Hex value is: 00000000

    NO_ACTION = 0

    

    'Hex value is: 00000001

    CASCADE = 1

    

    'Hex value is: 00000002

    SET_NULL = 2

    

    'Hex value is: 00000003

    SET_DEFAULT = 3

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

    

    // Hex value is: 00000000

    NO_ACTION(0),

    

    // Hex value is: 00000001

    CASCADE(1),

    

    // Hex value is: 00000002

    SET_NULL(2),

    

    // Hex value is: 00000003

    SET_DEFAULT(3)

}

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

    

    // Hex value is: 00000000

    NO_ACTION = 0,

    

    // Hex value is: 00000001

    CASCADE = 1,

    

    // Hex value is: 00000002

    SET_NULL = 2,

    

    // Hex value is: 00000003

    SET_DEFAULT = 3,

};

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

CopyRight('Copyright � Paw Jershauge 2008');

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