Click here to Skip to main content
15,881,746 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 218K   3.3K   233  
Generate class shells from SQL Server database tables, (SQL 2005 & 2008 only). Output languages supported: C# and VB.NET.
Public Enum Snapshot_Isolation_State As 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 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
    <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
End Enum

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