Click here to Skip to main content
15,894,540 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 220.2K   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="typeclass" 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>SQL_Type Public Class</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="SQLReader.AbstractSQLObject.htm" TARGET="_self">SQLReader.AbstractSQLObject</A></P>

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

<UL><LI><A HREF="#ANAME_PropertyBox">Properties (22)</A></LI><LI><A HREF="#ANAME_SeeAlso_RefBox">See also</A></LI></UL><A NAME="ANAME_PropertyBox"></A><H2 CLASS="clk" onclick="plusminustgl('PropertyBox');"><IMG SRC="../img/minus.gif" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="midmgR" ID="PropertyBoxImg" NAME="PropertyBoxImg">Properties</H2>

<TABLE CELLPADDING="0" CELLSPACING="0" BORDER="0" WIDTH="100%" ID="PropertyBox" NAME="PropertyBox"><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/Properties.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Public Property"></TD><TD CLASS="tditem" nowrap>collation_name</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.String.aspx" TARGET="_blank" CLASS="aRef">String</A></TD><TD CLASS="tditem">Name of the collation of the type if it is character-based; other wise, NULL&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/Properties.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Public Property"></TD><TD CLASS="tditem" nowrap>default_object_id</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Int32.aspx" TARGET="_blank" CLASS="aRef">Int32</A></TD><TD CLASS="tditem">ID of the stand-alone default that is bound to the type by using sp_bindefault [ http://msdn2.microsoft.com/en-us/library/ms177503(printer).aspx ] .
0 = No default exists&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/Properties.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Public Property"></TD><TD CLASS="tditem" nowrap>Description</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.String.aspx" TARGET="_blank" CLASS="aRef">String</A></TD><TD CLASS="tditem">Description for the type&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/Properties.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Public Property"></TD><TD CLASS="tditem" nowrap>ExtProperties</TD><TD CLASS="tditem"><A HREF="SQLReader.ExtendedProperty.htm" TARGET="_self" CLASS="aRef">ExtendedProperty[]</A></TD><TD CLASS="tditem">&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/Properties.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Public Property"></TD><TD CLASS="tditem" nowrap>is_assembly_type</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Boolean.aspx" TARGET="_blank" CLASS="aRef">Boolean</A></TD><TD CLASS="tditem">1 = Implementation of the type is defined in a CLR assembly.
0 = Type is based on a SQL Server system data type&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/Properties.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Public Property"></TD><TD CLASS="tditem" nowrap>is_nullable</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Boolean.aspx" TARGET="_blank" CLASS="aRef">Boolean</A></TD><TD CLASS="tditem">Type is nullable&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/Properties.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Public Property"></TD><TD CLASS="tditem" nowrap>is_user_defined</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Boolean.aspx" TARGET="_blank" CLASS="aRef">Boolean</A></TD><TD CLASS="tditem">1 = User-defined type.
0 = SQL Server 2005 system data type&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/Properties.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Public Property"></TD><TD CLASS="tditem" nowrap>max_length</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Int16.aspx" TARGET="_blank" CLASS="aRef">Int16</A></TD><TD CLASS="tditem">Maximum Length (in bytes) of the type.
-1 = Column data type is varchar(max), nvarchar(max), varbinary(max), or xml.
For text columns, the max_length value will be 16&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/Properties.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Public Property"></TD><TD CLASS="tditem" nowrap>name</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.String.aspx" TARGET="_blank" CLASS="aRef">String</A></TD><TD CLASS="tditem">Name of the type. Is unique within the schema&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/Properties.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Public Property"></TD><TD CLASS="tditem" nowrap>NetType</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Type.aspx" TARGET="_blank" CLASS="aRef">Type</A></TD><TD CLASS="tditem">&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/Properties.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Public Virtual Property"></TD><TD CLASS="tditem" nowrap>ObjectName</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.String.aspx" TARGET="_blank" CLASS="aRef">String</A></TD><TD CLASS="tditem">&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/Properties.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Public Property"></TD><TD CLASS="tditem" nowrap>Owner</TD><TD CLASS="tditem"><A HREF="SQLReader.SQL_Types.htm" TARGET="_self" CLASS="aRef">SQL_Types</A></TD><TD CLASS="tditem">&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/Properties.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Public Property"></TD><TD CLASS="tditem" nowrap>precision</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank" CLASS="aRef">Byte</A></TD><TD CLASS="tditem">Max precision of the type if it is numeric-based; otherwise, 0&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/Properties.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Public Property"></TD><TD CLASS="tditem" nowrap>principal_id</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Int32.aspx" TARGET="_blank" CLASS="aRef">Int32</A></TD><TD CLASS="tditem">ID of the individual owner if different from schema owner. By default, schema-contained objects are owned by the schema owner. However, an alternate owner can be specified by using the ALTER AUTHORIZATION statement to change ownership.
NULL if there is no alternate individual owner&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/Properties.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Public Property"></TD><TD CLASS="tditem" nowrap>rule_object_id</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Int32.aspx" TARGET="_blank" CLASS="aRef">Int32</A></TD><TD CLASS="tditem">ID of the stand-alone rule that is bound to the type by using sp_bindrule [ http://msdn2.microsoft.com/en-us/library/ms176063(printer).aspx ] .
0 = No rule exists&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/Properties.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Public Property"></TD><TD CLASS="tditem" nowrap>scale</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank" CLASS="aRef">Byte</A></TD><TD CLASS="tditem">Max scale of the type if it is numeric-based; otherwise, 0&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/Properties.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Public Property"></TD><TD CLASS="tditem" nowrap>Schema</TD><TD CLASS="tditem"><A HREF="SQLReader.Schema.htm" TARGET="_self" CLASS="aRef">Schema</A></TD><TD CLASS="tditem">&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/Properties.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Public Property"></TD><TD CLASS="tditem" nowrap>schema_id</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Int32.aspx" TARGET="_blank" CLASS="aRef">Int32</A></TD><TD CLASS="tditem">ID of the schema to which the type belongs&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/Properties.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Public Property"></TD><TD CLASS="tditem" nowrap>system_type</TD><TD CLASS="tditem"><A HREF="SQLReader.SQL_Type.htm" TARGET="_self" CLASS="aRef">SQL_Type</A></TD><TD CLASS="tditem">&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/Properties.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Public Property"></TD><TD CLASS="tditem" nowrap>system_type_id</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank" CLASS="aRef">Byte</A></TD><TD CLASS="tditem">ID of the internal system-type of the type&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/Properties.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Public Virtual Property"></TD><TD CLASS="tditem" nowrap>UniqueObjectName</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.String.aspx" TARGET="_blank" CLASS="aRef">String</A></TD><TD CLASS="tditem">&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/Properties.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Public Property"></TD><TD CLASS="tditem" nowrap>user_type_id</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Int32.aspx" TARGET="_blank" CLASS="aRef">Int32</A></TD><TD CLASS="tditem">ID of the type. Is unique within the database. For system data types, user_type_id = system_type_id&nbsp;</TD></TR>

</TABLE>

<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="SQLReader.AbstractSQLObject.htm" TARGET="_self">SQLReader.AbstractSQLObject</A>

<SPAN>&bull; <A HREF="SQLReader.Schema.htm" TARGET="_self">Schema</A></SPAN>&nbsp;&nbsp;

<SPAN>&bull; <A HREF="SQLReader.SQL_Type.htm" TARGET="_self">SQL_Type</A></SPAN>&nbsp;&nbsp;

<SPAN>&bull; <A HREF="SQLReader.SQL_Types.htm" TARGET="_self">SQL_Types</A></SPAN>&nbsp;&nbsp;

<SPAN>&bull; <A HREF="SQLReader.ExtendedProperty.htm" TARGET="_self">ExtendedProperty[]</A></SPAN>&nbsp;&nbsp;



</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_Class');

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

CopyRight('Copyright � Paw Jershauge 2008');

CurrentObject('SQL_Type Class');

</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