Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I have written one for my needs that converts a lookup table of your choice to an enum: Put this code inside an <strong>EnumGenerator.ttinclude</strong> file:</p> <pre><code>&lt;#@ template debug="true" hostSpecific="true" #&gt; &lt;#@ output extension=".generated.cs" #&gt; &lt;#@ Assembly Name="System.Data" #&gt; &lt;#@ import namespace="System.Data" #&gt; &lt;#@ import namespace="System.Data.SqlClient" #&gt; &lt;#@ import namespace="System.IO" #&gt; &lt;#@ import namespace="System.Text.RegularExpressions" #&gt; &lt;# string tableName = Path.GetFileNameWithoutExtension(Host.TemplateFile); string path = Path.GetDirectoryName(Host.TemplateFile); string columnId = tableName + "ID"; string columnName = "Name"; string connectionString = "data source=.;initial catalog=DBName;integrated security=SSPI"; #&gt; using System; using System.CodeDom.Compiler; namespace Services.&lt;#= GetSubNamespace() #&gt; { /// &lt;summary&gt; /// &lt;#= tableName #&gt; auto generated enumeration /// &lt;/summary&gt; [GeneratedCode("TextTemplatingFileGenerator", "10")] public enum &lt;#= tableName #&gt; { &lt;# SqlConnection conn = new SqlConnection(connectionString); string command = string.Format("select {0}, {1} from {2} order by {0}", columnId, columnName, tableName); SqlCommand comm = new SqlCommand(command, conn); conn.Open(); SqlDataReader reader = comm.ExecuteReader(); bool loop = reader.Read(); while(loop) { #&gt; /// &lt;summary&gt; /// &lt;#= reader[columnName] #&gt; configuration setting. /// &lt;/summary&gt; &lt;#= Pascalize(reader[columnName]) #&gt; = &lt;#= reader[columnId] #&gt;&lt;# loop = reader.Read(); #&gt;&lt;#= loop ? ",\r\n" : string.Empty #&gt; &lt;# } #&gt; } } &lt;#+ private string Pascalize(object value) { Regex rx = new Regex(@"(?:[^a-zA-Z0-9]*)(?&lt;first&gt;[a-zA-Z0-9])(?&lt;reminder&gt;[a-zA-Z0-9]*)(?:[^a-zA-Z0-9]*)"); return rx.Replace(value.ToString(), m =&gt; m.Groups["first"].ToString().ToUpper() + m.Groups["reminder"].ToString().ToLower()); } private string GetSubNamespace() { Regex rx = new Regex(@"(?:.+Services\s)"); string path = Path.GetDirectoryName(Host.TemplateFile); return rx.Replace(path, string.Empty).Replace("\\", "."); } #&gt; </code></pre> <p>Then whenever you'd like an enum to be generated, just create a <strong>tt</strong> file with the same name as database table like <strong>UserType.tt</strong> and put this code in:</p> <pre><code>&lt;#@ include file="..\..\T4 Templates\EnumGenerator.ttinclude" #&gt; </code></pre> <p>An even more advanced template is now available in my <a href="http://erraticdev.blogspot.com/2011/01/generate-enum-of-database-lookup-table.html" rel="noreferrer">blog post</a>.</p>
    singulars
    1. This table or related slice is empty.
    1. POT4 template to Generate Enums
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USmartin clayton
    1. USRobert Koritnik
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POT4 template to Generate Enums
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThat's slick. I was thinking of doing this myself, but you've saved me the trouble.
      singulars
      1. PO
      1. US3Dave
    2. CO@David Lively: Thanks. I used this on several projects so I thought I should share it with others as well.
      singulars
      1. PO
      1. USRobert Koritnik
    3. COPascalize doesn't seem to remove unwanted characters not in {'a'..'z','A'..'Z','0'..'9'} range such as '\' or '-'. Any chance for a fix for that line?
      singulars
      1. PO
      1. USDanny Varod
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload