Click here to Skip to main content
15,896,063 members
Search within:


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 220.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.Snapshot_Isolation_State_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>Snapshot_Isolation_State 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">IN_TRANSITION_TO_OFF</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">Snapshot isolation state is in transition to ON state. New transactions have their modifications versioned. Transactions cannot use snapshot isolation until the snapshot isolation state becomes 1 (ON). The database remains in the transition to ON state until all update transactions that were active when ALTER DATABASE was run can be completed.&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">IN_TRANSITION_TO_ON</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">Snapshot isolation state is in transition to OFF state. All transactions have their modifications versioned. Cannot start new transactions using snapshot isolation. The database remains in the transition to OFF state until all transactions that were active when ALTER DATABASE was run can be completed.&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">OFF</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">Snapshot isolation state is OFF (default). Snapshot isolation is disallowed.&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">ON</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">Snapshot isolation state ON. Snapshot isolation is allowed.&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">IN_TRANSITION_TO_OFF</TD><TD CLASS="tditem"><A HREF="SQLReader.Snapshot_Isolation_State.htm" TARGET="_self">Snapshot_Isolation_State</A></TD><TD CLASS="tditem">Snapshot isolation state is in transition to ON state. New transactions have their modifications versioned. Transactions cannot use snapshot isolation until the snapshot isolation state becomes 1 (ON). The database remains in the transition to ON state until all update transactions that were active when ALTER DATABASE was run can be completed.&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">IN_TRANSITION_TO_ON</TD><TD CLASS="tditem"><A HREF="SQLReader.Snapshot_Isolation_State.htm" TARGET="_self">Snapshot_Isolation_State</A></TD><TD CLASS="tditem">Snapshot isolation state is in transition to OFF state. All transactions have their modifications versioned. Cannot start new transactions using snapshot isolation. The database remains in the transition to OFF state until all transactions that were active when ALTER DATABASE was run can be completed.&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">OFF</TD><TD CLASS="tditem"><A HREF="SQLReader.Snapshot_Isolation_State.htm" TARGET="_self">Snapshot_Isolation_State</A></TD><TD CLASS="tditem">Snapshot isolation state is OFF (default). Snapshot isolation is disallowed.&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">ON</TD><TD CLASS="tditem"><A HREF="SQLReader.Snapshot_Isolation_State.htm" TARGET="_self">Snapshot_Isolation_State</A></TD><TD CLASS="tditem">Snapshot isolation state ON. Snapshot isolation is allowed.&nbsp;</TD></TR>

</TABLE>

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

    

    // Hex value is: 00000000

    [Description("Snapshot isolation state is OFF (default). Snapshot isolation is disallowed.")]

    OFF = 0,

    

    // Hex value is: 00000001

    [Description("Snapshot isolation state ON. Snapshot isolation is allowed.")]

    ON = 1,

    

    // Hex value is: 00000002

    [Description(@"Snapshot isolation state is in transition to OFF state. All transactions have their modifications versioned. Cannot start new transactions using snapshot isolation. The database remains in the transition to OFF state until all transactions that were active when ALTER DATABASE was run can be completed.")]

    IN_TRANSITION_TO_ON = 2,

    

    // Hex value is: 00000003

    [Description(@"Snapshot isolation state is in transition to ON state. New transactions have their modifications versioned. Transactions cannot use snapshot isolation until the snapshot isolation state becomes 1 (ON). The database remains in the transition to ON state until all update transactions that were active when ALTER DATABASE was run can be completed.")]

    IN_TRANSITION_TO_OFF = 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 Snapshot_Isolation_State As Byte

    

    'Hex value is: 00000000

    &lt;Description("Snapshot isolation state is OFF (default). Snapshot isolation is disallowed.")&gt;  _

    OFF = 0

    

    'Hex value is: 00000001

    &lt;Description("Snapshot isolation state ON. Snapshot isolation is allowed.")&gt;  _

    [ON] = 1

    

    'Hex value is: 00000002

    &lt;Description("Snapshot isolation state is in transition to OFF state. All transactions have the"& _ 

        "ir modifications versioned. Cannot start new transactions using snapshot isolati"& _ 

        "on. The database remains in the transition to OFF state until all transactions t"& _ 

        "hat were active when ALTER DATABASE was run can be completed.")&gt;  _

    IN_TRANSITION_TO_ON = 2

    

    'Hex value is: 00000003

    &lt;Description("Snapshot isolation state is in transition to ON state. New transactions have thei"& _ 

        "r modifications versioned. Transactions cannot use snapshot isolation until the "& _ 

        "snapshot isolation state becomes 1 (ON). The database remains in the transition "& _ 

        "to ON state until all update transactions that were active when ALTER DATABASE w"& _ 

        "as run can be completed.")&gt;  _

    IN_TRANSITION_TO_OFF = 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 Snapshot_Isolation_State {

    

    // Hex value is: 00000000

    /** @attribute Description("Snapshot isolation state is OFF (default). Snapshot isolation is disallowed.")*/

    OFF(0),

    

    // Hex value is: 00000001

    /** @attribute Description("Snapshot isolation state ON. Snapshot isolation is allowed.")*/

    ON(1),

    

    // Hex value is: 00000002

    /** @attribute Description("Snapshot isolation state is in transition to OFF state. All transactions have the" +

"ir modifications versioned. Cannot start new transactions using snapshot isolati" +

"on. The database remains in the transition to OFF state until all transactions t" +

"hat were active when ALTER DATABASE was run can be completed.")*/

    IN_TRANSITION_TO_ON(2),

    

    // Hex value is: 00000003

    /** @attribute Description("Snapshot isolation state is in transition to ON state. New transactions have thei" +

"r modifications versioned. Transactions cannot use snapshot isolation until the " +

"snapshot isolation state becomes 1 (ON). The database remains in the transition " +

"to ON state until all update transactions that were active when ALTER DATABASE w" +

"as run can be completed.")*/

    IN_TRANSITION_TO_OFF(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 Snapshot_Isolation_State sealed : System::Byte {

    

    // Hex value is: 00000000

    [Description(L"Snapshot isolation state is OFF (default). Snapshot isolation is disallowed.")]

    OFF = 0,

    

    // Hex value is: 00000001

    [Description(L"Snapshot isolation state ON. Snapshot isolation is allowed.")]

    ON = 1,

    

    // Hex value is: 00000002

    [Description(L"Snapshot isolation state is in transition to OFF state. All transactions have the" 

L"ir modifications versioned. Cannot start new transactions using snapshot isolati" 

L"on. The database remains in the transition to OFF state until all transactions t" 

L"hat were active when ALTER DATABASE was run can be completed.")]

    IN_TRANSITION_TO_ON = 2,

    

    // Hex value is: 00000003

    [Description(L"Snapshot isolation state is in transition to ON state. New transactions have thei" 

L"r modifications versioned. Transactions cannot use snapshot isolation until the " 

L"snapshot isolation state becomes 1 (ON). The database remains in the transition " 

L"to ON state until all update transactions that were active when ALTER DATABASE w" 

L"as run can be completed.")]

    IN_TRANSITION_TO_OFF = 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.Snapshot_Isolation_State';

CopyRight('Copyright � Paw Jershauge 2008');

CurrentObject('Snapshot_Isolation_State 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
Paw Jershauge
Software Developer
Denmark Denmark
blog: C# And I
About.me Paw Jershauge
ListView Group Sorter
An Code Generator, for making SQL table into .Net Classses (2nd place in the Code Generation 2008 Competition)
A Class for getting the Rss feed list of a website
Seagate Date Code Calculator
DNSBL lookup Class
Base N converter (N = 10-62)
Lightweight Directory Access Protocol Uniform resource identifier (LDAPUri)
LoginHours from DirectoryEntry into boolean array

Comments and Discussions

Permalink
Advertise
Privacy
Cookies
Terms of Use
Layout: fixed | fluid

Posted 16 Jul 2008

Article Copyright 2008 by Paw Jershauge
Everything else Copyright © CodeProject, 1999-2024

Web01 2.8:2024-04-02:1