title: How to read from SQL Server table with RhinoETL framework?
body: <p>Many sample codes on RhinoETL talk about loading from csv files and insert into database. How to perform a read from SQL Server database and output its rows to console ? Do you have a sample code to perform simple dbread and batch read ?</p>
  
  <p>The <a href="https://ayende.com/blog/3102/rhino-etl-2-0" rel="nofollow noreferrer">author's blog</a> showed some sample code, but it appears to be incomplete, or I am missing something.</p>
  
  <p>My non-working code</p>
  
  <pre><code>public class ReadBuildInfos : ConventionInputCommandOperation
  {
      public ReadBuildInfos(ConnectionStringSettings csSettings) : base(csSettings)
      {
          Command = "SELECT Key, Value FROM dbo.BuildInfos WITH (NOLOCK);";
      }
  
      public override IEnumerable&lt;Row&gt; Execute(IEnumerable&lt;Row&gt; rows)
      {
          foreach (Row row in rows)
          {
              yield return row;
          }
      }
  }
  </code></pre>