Welcome to the Lounge

andegre wrote:

BY Stackoverflow.

SqlConnection conn = new SqlConnection(connString);
string sql = @"select * from MyTable";
SqlCommand cmd = new SqlCommand(sql, conn);
conn.Open();
SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
if (rdr.HasRows) 
{
   while (rdr.Read())
   {
     //do something with record
   }
   rdr.Close();
}

SqlConnection conn = new SqlConnection(connString);
string sql = @"select * from MyTable";
IEnumerable<object> flatResult = conn.Query<dynamic>(sql);

Quote:

If you get a bad tattoo, just what were you inking?