Code Tests

codetests

// C# 
int totalrows = 1000;
int processed = 0;
while (processed < totalrows)
{
   processRow();
   // bug: infinite loop - we never increment processed var
}

// SqlClient
SqlConnection con;
using (con = new SqlConnection("Data Source=(local);Initial Catalog=myDataBase;Integrated Security=SSPI;"))
{
  DataTable dt = new DataTable();
  SqlDataAdapter da = new SqlDataAdapter("select * from person", con);
  da.Fill(dt); // bug: dt won't be available to code below - should be outside of using statement
}

foreach (DataRow row in dt) // bug: should be dt.Rows
{
  processRow();
}

// JS
var agent = {
  leads: [],
  init: function() {
    $.get('/agent/1', function(data) {
      this.leads = data; // bug: this !== agent 
    });
  }
};
agent.init();


// SQL
select l.* from listing
join listingphoto lp on lp.listingid = l.listingid -- l.* will fail because no alias declared
where l.boardid = 1