title: Build C# dll from SQL table
body: <p>I have a SQL-table with three columns: Id, English and Norwegian. Id is the primary key. In my application I have a flag (EN/NO) to decide which language to use for labels, buttons ++ in the GUI.
  The application is now doing a select * everytime the application loads, and the application is looking up all required values at runtime. But instead of loading the whole dataset for every instance, i want to export these values and create a dll so i can store these values locally. </p>
  
  <p>Is there any possibility of creating this in-code so the dll will renew itself with every build? Or do I have to run some external program to dynamically create ex. a .cs code to copy/paste into my class? (I need to be able to re-run the process because rows will be added every time there is a need for a new label/text)</p>
  
  <p>I have so far thought out three solutions on how to structure my export, but no clue on how to export the data:</p>
  
  <ol>
  <li><p>Preserve the state of the DataTable in a static context and provide help-methods to standardize the way of getting the values out.</p></li>
  <li><p>Create a class containing each unique ID as method-name, and a parameter to decide which value to return:</p>
  
  <pre><code>public static class Names
  {
    public static string 12345(string language)
    {
      switch (language)
      {
          case "EN":
              return "Hello";
          case "NO":
              return "Hei";
          default:
              return "Hello";
      }
    }
  }
  </code></pre></li>
  <li><p>Create a class containing a searchable list for each language with ID as key and the value (as value)</p></li>
  </ol>